Overview
In this tutorial, we will understand the high-level JDBC architecture with a picture.
JDBC Architecture
The major components 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 is 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 connections in a Java application. JDBC API allows us to execute SQL statements inside Java application code. It provides remote database access and enables the application to interact with the backend database.
JDBC Driver
JDBC Driver is a 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 a system that is capable of holding data and management of data.
The Java application invokes the JDBC API and the JDBC API loads the JDBC driver to interact with the database.
—
Java Tutorials
Java Tutorial on this website:
https://www.testingdocs.com/java-tutorial/
For more information on Java, visit the official website :
More information about Oracle Database:
https://www.oracle.com/database/