• JNDI_name is the JNDI name used to look up the connection pool (for example, jdbc/openAccessPool).
• DataSource_class is the DataSource class associated with the connection pool (for example com.ddtek.jdbcx.openaccess.OpenAccessDataSource).
• initial_pool_size is the number of physical connections created when the connection pool is initialized (for example, 5).
• min_pool_size is the minimum number of physical connections that will be kept open in the connection pool (for example, 5).
• max_pool_size is the maximum number of physical connections allowed within a single pool at any one time. When this number is reached, additional connections that would normally be placed in a connection pool are closed (for example, 10).
• user is the name of the user establishing the connection (for example, scott).
1. The Pool Manager checks the pool size. Because the minimum pool size is five connections, the Pool Manager creates new connections to satisfy the minimum pool size.
2. The driver requests a connection from the connection pool. The driver retrieves an available connection.
3. The driver requests a connection from the connection pool. Because a connection is unavailable, the Pool Manager creates a new connection for the request.
4. A connection is closed by the application and returned to the connection pool.
5. The Pool Manager checks the pool size. Because the number of connections in the connection pool is greater than the minimum pool size, five connections, no action is taken by the Pool Manager.
6. The Pool Manager checks the pool size. Because the number of connections in the connection pool is greater than the maximum pool size, 10 connections, a connection is closed and discarded from the pool.
7. The Pool Manager detects that a connection was idle in the connection pool longer than the maximum idle timeout. The idle connection is closed and discarded from the pool.
8. The Pool Manager detects that the number of connections dropped below the limit set by the minimum pool size, five connections. The Pool Manager creates new connections to satisfy the minimum pool size.
9. The Pool Manager closes one of the connection pools in the pool group. A pool group is a collection of pools created from the same PooledConnectionDataSource call. Different pools are created when different user IDs are used to retrieve connections from the pool. A pool group is created for each user ID that requests a connection. In our example, because only one user ID was used, only one pool group is closed.
10. The Pool Manager closed all the pools in the pool group. The connection pool is closed.
