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

which is advanced deep technology in java launched by the sun microsystem??? The answer is very logical If u need correct answer mail me at priya_gupta@gmail.com

3193


Is a method a function?

551


What is the differences between c++ and java? Explain

588


What are the actions that can occur when a thread enters blocked state?

584


Name some classes present in java.util.regex package.

608






What is a dynamic array in java?

566


What are advantages of exception handling in java?

588


What is floor math?

517


Implement two stacks using a single array.

575


Is alive in java?

508


Can we write method inside a method in java?

526


What is the purpose of tostring() method in java?

554


What is the flag in java?

612


How do you ensure that n threads can access n resources without deadlock?

813


What is a wrapper method?

537