JDBC Architecture
Overview
In this tutorial, we will understand the high-level JDBC architecture with a picture.
JDBC Architecture
The major component of are as follows:
- Java Application
- JDBC API
- JDBC Driver
- Database
A high-level JDBC Architecture is shown below:
Java Application
Java application is the user defined Java program that wants to interact with the database. A Java application a set of classes, interfaces and other programming artifacts that can run on JVM.
JDBC API
The JDBC API defines a set of Interfaces and Classes for making database connection in a Java application. JDBC API allows us to execute SQL statements inside Java application code. It provides us the remote database access and enables the application to interact with the backend database.
JDBC Driver
JDBC Driver is connector program that acts like middleware between JDBC API and the backend database. There are several databases out there from different vendors. The most popular databases are Oracle, MySQL, MSSQL, DB2, Teradata, etc. We need different JDBC drivers to interact with different databases.
Database
A relational database is a collection of tables, views and other artifacts. RDBMS is the system that is capable of holding data and management of the data.
The Java application invokes the JDBC API and the JDBC API loads the JDBC driver to interact with the database.
—
Java Tutorial on this website:
https://www.testingdocs.com/java-tutorial/
For more information on Java, visit the official website :