JDBC Architecture

Java Architecture is consist of Java Application, JDBC API, DriverManager, Driver and Database.

Java Application is our client program which contains JDBC API client logic and our bussiness logic.

JDBC API:

JDBC ( Java Database Connectivity) API  provides the connectivity between Java application and Database. Java application can communicate with any Database with the help of DriverManager and Database specific Driver.

 

JDBC Architecture

 

DriverManager:

DriverManager is responsible to manage all Database Drivers available in our Application.

DriverManager will register and un-register Database Drivers.

DriverManager.registerDriver(Driver);
DriverManager.unregisterDriver(Driver);

 

DriverManager can establish the connection to the Database with the help of Driver Software.

Connection con = DriverManager.getConnection(jdbcURL, userName, password);

 

Driver:

Driver software acts as a bridge between Java application and Database. It is responsible to convert Java calls into Database specific calls and vice versa.

 

Database:

A database is a collection of information that is organized so that it can be easily accessed, managed and updated.

Example: MySQL, Oracle, Maria DB etc..

Java application is Database independent but Driver Software is Database dependent. Database software provides Database specific logic and it will make our java application as Database independent.

 

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s