JDBC Driver - Type 1 Driver - JDBC-ODBC Bridge

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. The driver converts JDBC method calls into ODBC function calls.

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. Also, 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 use of this driver is discouraged if the alternative of a pure-Java driver is available. The other implication is that any application using a type 1 driver is non-portable given the binding between the driver and platform. This technology isn't suitable for a high-transaction environment. Type 1 drivers also don't support the complete Java command set and are limited by the functionality of the ODBC driver.

Sun provides a JDBC-ODBC Bridge driver: sun.jdbc.odbc.JdbcOdbcDriver. This driver is native code and not Java, and is closed source.

Read more about this topic:  JDBC Driver, Type 1 Driver

Famous quotes containing the word bridge:

    Crime seems to change character when it crosses a bridge or a tunnel. In the city, crime is taken as emblematic of class and race. In the suburbs, though, it’s intimate and psychological—resistant to generalization, a mystery of the individual soul.
    Barbara Ehrenreich (b. 1941)