Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the major differences between the 4 types of JDBC driver?

April 26, 2017differences driver JDBC types

0

Posted

What are the major differences between the 4 types of JDBC driver?

1 Answer

0

Posted

The most important characteristic of a JDBC driver is whether it is 100% pure Java implementation of the JDBC API. This breaks the 4 types of JDBC driver into two groups. Type-3 and Type-4 drivers are written in 100% pure Java code while the Type-1 and Type-2 are not. For example, the ODBC-JDBC bridge is a Type-1 driver, and the IDS JDBC Driver is a Type-3 driver. The proper function of Type-1 and Type-2 drivers rely completely or partially on native binary modules. These binary modules are platform specific. As a result these types of driver do not support Java applets deployed over the internet because: (a) Java does not support the distribution (download) of native binary modules. (b) Normally downloaded applets are prohibited from accessing native modules. (c) Java programs must be pre-installed on client machines before it can be run. (d) It is unfeasible to deploy applets to anonymous clients. A Type-3 JDBC driver like the IDS JDBC Driver or a Type-4 driver do not have all of the