my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes Driver types Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Driver types" Watch "Driver types" New topic

Driver types

Shilpa Jain

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 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

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.
I agree. Here's the link:
subject: Driver types
It's not a secret anymore!