Advantages of jdbc odbc bridge driver

Why not just use ODBC? The JDBC-ODBC Bridge offers several advantages over "naked" ODBC. The ODBC API is strongly oriented toward C/C++ programmers. The JDBC-ODBC Bridge makes it unnecessary for programmers using the Java programming language to deal with non-Java language concepts. The ODBC API is extremely complex and intermingles high level and low level functions. .  · Advantage of bridge driver. Easy to use; It is a database independent driver; Can be easily connected to any database. This driver software is built-in with JDK so no need to install separately. Disadvantage of bridge drive r. It is a slow driver so not used in real time application; Because of Odbc connectivity it is a platform dependent www.doorway.ruted Reading Time: 1 min.  · It is the ODBC – JDBC bridge driver, it acts as a bridge between JDBC and, ODBC database connectivity mechanism. Using this you can access the databases which support only ODBC. Initially, it is used extensively, since most of the databases supported only ODBC. Whenever Java application sends a request to the JDBC-ODBC bridge driver the request internally calls the ODBC .

The JDBC-ODBC Bridge allows the programmer to rely on the JDBCAPI, which is relatively simple and easy to learn. The JDBC-ODBC Bridge lets a program deal with ODBC through a standardizedJDBC interface. That helps a program avoid being tied to ODBC when a bettersolution comes along. 1. JDBC-ODBC bridge driver: JDBC-ODBC bridge driver is a native code driver which uses ODBC driver to connect with the database. It converts JDBC method calls into ODBC function calls. It is also known as Type 1 driver. Advantages: It can be used with any database for which an ODBC driver is installed. Disadvantages: Performance is not good as it converts JDBC method calls into ODBC function calls. The JDBC-ODBC Bridge allows applications written in the Java programming language to use the JDBC API with many existing ODBC drivers. The Bridge is itself a driver based on JDBC technology ('JDBC driver') that is defined in the class www.doorway.rubcDriver.

Type 1: JDBC-ODBC Bridge. Advantage. The JDBC-ODBC Bridge allows access to almost any database, since the database's ODBC drivers are already available. JDBC-ODBC bridge driver: Use JDBC-ODBC bridge driver for testing JDBC applications against an ODBC (Open We also learned its advantages and limitations. Type-1 driver or JDBC-ODBC bridge driver · Advantages · Disadvantages · Type-2 driver or Native-API driver · Advantages · Disadvantages · Type