JDBC Drivers Types
JDBC driver implementations vary because of the wide variety of operating systems and hardware platforms in which Java operates. Sun has divided the implementation types into four categories, Types 1, 2, 3, and 4, which is explained below: Type 1: JDBC-ODBC Bridge Driver: 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. ODBC: Open Database Connectivity is a standard C programming language middleware API for accessing database management systems (DBMS). When Java first came out, this was a useful driver because most databases only supported ODBC access but now this type of driver is recommended only for experimental use or when no other alternative is available. Fig1:Type1 Driver Advantages Almost any database for which ODBC driver is installed, can be accessed. Disadvantages Performan...