Friday, July 20, 2012

Introduction to JDBC

JDBC stands for Java Database Connectivity allows developers to connect, query and update a database using the Structured Query Language. JDBC API standard provides Java developers to interact with different RDBMS and access table data through Java application without learning RDBMS details and using Database Specific JDBC Drivers.

2.  JDBC Architecture

JDBC makes the interaction with RDBMS simple and intuitive. When a Java application needs to access database:

open connection to database,

use JDBC driver to send SQL queries to database,

process the results that are returned, and

close the connection.

JDBC uses two architectures to communicate with database:

1) The driver connects to database and executes SQL statements. Results are sent back from driver to driver manager and finally to the application.
2) The JDBC driver communicates with ODBC driver. ODBC driver executes SQL query and then results are sent back to JDBC driver to driver manager and then to application.

1. Introduction to JDBC
2. JDBC Architecture 
3. Interaction of JDBC with Database 
4. Introduction to Hibernate 
5. Hibernate Architecture 
6. Hibernate Communication with RDBMS 
7. Hibernate vs. JDBC 
7.1. Advantage of Hibernate over JDBC 
7.2. Disadvantages of Hibernate