Oracle Database 10g JDBC driver supports an improved connection caching mechanism, the Implicit Connection Cache. It provides a rich set of features that address connection caching requirements through an efficient database connection caching in the JDBC drivers to optimize database resources and improve scalability. For example, the Implicit connection cache may be set up such that an abandoned connection may be detected and claimed automatically.
Connection Stripping is another useful feature (coming in JDBC 4.0 per JavaOne presentation, but already available in Oracle Database 10g JDBC). This useful feature lets users define their own set of tags or attributes, to enable future connection retrieval. This saves valuable CPU and network round-trips that would otherwise be necessary to set session state.
OTN has just released Connection Cache Callback Sample that demonstrates Connection Caching feature of Oracle Database 10g JDBC driver.
OC4J 10.1.3 will support Implicit Connection Cache out of the box without requiring any setup in the container.
8:17:11 AM 
|
