Scribd
Upload
5 views1 page

Notebook

The document provides an overview of JDBC (Java Database Connectivity), detailing its components such as the JDBC API, DriverManager, and the various types of JDBC drivers. It explains the role of JDBC drivers as client-side adapters that facilitate communication between Java applications and databases. Additionally, it categorizes JDBC drivers into four types, highlighting the Type-1 and Type-2 drivers and their functionalities.

Uploaded by

namrata.paropate
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views1 page

Notebook

The document provides an overview of JDBC (Java Database Connectivity), detailing its components such as the JDBC API, DriverManager, and the various types of JDBC drivers. It explains the role of JDBC drivers as client-side adapters that facilitate communication between Java applications and databases. Additionally, it categorizes JDBC drivers into four types, highlighting the Type-1 and Type-2 drivers and their functionalities.

Uploaded by

namrata.paropate
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Sign Up

1. Application: It is a java applet or a servlet that communicates with a data source.


2. The JDBC API: The JDBC API allows Java programs to execute SQL statements and retrieve results. Some of the
important interfaces defined in JDBC API are as follows: Driver interface , ResultSet Interface , RowSet Interface
PreparedStatement interface, Connection inteface, and Classes defined in JDBC API are as follows:
DriverManager class, Types class, Blob class, clob class.
3. DriverManager: It plays an important role in the JDBC architecture. It uses some database-specific drivers to
effectively connect enterprise applications to databases.
4. JDBC drivers: To communicate with a data source through JDBC, you need a JDBC driver that intelligently
communicates with the respective data source.

JDBC drivers

JDBC drivers are client-side adapters (installed on the client machine, not on the server) that convert requests from
Java programs to a protocol that the DBMS can understand.
JDBC drivers are the software components which implements interfaces in JDBC APIs to enable java application to
interact with the database.
There are four types of JDBC drivers:

Type-1 driver:
This driver acts as a bridge between JDBC and ODBC (Open Database Connectivity). It converts JDBC method calls
into ODBC calls and sends them to the ODBC driver.

Type-2 driver:
This driver converts JDBC calls into database-specific calls using native libraries provided by the database vendor. It is
also known as a partially Java driver because it relies on native code.

 

Report Abuse

You might also like