• TestingDocs
TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

JDBC

JDBC Architecture

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:

 

JDBC Architecture

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 :

https://www.oracle.com/java/

More information about Oracle Database:

https://www.oracle.com/database/

Related Posts

tnsnames File Oracle TestingDocs

JDBC /

Connect to Oracle Database using JDBC Thin Driver

Display Oracle Database Table JDBC

JDBC /

Display data from Oracle Database table using JDBC

JDBC API TestingDocs

JDBC /

JDBC API Components

JDBC /

JDBC ResultSet Interface

Configure Build Path Eclipse

JDBC /

Configure JDBC Driver in Java Project

› Types of JDBC Drivers

Recent Posts

  • How to secure your SQL Database: Tips and Tricks
  • Shaping the Future of Development: Exploring Key Trends in Software Engineering
  • Improving Java Performance with Multithreading
  • Difference between PHP and JavaScript?
  • Bing Conversation Styles
  • ChatGPT Introduction
  • Open Source AI Frameworks
  • Artificial Intelligence Tools
  • Top AI Music Applications
  • Top AI Website Design Tools

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com