different JDBC drivers available



Share on Google+Share on Google+

different JDBC drivers available
1 Answer(s)      6 years and 7 months ago
Posted in : JDBC

What are the different JDBC drivers available?

View Answers

November 12, 2010 at 4:40 PM

Hi friends,

There are four categories of JDBC drivers..

TYPE1 : JDBC-ODBC bridge driver -- It use a bridge technology to connect a java client to an ODBC database.It requires a sort of non_java software to be installed on machine running your code and the are implemented using native code.

Type2 : Native-API Partly Java Drivers -- The Native to API driver converts JDBC commands to DBMS-specific native calls. This is much like the restriction of Type 1 drivers. The client must have some binary code loaded on its machine. These drivers do have an advantage over Type 1 drivers because they interface directly with the database.

TYPE3 : Network protocal/ pure java driver -- The JDBC-Net drivers are a three-tier solution. This type of driver translates JDBC calls into a databaseindependent network protocol that is sent to a middleware server. This server then translates this DBMSindependent protocol into a DBMS-specific protocol, which is sent to a particular database. The results are then routed back through the middleware server and sent back to the client. This type of solution makes it possible to implement a pure Java client. It also makes it possible to swap databases without affecting the client.

TYPE4 : Native-protocol/ fully java driver -- These are pure Java drivers that communicate directly with the vendor's database. They do this by converting JDBC commands directly into the database engine's native protocol. This driver has no additional translation or middleware layer, which improves performance tremendously.



Related Tutorials/Questions & Answers:
different JDBC drivers available
different JDBC drivers available  What are the different JDBC drivers available
jdbc drivers
jdbc drivers  what are the various kinds of jdbc drivers explain in detail
type 4 drivers - JDBC
type 4 drivers  Hi! What is the syntax for Type - 4 drivers. give me any sample code. Thanks in advance..  Hi Friend, Please visit the following link: http://www.roseindia.net/jdbc/jdbc-driver-and-its
Database drivers - JDBC
.   Hi friend, There are four types of JDBC drivers known...-types.shtml Thanks.  Hi! we have four types of drivers. JDBC-ODBC... drivers: 1. Jdbc Odbc Driver: using this driver, the jdbc can be accessed via
Drivers  How to insert Drivers in jdbc for java
Write to the log used by DriverManager and JDBC drivers.
Write to the log used by DriverManager and JDBC drivers.  How can I write to the log used by DriverManager and JDBC drivers
Types of JDBC drivers
of different environment. 3.The JDBC Client driver written in java, communicates...JDBC Driver's Type JDBC Driver can be broadly categorized into 4 categories-- JDBC-ODBC BRIDGE DRIVER(TYPE 1)  Features 1.Convert the query
The required JDBC drivers to establish connectivity to my database part of the JDK.
The required JDBC drivers to establish connectivity to my database part of the JDK.  Are all the required JDBC drivers to establish connectivity to my database part of the JDK
Java JDBC driver
Java JDBC driver  What are the different JDBC drivers available
A Brief Introduction to JDBC
to learn JDBC to develop java Data Access Application to different database to different database applications using different JDBC drivers. JDBC.... JDBC Driver Types There are 4 types of JDBC drivers available. Type 1: JDBC
List of JDBC Driver
List of JDBC Drivers JDBC driver is a software component, which enables.... The table given below shows the list of JDBC drivers... database we need its JDBC driver. Therefore we requires JDBC driver for database
Class.forName will do while loading drivers
Class.forName will do while loading drivers  What Class.forName will do while loading drivers
!  Hello,There are four types of JDBC drivers. There are mainly four type of JDBC drivers available. They are:Type 1 : JDBC-ODBC Bridge Driver A JDBC-ODBC bridge provides JDBC API access via one or more ODBC drivers. Note that some
jdbc  why do we need to load jdbc drivers before connecting to database
Understanding the JDBC Architecture
Database drivers Driver manager The JDBC API... databases. The location of the driver manager with respect to the JDBC drivers... drivers. Type 1 JDBC-ODBC Bridge. Type 1 drivers act as a "bridge
JDBC Driver
JDBC Driver  I want to know the clear syntax and usages of $ types of JDBC drivers. Where can i get it? I search for it, nobody give Syntax for tat different drivers. can u give a sample codes for tat
how to connect mySql drivers into eclipse(configuration)?
how to connect mySql drivers into eclipse(configuration)?  how to connect mySql drivers into eclipse(configuration)? I need the configuration in eclipse. what do i have to download from mySql and just downloading is enough or do
jdbc - JDBC
drivers for concurrent access?   Question: Is the JDBC-ODBC Bridge... from different threads. The JDBC-ODBC Bridge uses synchronized methods... concurrent access from different threads. The JDBC-ODBC Bridge uses
JDBC Examples, JDBC Example code
JDBC or Java Database Connectivity is the set of API for accessing the database from Java program. JDBC allows the developers to access almost all the major databases. Appropriate database drivers are available for all major databases
java - JDBC
and the drivers. It keeps track of the drivers that are available and handles establishing...java  drivermanager class loads the drivers to connect odbc..., The JDBC-ODBC Bridge uses synchronized methods to serialize all
Introduction to the JDBC
in their database driver. A list of currently available JDBC drivers... are JDBC Drivers? JDBC Drivers are set of classes... JDBC Drivers Types Sun has defined four JDBC
Features of JDBC
.style1 { text-align: center; } Feature A JDBC JDBC JDBC java database connectivity (JDBC) is an API (Application Programming Interface) for java that allows the Java programmer to access the Database. The JDBC API
Product Components of JDBC
; is used to provide a means of managing the different types of JDBC database... suite is to make ensure that the  JDBC drivers will run user's program... Product Components of  JDBC   
JDBC features
Database Connectivity or JDBC for short is the API available in Java for accessing... API provides the methods to access the data base easily. JDBC drivers are available for almost all the major database JDBC is the only API
servlet action not available - Struts
servlet action not available  hi i am new to struts and i am getting the error "servlet action not available".why it is displaying this error. Struts Blank Application action org.apache.struts.action.ActionServlet
The JDBC-ODBC Bridge.
The JDBC-ODBC Bridge.  Are there any ODBC drivers that do not work with the JDBC-ODBC Bridge
jdbc - JDBC
jdbc  What is the difference b/w jdbc driver and jdbc driver manager... Class.forName("foo.bah.Driver") The DriverManager will try to load as many drivers... and refer JDBC API. Thanks Rajanikant
jdbc,odbc,MySQL,swing - Java Beginners
jdbc,odbc,MySQL,swing  write a code that displays a menu list of all available database drivers in a window,and allows the user to select any driver... to the selected database driver.It is very well known as jdbc front end of a database
Different JRE
Different JRE  Java is platform independent. The why different JRE's there for differen operating systems