Performance overhead since the calls have to go through the JDBC( java database connectivity) bridge to the ODBC(open database connectivity) driver, then to the native database connectivity interface (thus may be slower than other types of drivers). AdvantagesĪlmost any database for which an ODBC driver is installed can be accessed, and data can be retrieved. Type 1 drivers also don't support the complete Java command set and are limited by the functionality of the ODBC driver. This technology isn't suitable for a high-transaction environment. The other implication is that any application using a type 1 driver is non-portable given the binding between the driver and platform.

The use of this driver is discouraged if the alternative of a pure-Java driver is available. Also, the use of this driver leads to other installation dependencies for example, ODBC must be installed on the computer having the driver and the database must support an ODBC driver. 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.

The driver converts JDBC method calls into ODBC function calls.

The JDBC type 1 driver, also known as the JDBC-ODBC bridge, is a database driver implementation that employs the ODBC driver to connect to the database.

Java 8 jdbc odbc bridge