Different types of jdbc odbc drivers

6 rows · Type1 driver: JDBC-ODBC bridge driver: Type2 driver: Native API/partly JDBC driver: Estimated Reading Time: 10 mins. JDBC-ODBC bridge driver. Native-API driver. Network-Protocol driver. Thin driver. 1. JDBC-ODBC bridge driver: JDBC-ODBC bridge driver is a native code driver which uses ODBC driver to connect with the database. It converts JDBC method calls into ODBC function calls. It is also known as Type 1 driver.  · The JDBC-ODBC Bridge allows applications written in the Java programming language to use the JDBC API with many existing ODBC drivers. The Bridge is itself a driver based on JDBC technology ('JDBC driver') that is defined in the class www.doorway.rubcDriver.

JDBC drivers are client-side adapters (installed on the client machine, not on the server) that convert requests from Java programs to a protocol that Type-1 driver or JDBC-ODBC bridge driver. Type-2 driver or Native-API driver. Type-3 driver or Network Protocol driver. Type-4 driver or Thin. Type 1 JDBC drivers are used for testing JDBC applications against an ODBC data source. Type 2 JDBC drivers require a native database API to be used. Both Type 1 and Type 2 JDBC driver types mix a Java-based API with another API. The different types of jdbc drivers are: Type 1: JDBC-ODBC Bridge driver (Bridge) Type 2: Native-API/partly Java driver (Native) Type 3: AllJava/Net-protocol driver (Middleware) Type 4: All Java/Native-protocol driver (Pure) 4 types of jdbc drivers are elaborated in detail as shown below: Type 1 JDBC Driver. JDBC-ODBC Bridge driver.

The Type 1 driver translates all JDBC calls into ODBC calls and sends them to the ODBC driver. ODBC is a generic API. The JDBC-ODBC Bridge driver is recommended. The four types are: Type 1: JDBC-ODBC Bridge; Type 2: Native-API/partly Java driver; Type 3: Net-protocol/all-. Java JDBC Driver with 4 types of JDBC drivers: JDBC-ODBC bridge driver, Native-API driver, Network Protocol driver, Thin driver. There are given advantages.