• JDBC Tutorial

• What is JDBC
• SQL Syntax
• JDBC Driver Types
• JDBC Simple Program
• JDBC Statement interface
• JDBC ResultSet interface
• JDBC PreparedStatement
• JDBC CallableStatement
• JDBC ResultSetMetaData
• JDBC DatabaseMetaData
• JDBC Transaction Management
• JDBC Batch Processing
• Step by Step JDBC Program
• JDBC Select Program
• JDBC Insert Program
• JDBC Update Program
• JDBC Delete Program
• JDBC Image Insert Example
• JDBC Image Read Example
• JDBC Scrollable ResultSet
• JDBC Updatable ResultSet
• JDBC Interview Questions

JDBC Driver Types

JDBC Driver is a software component that enables java application to interact with the database. There are 4 types of JDBC drivers:

1. 1. JDBC-ODBC bridge driver
2. 2. Native-API driver (partially java driver)
3. 3. Network Protocol driver (fully java driver)
4. 4. Thin driver (fully java driver)

1) JDBC-ODBC bridge driver

The 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 calls. This is now discouraged because of thin driver.

2) Native-API driver

The Native API driver uses the client-side libraries of the database. The driver converts JDBC method calls into native calls of the database API. It is not written entirely in java.

3) Network Protocol driver

The Network Protocol driver uses middleware (application server) that converts JDBC calls directly or indirectly into the vendor-specific database protocol. It is fully written in java.

4) Thin driver

The thin driver converts JDBC calls directly into the vendor-specific database protocol. That is why it is known as thin driver. It is fully written in Java language.