Types of JDBC Drivers
There are 4 types of drivers are present in JDBC. Each driver will have their advantages as well as disadvantages. Lets take a look into all drivers. Type 1: JDBC-ODBC driver: This driver receieves all JDBC calls and sends to ODBC ( Open Database Connectivity). ODBC driver understands these calls and communicates with the database library provided by the vendor. So, the ODBC driver, and the vendor database library must be present on the client machine. Advantages: The JDBC-ODBC Bridge allows access to almost any database, since databases ODBC drivers are already available on the client machine. Disadvantages: The performance of this driver is poor, since the JDBC call goes through the bridge to the ODBC driver, then to the native database connectivity library. The result comes back through the reverse process. Type 2: Native API-partly Java driver: It converts JDBC calls into database specific calls with the help of vendor database library. The type2 dr...