Types Of JDBC Drivers

JDBC driver is a software that makes the Java Application to interact with database. JDBC drivers are divided into four categories.

1. JDBC-ODBC bridge
2. Native-API Driver
3. Network-Protocol Driver(Middle Ware Driver)
4. Database-Protocol Driver(Pure Java Driver)

Type1 Driver : JDBC-ODBC bridge

Type1 driver also known as JDBC-ODBC bridge, translates JDBC interface calls to ODBC calls. JDBC-ODBC bridge then calls the ODBC driver of given database. The driver is platform-dependent as it makes use of ODBC which in turn depends on native libraries of the underlying operating system the JVM is running upon.

 

Type 2 Driver - Native-API Driver

Type 2 driver is also known as Native-API driver, is a database driver implementation that uses the client-side libraries of the database. The driver converts JDBC method calls into native calls of the database.

Type 3 Driver - Network-Protocol Driver(MiddleWare Driver)

Type3 driver sends the JDBC driver calls to intermediate server. The intermediate serever connects to the database.

Type 4 Driver - Database-Protocol Driver(Pure Java Driver)

Type 4 driver written completely in Java, converts JDBC calls directly into a vendor-specific database protocol. The major benefit of using a type 4 jdbc drivers are that they are completely written in Java to achieve platform independence and eliminate deployment administration issues.

Prevoius                                                 Next                                                 Home