13
Connection Pooling and Caching

This chapter discusses the Oracle JDBC implementations of 1) data sources, a standard facility for specifying resources to use, including databases; 2) connection pooling, which is a framework for caches of database connections; and 3) connection caching, including documentation of a sample Oracle implementation. You will also find related discussion of Oracle JDBC support for the standard Java Naming and Directory Interface (JNDI).

The following topics are discussed:

• Data Sources

• Connection Pooling

• Connection Caching

  Notes: This chapter discusses features of the JDBC 2.0 Optional Package, formerly known as the JDBC 2.0 Standard Extension API, which are available through the javax packages from Sun Microsystems. These packages are not part of the standard JDK, but relevant packages are included with the classes111.zip and classes12.zip files.

For further introductory and general information on these topics, refer to the Sun Microsystems specification for the JDBC 2.0 Optional Package.

---