JDBC DRIVER MANAGER TYPES

TYPES OF JDBC DRIVER There are 4 types of JDBC drivers. Commonest and most efficient of which are type 4 drivers. Here is the description of each of them: 1. JDBC Type 1 Driver - They are JDBC-ODBC Bridge drivers ie. Translate JDBC into ODBC and use Windows ODBC built in drivers. They delegate the work of data access to ODBC API. They are the slowest of all. SUN provides a JDBC/ODBC driver implementation. 2. JDBC Type 2 Driver - They mainly use native API for data access ie. Converts JDBC to data base vendors native SQL  calls and provide Java wrapper classes to be able to be invoked using  JDBC drivers like Type 1 drivers; requires installation of binaries on each client. 3. JDBC Type 3 Driver - Translates JDBC to a DBMS independent network protocol. They are written in 100% Java and use vendor independent Net-protocol to access a vendor independent remote listener. This listener in turn maps the vendor independent calls to vender dependent ones. This extra step adds complexity and decreases the data access efficiency. 4. JDBC Type 4 Driver - They are also written in 100% Java and are the most efficient among all driver types. It compiles into the application, applet or servlet; doesn’t require anything to be installed on client machine, except JVM. It also converts JDBC directly to native API used by the RDBMS.

TYPES OF JDBC DRIVER MANAGER 1. The JDBC-ODBC Bridge plus ODBC driver : The JDBC-ODBC Bridge plus ODBC driver is a JavaSoft Bridge protocol that provides JDBC access via ODBC drivers. 2. Native-API partly-Java driver : Native-API partly-Java driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix or other DBMS. 3.JDBC-Net pure Java driver: JDBC-Net pure Java driver translates JDBC calls into DBMS independent net protocol. 4. Native-protocol pure Java driver : Native-protocol pure Java driver convert JDBC calls to network protocols used by the DBMSs directly.