View RSS Feed

JDBC

Type 1: JDBC-ODBC Bridge

Rate this Entry
by , 04-27-2012 at 06:58 PM (1006 Views)
The type 1 driver, JDBC-ODBC Bridge, translates all JDBC calls into ODBC (Open DataBase Connectivity) calls and sends them to the ODBC driver. As such, the ODBC driver, as well as, in many cases, the client database code, must be present on the client machine. Figure 1 shows a typical JDBC-ODBC Bridge environment.

Pros
The JDBC-ODBC Bridge allows access to almost any database, since the database's ODBC drivers are already available. Type 1 drivers may be useful for those companies that have an ODBC driver already installed on client machines.

Cons
The performance is degraded since the JDBC call goes through the bridge to the ODBC driver, then to the native database connectivity interface. The result comes back through the reverse process. Considering the performance issue, type 1 drivers may not be suitable for large-scale applications.
The ODBC driver and native connectivity interface must already be installed on the client machine. Thus any advantage of using Java applets in an intranet environment is lost, since the deployment problems of traditional applications remain.

Submit "Type 1: JDBC-ODBC Bridge" to Facebook Submit "Type 1: JDBC-ODBC Bridge" to Digg Submit "Type 1: JDBC-ODBC Bridge" to del.icio.us Submit "Type 1: JDBC-ODBC Bridge" to StumbleUpon Submit "Type 1: JDBC-ODBC Bridge" to Google

Categories
Driver

Comments