Thursday, January 17, 2008

JDBC-ODBC Bridge Driver:

The Type 1 driver translates all JDBC calls into ODBC calls and sends them to the ODBC driver. ODBC is a generic API. JDBC-ODBC Bridge Drivers enable a java application to use any database that supports ODBC drivers. Java application cannot directly interact with ODBC driver, for this reason we use JDBC-ODBC Bridge Driver that works as interface b\w application and ODBC driver. To use JDBC-ODBC Bridge Driver you need you installed ODBC driver in your client computer







Advantage
The JDBC-ODBC Bridge allows access to almost any database, since the database's ODBC drivers are already available.

Disadvantages
• 1. Since the Bridge driver is not written fully in Java, Type 1 drivers are not portable.
2. A performance issue is seen as a JDBC call goes through the bridge to the ODBC driver, then to the database, and this applies even in the reverse process. They are the slowest of all driver types.
3. The client system requires the ODBC Installation to use the driver.
4. Not good for the Web.

1 comment:

Ashish Nigam said...

nice contents... wish you continue on this...