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.
The Oracle Call Interface (OCI) driver is an example of a Type 2 driver.
Serves as the fastest driver compared to other type of drivers.
- 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.
Java Training | Python Training | Machine Learning with Python Training | Deep Learning with Python Training | Data Science with Python Training | Projects
Silansoftware Pvt.Ltd, BBSR Call to: 0674-2361252