JDBC Connection Pooling

Anybody know how to use the Oracle JDBC Connection Pooling/Caching? I have been using my own object pooling class and extending it to create a JDBC Connection Pool successfully for at least a year. I would prefer to use the standard pooling mechanism in the JDBC 2.0 Optional Package. But Oracle's implementation does not seem to provide the same functionality.

Briefly, I need to:
- have one instance of a pool for my JVM (singleton)

• create java.sql.Connection instances as nessessary
• return the connection instance to the pool when finished
• have the connection in the pool close after a set period of timeout

I have been using OracleConnectionPoolDataSource, PooledConnection, and OracleConnectionCacheImpl but cannot get the required functionality. Received on Wed May 03 2000 - 00:00:00 CDT