Working with Databases in Java - Beginning Java Programming: The Object-Oriented Approach - page 316

taBle 9-4: (continued)

driver t ype description

JDBC type 2
driver

This driver converts JDBC calls into client-side API calls, which will then further com-
municate to the network database.

JDBC type 3
driver

This is a 100% Java driver whereby JDBC calls are translated to the protocol
adopted by a separate middleware application server, which then further communi-
cates to the database.

JDBC type 4
driver

This is a 100% Java driver whereby JDBC calls are directly translated into the net-
work protocol used by the database.

From Table 9-4, it is clear that the JDBC type 4 driver is the most powerful. Its workings are further
clarified in Figure 9-8.

Java Application

JDBC API

JDBC Driver Manager

Vendor-Specific JDBC Type 4 Driver

Database

figure 9-8

Table 9-5 describes the core JDBC classes and methods.

taBle 9-5: JDBC Classes and Purpose

JdBc cl ass purpose

DriverManager

Locate the JDBC driver.

Connection Set up a database connection.

Statement Define a static SQL statement.