JDBC driver types

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.

Untitled

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

Untitled

 

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

Untitled

 

JDBC Type 4 Driver

 Native-Protocol Pure Java Driver
 It converts JDBC call to network protocol used by DBMS directly

Untitled

Leave a Reply

Your email address will not be published. Required fields are marked *