Informix JDBC Driver Programmer's Guide
Chapter 1: Getting Started
Contents
Index
What Is a JDBC Driver?
The
JDBC
API
defines the Java interfaces and classes that programmers use to connect to databases and send queries. A
JDBC
driver implements these interfaces and classes for a particular
DBMS
vendor.
A Java program that uses the
JDBC
API
loads the specified driver for a particular
DBMS
before it actually connects to a database. The
JDBC
DriverManager
class then sends all
JDBC
API
calls to the loaded driver.
There are four types of
JDBC
drivers:
JDBC
-
ODBC
bridge plus
ODBC
driver, also called Type 1.
Translates
JDBC
API
calls into Microsoft
ODBC
calls that are then passed to the
ODBC
driver. The
ODBC
binary code must be loaded on every client machine that uses this type of driver.
ODBC
is an acronym for Open Database Connectivity.
Native-API partly Java driver, also called Type 2.
Converts
JDBC
API
calls into
DBMS
-specific client
API
calls. Like the bridge driver, this type of driver requires that some binary code be loaded on each client machine.
JDBC
-Net pure-Java driver, also called Type 3.
Sends
JDBC
API
calls to a middle-tier net server that translates the calls into
DBMS
-specific network protocol. The translated calls are then sent to a particular
DBMS
.
Native-protocol pure-Java driver, also called Type 4.
Converts
JDBC
API
calls directly into the
DBMS
-specific network protocol without a middle tier. This allows the client applications to connect directly to the database server.
Informix JDBC Driver Programmer's Guide
, Version 1.22
Copyright © 1998, Informix Software, Inc. All rights reserved.