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 component of 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 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 :

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

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

  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • Print Triangle Pattern Flowchart
  • RAPTOR Editions
  • Flowgorithm Conditional Breakpoint Statement
  • Flowgorithm Read Numbers from File Example
  • Search Text File Flowchart Example
  • Flowgorithm Turtle Graphics Symbols
  • Draw Circle using Flowgorithm Turtle

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version