cancel
Showing results for 
Search instead for 
Did you mean: 

jdbc type driver

SOLVED
Go to solution
Shivkumar
Super Advisor

jdbc type driver

Dear Sirs;

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

Thanks,
Shiv
3 REPLIES
Arunvijai_4
Honored Contributor
Solution

Re: jdbc type driver

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
"A ship in the harbor is safe, but that is not what ships are built for"
Yogeeraj_1
Honored Contributor

Re: jdbc type driver

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Joseph Loo
Honored Contributor

Re: jdbc type driver

hi shiv,

really should try to google but anyway:

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

regards.
what you do not see does not mean you should not believe