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:

    I was at work that morning. Someone came riding like mad
    Over the bridge and up the road—Farmer Rouf’s little lad.
    Bareback he rode; he had no hat; he hardly stopped to say,
    “Morgan’s men are coming, Frau, they’re galloping on this way.
    Constance Fenimore Woolson (1840–1894)