Explain four 4 types of jdbc drivers

Today, there are five types of JDBC drivers in use: Type 1: JDBC-ODBC bridge Type 2: partial Java driver Type 3: pure Java driver for database middleware Type 4: pure Java driver for direct-to-database Type 5: highly-functional drivers with superior performance. Type 4 JDBC Driver 1. The major benefit of using a type 4 jdbc drivers are that they are completely written in Java to achieve platform 2. Number of translation layers is very less i.e. type 4 JDBC drivers don't have to translate database requests to ODBC 3. You don’t need to install special.  · There are 4 types of JDBC drivers: Type-1 driver or JDBC-ODBC bridge driver; Type-2 driver or Native-API driver; Type-3 driver or Network Protocol driver; Type-4 driver or Thin driver. Type-1 driver. Type-1 driver or JDBC-ODBC bridge driver uses ODBC driver to connect to the database. The JDBC-ODBC bridge driver converts JDBC method calls into the ODBC function www.doorway.ruted Reading Time: 4 mins.

Both Type 1 and Type 2 JDBC driver types mix a Java-based API with another API. The following figure shows a side-by-side comparison of the implementation of each of the JDBC driver types. All four implementations show a Java application or applet using the JDBC API to communicate through the JDBC Driver Manager with a specific JDBC driver type. 4. Not good for the Web. Type 2 JDBC Driver. Native-API/partly Java driver. The distinctive characteristic of type 2 jdbc drivers are that Type 2 drivers convert JDBC calls into database-specific calls i.e. this driver is specific to a particular database. Some distinctive characteristic of type 2 jdbc drivers are shown below. There is a total of 4 types of JDBC drivers that exist in Java. They are known as type 1, 2, 3, and 4 drivers. In order to understand the difference between different JDBC drivers, the first and most important thing to understand is why Java has so many types of JDBC drivers? Why not just one? the answer lies in portability and performance.

It requires database-specific coding to be done in the middle tier. 4. Thin driver: Thin driver is a pure java driver which converts JDBC calls directly into. Type 2 JDBC Driver · 1. Native API must be installed in the Client System and hence type 2 drivers cannot be used for the Internet. · 2. Like Type 1 drivers, it's. Type 1: JDBC-ODBC bridge JDBC driver · Type 2: Java + Native code JDBC driver · Type 3: All Java + Middleware translation JDBC driver.