Oracle in a Nutshell

JDBC

JDBC is a standard, low-level Java API to databases. This section concentrates on the Oracle implementation of the JDBC standard set of interfaces.

Oracle uses a set of packages to implement the standard JDBC interface. In Oracle9i, the packages are:

oracle.jdbc

Consists of interfaces that extend the java.sql.Connection, java.sql.MetaData, java.sql.PreparedStatement, and java.sql.Savepoint interfaces and the classes to implement them. This package is new in Oracle9i. In Oracle8i, some of the interfaces defined in this class were implemented as classes in a variety of different packages, as shown in Table 11-2. The interfaces and packages in this class, for both Oracle8i and Oracle9i, are covered in the following sections.

oracle.jdbc.driver

In Oracle9i, handles the implementation of the interfaces of the oracle.jdbc library. Because the classes in this package simply implement the interfaces, this package is not documented in this chapter. In Oracle8i, the interfaces were not defined in the oracle.jdbc library.

oracle.jdbc.pool

Used to manage Oracle Connection Pooling. Because relatively few developers use this feature of Oracle, this package is not documented in this chapter.

oracle.jdbc.xa*

New with Oracle9i. The oracle.jdbc.xa and oracle.jdbc.xa.client packages are relevant only to developers using the XA distributed transaction protocol and are therefore not documented in this chapter.

oracle.sql

Consists of interfaces used by classes in the library and to handle user-defined datatypes ...