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:

    Oh, who will now be able to relate how Pantagruel behaved in face of these three hundred giants! Oh my muse, my Calliope, my Thalie, inspire me now, restore my spirits, because here is the ass’s bridge of logic, here is the pitfall, here is the difficulty of being able to describe the horrible battle undertaken.
    François Rabelais (1494–1553)