This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Driver types Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Driver types" Watch "Driver types" New topic
Author

Driver types

Shilpa Jain
Greenhorn

Joined: Aug 17, 2000
Posts: 16
Can anyone pls explain me what are the types of drivers, what are they used for and what is the difference between them?
Thank you
Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
Check put java.sun.com/product/jdbc. You will find links to:
#1 JDBC Drivers
#2 Sun's Tutorial's
#3 The answer to you question better than i ever could...
Hope this helps...

------------------
We learn more from our mistake's than from our success's.


Multi Platform Database Developer & DBA on E.S.T.
imran rafi
Greenhorn

Joined: Oct 21, 2000
Posts: 14
Sun has defined four JDBC driver types. These are:
1.Type 1: JDBC-ODBC Bridge Driver
The first type of JDBC dirver is JDBC-ODBC Bridge which provide JDBC access to any ODBC complaint databases through ODBC drivers. Sun's JDBC-ODBC bridge is example of type 1 driver.
2.Type 2: Native -API Partly - Java Driver
Type 2 drivers are developed using native code libraries, which were originally designed for accessing the database through C/C++. Here a thin code of Java wrap around the native code and converts JDBC commands to DBMS-specific native calls.

3.Type 3: JDBC-Net Pure Java Driver
Type 3 drivers are a three-tier solutions. This type of driver
communicates to a middleware component which in turn connects to database and provide database connectivity.

4.Type 4: Native-Protocol Pure Java Driver
Type 4 drivers are entirely written in Java that communicate directly with vendor's database through socket connection. Here no translation or middleware layer, are required which improves performance tremendously.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Driver types