JDBC driver types
JDBC Driver Manager is used to connect java application to the correct JDBC driver
There are four types of JDBC drivers
- JDBC Type 1 Driver
- JDBC Type 2 Driver
- JDBC Type 3 Driver
- JDBC Type 4 Driver
JDBC Type 1 Driver
It is also referred as JDBC-ODBC bridge plus ODBC driver.
This type of driver is useful on corporate network where client installation are not a big problem. It is also useful for the application server code written in java in a 3-tier architecture.
Microsoft established a common standard called Open Database Connectivity (ODBC) which communicates with databases.
The ODBC driver abstract away any vendor-specific protocol & provides a common application programming interface (API) to the database clients. So that user can access more database server
A database client (user) can use ODBC API & can connect to 3 different database servers from different vendors.
A pure Java solution allows JDBC drivers to be automatically downloaded & installed along with the applet.
Javasoft created JDBC-ODBC bridge driver as a temporary solution to get database connectivity. This driver translates JDBC API into the ODBC API & it is used with an ODBC driver
The JDBC-ODBC driver is implemented in binary code as well as java
JDBC Type 2 Driver
Also referred as Native-API partly-Java driver
This driver converts JDBC calls into calls on client API for Oracle, Sybase, Informix or other DBMS.
These drivers are implemented in a combination of binary code & java & must be installed on client machine.
The driver talks to database server in the servers native protocol.
JDBC Type 3 Driver
Also referred as JDBC-Netpure Java Driver
This driver translates JDBC call into DBMS independent net protocol.
This driver is most flexible for internet access & handle additional requirements for security
JDBC Type 4 Driver
Native-Protocol Pure Java Driver
It converts JDBC call to network protocol used by DBMS directly