What is JDBC Driver and JDBC Architecture

JDBC stands for Java Database Connectivity. JDBC drivers helps you to open database connection and to interact with it by executing SQL queries then receiving the results with Java. The Java.sql namespace that ships JDK has various classes with their behaviors defined and their actual implementation are done in the third-party drivers.

The JDBC Library contains API’s for each of the task usually related with database usage :

• Making a connection to a database
• Creating SQL statements
• Running SQL queries in the database
• Viewing, Editing and Deleting the records.

JDBC Architecture
Generally the JDBC architecture consists of two layers :

1. JDBC API : Provides the application to JDBC Manager connection.
2. JDBC Driver API : Supports the JDBC Manager to Driver connection.

The JDBC API uses a driver manager and database specific drivers to supply transparent connectivity to databases.

The JDBC driver manager ensures that the right driver used to access every data source. The driver manager in capable of supporting multiple concurrent drivers connected to multiple databases.

Below is the architectural diagram, that shows the location of the driver manager with the JDBC drivers amd the Java Application :

That's it!