Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Right Answer is:
Type 1
SOLUTION
- Type 1 JDBC driver (are) the JDBC-ODBC bridge.
- Each database product that supports JDBC (all the major database vendors do) provides a JDBC driver that must be dynamically loaded in order to access the database from Java.
- In fact, loading the driver must be done first, before connecting to the database.
- 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 JDBC-ODBC bridge driver is distributed as part of the JDBC package and essentially translates JDBC calls into ODBC.
- For many of the smaller databases, such as FoxPro or Access, using the JDBC-ODBC Bridge may be the only way to integrate them with Java.