What are the two major components of JDBC?

Answer Posted / ravi

JDBC has four Components:

1. The JDBC API.
2. The JDBC Driver Manager.
3. The JDBC Test Suite.
4. The JDBC-ODBC Bridge.

1. The JDBC API.

The JDBC application programming interface provides the
facility for accessing the relational database from the
Java programming language. The API technology provides the
industrial standard for independently connecting Java
programming language and a wide range of databases. The user
not only execute the SQL statements, retrieve results, and
update the data but can also access it anywhere within a
network because of it's "Write Once, Run Anywhere" (WORA)
capabilities.

Due to JDBC API technology, user can also access other
tabular data sources like spreadsheets or flat files even in
the a heterogeneous environment. JDBC application
programmming interface is a part of the Java platform that
have included Java Standard Edition (Java SE ) and the Java
Enterprise Edition (Java EE) in itself.

The JDBC API has four main interface:

The latest version of JDBC 4.0 application programming
interface is divided into two packages
i-) java.sql
ii-) javax.sql.

Java SE and Java EE platforms are included in both the packages.

2. The JDBC Driver Manager.

The JDBC Driver Manager is a very important class that
defines objects which connect Java applications to a JDBC
driver. Usually Driver Manager is the backbone of the JDBC
architecture. It's very simple and small that is used to
provide a means of managing the different types of JDBC
database driver running on an application. The main
responsibility of JDBC database driver is to load all the
drivers found in the system
properly as well as to select the most appropriate driver
from opening a connection to a database. The Driver Manager
also helps to select the most appropriate driver from the
previously loaded drivers when a new open database is
connected.

3. The JDBC Test Suite.

The function of JDBC driver test suite is to make ensure
that the JDBC drivers will run user's program or not . The
test suite of JDBC application program interface is very
useful for testing a driver based on JDBC technology during
testing period. It ensures the requirement of Java
Platform Enterprise Edition (J2EE).

4. The JDBC-ODBC Bridge.

The JDBC-ODBC bridge, also known as JDBC type 1 driver is a
database driver that utilize the ODBC driver to connect
the database. This driver translates JDBC method calls into
ODBC function calls. The Bridge implements Jdbc for any
database for which an Odbc driver is available. The Bridge
is always implemented as the sun.jdbc.odbc Java package and
it contains a native library used to access ODBC.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When do we use hashset over treeset?

522


What is the format specifier?

508


What is array in java?

527


I want to persist data of objects for later use. What is the best approach to do so?

587


What is jagged array in java?

519






Why string is not a wrapper class?

636


What is a top level class in java?

521


I am a fresher and know core java, c languge, html, css etc if I am illegible for any job then send it on my email tatranakshay276@gmail.com

1066


How many static init can you have?

671


how we can create packages in java?

509


What is flush buffer?

510


What are different access specifiers in java? Explain

618


How can you make sure that your singleton class will always return single instance in multi-threaded environment?

562


Does treeset allow null in java?

502


What is the final keyword in java?

543