JDBC Type 2 Driver(Native-API driver)

In Type 2 driver, JDBC API calls are converted into native C/C++ API calls which are unique to the database. These drivers typically provided by the database vendors and used in the same manner as the JDBC-ODBC Bridge, the vendor-specific driver must be installed on each client machine.

If we change the Database we have to change the native API as it is specific to a database and they are mostly obsolete now but you may realize some speed increase with a Type 2 driver, because it eliminates ODBC's overhead.

jdbc_type2.JPG_driver

The Oracle Call Interface (OCI) driver is an example of a Type 2 driver.

Advantage :

Serves as the fastest driver compared to other type of drivers.

Disadvantages :

  • Requires native libraries which must be installed on client machine since the conversion from JDBC calls to database specific native calls is done on the client machine.
  • Allows the database specific native functions to be executed on the client JVM process and any bug in this driver can crash JVM.
  • Increases the cost of the application id the application needs to run on different platforms.
Our Services:

Java Training | Python Training | Machine Learning with Python Training | Deep Learning with Python Training | Data Science with Python Training | Projects

SILAN Technology, BBSR
Call to: 9439202111  |  9658317757  |  0674-2361252

Comment