1. Java JDBC
2. JDBC Overview
3. JDBC Driver Types
4. JDBC Connection
5. JDBC: Query the Database
6. JDBC: Update the Database
7. JDBC Statement
8. JDBC ResultSet
9. JDBC PreparedStatement
10. JDBC Batch Updates
11. JDBC: Transactions
12. JDBC: CallableStatement
13. JDBC: DatabaseMetaData

• JDBC Driver Type List
• Type 1 JDBC Driver
• Type 2 JDBC Driver
• Type 3 JDBC Driver
• Type 4 JDBC Driver

A JDBC driver is a set of Java classes that implement the JDBC interfaces, targeting a specific database. The JDBC interfaces comes with standard Java, but the implementation of these interfaces is specific to the database you need to connect to. Such an implementation is called a JDBC driver. JDBC drivers are typically supplied by the database vendor, but may sometimes be provided by the developer community around a database.

JDBC Driver Type List

There are four different JDBC driver types. These driver types are:

• Type 1: JDBC-ODBC bridge JDBC driver
• Type 2: Java + Native code JDBC driver
• Type 3: All Java + Middleware translation JDBC driver
• Type 4: All Java JDBC driver.

Today, most JDBC drivers are type 4 drivers. Nevertheless, I will just discuss the 4 types of JDBC drivers shortly.

Type 1 JDBC Driver

A type 1 JDBC driver consists of a Java part that translates the JDBC interface calls to ODBC calls. An ODBC bridge then calls the ODBC driver of the given database. Type 1 drivers are (were) mostly intended to be used in the beginning, when there were no type 4 drivers (all Java drivers). Here is an illustration of how a type 1 JDBC driver is organized:

Type 1 JDBC driver.

Type 2 JDBC Driver

A type 2 JDBC driver is like a type 1 driver, except the ODBC part is replaced with a native code part instead. The native code part is targeted at a specific database product. Here is an illustration of a type 2 JDBC driver:

Type 2 JDBC driver.

Type 3 JDBC Driver

A type 3 JDBC driver is an all Java driver that sends the JDBC interface calls to an intermediate server. The intermediate server then connects to the database on behalf of the JDBC driver. Here is an illustration of a type 3 JDBC driver:

Type 3 JDBC driver.

Type 4 JDBC Driver

A type 4 JDBC driver is an all Java driver which connects directly to the database. It is implemented for a specific database product. Today, most JDBC drivers are type 4 drivers. Here is an illustration of how a type 4 JDBC driver is organized:

Type 4 JDBC driver.