[WEBINAR] The New Normal: Dealing with the Reality of an Unsecure World

Java Database Connectivity Architecture (JDBC Architecture)

Definition - What does Java Database Connectivity Architecture (JDBC Architecture) mean?

Java Database Connectivity (JDBC) architecture is an API specifying interfaces for accessing relational databases. JDBC helps to connect to a database, send queries and updates to the database, and retrieve and process the results obtained from the database for queries.

Techopedia explains Java Database Connectivity Architecture (JDBC Architecture)

JDBC is a core part of the Java platform and is an API specification developed by Sun Microsystems. The JDBC architecture supports two-tier and three-tier processing models for accessing a database.

In the two-tier model, a Java applet or application communicates directly to the data source. The JDBC driver enables communication between the application and the data source. When a user sends a query to the data source, the answers for those queries are sent back to the user in the form of results. The data source may not always be a single machine located at a single place. It can be located on a different machine on a network to which a user is connected. This is known as a client/server configuration, where the user’s machine acts as a client and the machine having the data source running acts as the server. The network connection can be intranet or Internet.

In the three-tier model, the user’s commands or queries are sent to middle-tier services, from which the commands are again sent to the data source. The results are sent back to the middle tier, and from there to the user. This type of model is found very useful by management information system directors, as it makes it simple to maintain access control and make updates to corporate data. Application deployment also becomes easy and provides performance benefits. The middle tier is usually written in C or C++.

The JDBC driver manager is a traditional backbone of the JDBC architecture, which specifies objects for connecting Java applications to a JDBC driver. The JDBC Test Suite helps to ensure that the JDBC drivers will run the program. The JDBC-ODBC Bridge software offers JDBC access via the open database connectivity drivers.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
"Techopedia" on Twitter

Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.