Database drivers

Hi friend,


There are four types of JDBC drivers known as:

* JDBC-ODBC bridge plus ODBC driver, also called Type 1.
* Native-API, partly Java driver, also called Type 2.
* JDBC-Net, pure Java driver, also called Type 3.
* Native-protocol, pure Java driver, also called Type 4.


Read for more information.

http://www.roseindia.net/jdbc/introduction.shtml

http://www.roseindia.net/jdbc/jdbc-driver-and-its-types.shtml


Thanks.

Hi!
we have four types of drivers.

JDBC-ODBC Bridge Driver
Native-API partly Java driver
JDBC-Net pure Java driver
Native-protocol pure Java driver

Very simply, I will explain about these four drivers:

1. Jdbc Odbc Driver:
using this driver, the jdbc can be accessed via odbc Driver. But odbc has some limitations that it should be installed manually in all the client machines. Therefore, it is not recommended for larger networks.

2. Native API, Partly java:
this driver converts the jdbc calls into client api for sybase/oracle and dbms. This driver is also not recommended for larger networks, because some binary code is to be installed manually in all the client machines.


3. Jdbc Net Pure java Driver:
This driver converts the jdbc calls into independent dbms net protocol. Again the server which translates this protocol into dbms.

4. Native Protocol:
this driver converts the jdbc calls into network protocol used by the server directly.

Types of JDBC driver

Type 1 = JDBC-ODBC driver
Type 2 = JDBC Native Api
Type 3 = JDBC 100% pure java
Type 4=  JDBC 100% java

if you want anything pl mail me