jdbc type driver

[Shivkumar]

Dear Sirs;

What are the type 1, 2, 3, and 4 driver with regard to jdbc ?

Thanks,
Shiv

[Arunvijai_4 · Accepted solution]

Hi Shiv,

* Type 1: JDBC-ODBC Bridge
* Type 2: Native-API/partly Java driver
* Type 3: Net-protocol/all-Java driver
* Type 4: Native-protocol/all-Java driver

Type 1: JDBC-ODBC Bridge
The type 1 driver, JDBC-ODBC Bridge, translates all JDBC calls into ODBC (Open DataBase Connectivity) calls and sends them to the ODBC driver.

Type 2: Native-API/partly Java driver
JDBC driver type 2 -- the native-API/partly Java driver -- converts JDBC calls into database-specific calls for databases such as SQL Server, Informix, Oracle, or Sybase.

Type 3: Net-protocol/all-Java driver
JDBC driver type 3 -- the net-protocol/all-Java driver -- follows a three-tiered approach whereby the JDBC database requests are passed through the network to the middle-tier server.

Type 4: Native-protocol/all-Java driver
The native-protocol/all-Java driver (JDBC driver type 4) converts JDBC calls into the vendor-specific database management system (DBMS) protocol so that client applications can communicate directly with the database server.

-Arun

[Yogeeraj_1]

hi shiv,

see also:
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm

and:
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/intro.html#1018502

hope this helps!

regards
yogeeraj

[Joseph Loo]

hi shiv,

really should try to google but anyway:

http://java.sun.com/developer/onlineTraining/Programming/JDCBook/jdbc.html#driver

regards.