skip to main content
Troubleshooting : Troubleshooting Connection Pooling : Example: Pool Manager Trace File
 

Try DataDirect Cloud Now

Example: Pool Manager Trace File

The following example shows a DataDirect Connection Pool Manager trace file. Notes provide explanations for the referenced text to help you understand the content of your own Pool Manager trace files.
The parameters with which the connection pool was created display on the *** ConnectionPool Created line and include the following:
*JNDI name used to look up the connection pool: jdbc/CloudSparkyPool 
*DataSource class associated with the connection pool: com.ddtek.jdbc.ddcloud.DDCloudDataSource 
*Initial pool size (number of connections created upon initialization): 5 
*Min pool size (number of connections to be kept open): 5 
*Max pool size (maximum number of connections at any one time):10 
*User establishing the connection: DDUser 
jdbc/CloudSparkyPool:
*** ConnectionPool Created (jdbc/CloudSparkyPool,
com.ddtek.jdbc.ddcloud.DDCloudDataSource@1835282, 5, 5, 10, DDUser)
jdbc/CloudSparkyPool: Number pooled connections = 0.
jdbc/CloudSparkyPool: Number free connections = 0.
jdbc/CloudSparkyPool: Enforced minimum! 1
NrFreeConnections was: 0
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 5.

jdbc/CloudSparkyPool: Reused free connection. 2
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 4.

jdbc/CloudSparkyPool: Reused free connection.
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 3.

jdbc/CloudSparkyPool: Reused free connection.
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 2.

jdbc/CloudSparkyPool: Reused free connection.
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 1.

jdbc/CloudSparkyPool: Reused free connection.
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 0.

jdbc/CloudSparkyPool: Created new connection. 3
jdbc/CloudSparkyPool: Number pooled connections = 6.
jdbc/CloudSparkyPool: Number free connections = 0.

jdbc/CloudSparkyPool: Created new connection.
jdbc/CloudSparkyPool: Number pooled connections = 7.
jdbc/CloudSparkyPool: Number free connections = 0.

jdbc/CloudSparkyPool: Created new connection.
jdbc/CloudSparkyPool: Number pooled connections = 8.
jdbc/CloudSparkyPool: Number free connections = 0.

jdbc/CloudSparkyPool: Created new connection.
jdbc/CloudSparkyPool: Number pooled connections = 9.
jdbc/CloudSparkyPool: Number free connections = 0.

jdbc/CloudSparkyPool: Created new connection.
jdbc/CloudSparkyPool: Number pooled connections = 10.
jdbc/CloudSparkyPool: Number free connections = 0.

jdbc/CloudSparkyPool: Created new connection.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 0.

jdbc/CloudSparkyPool: Connection was closed and added to the cache. 4
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 1.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 2.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 3.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 4.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 5.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 6.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 7.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 8.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 9.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 10.

jdbc/CloudSparkyPool: Connection was closed and added to the cache.
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 11.

jdbc/CloudSparkyPool: Enforced minimum! 5
NrFreeConnections was: 11
jdbc/CloudSparkyPool: Number pooled connections = 11.
jdbc/CloudSparkyPool: Number free connections = 11.

jdbc/CloudSparkyPool: Enforced maximum! 6
NrFreeConnections was: 11
jdbc/CloudSparkyPool: Number pooled connections = 10.
jdbc/CloudSparkyPool: Number free connections = 10.

jdbc/CloudSparkyPool: Enforced minimum!
NrFreeConnections was: 10
jdbc/CloudSparkyPool: Number pooled connections = 10.
jdbc/CloudSparkyPool: Number free connections = 10.

jdbc/CloudSparkyPool: Enforced maximum!
NrFreeConnections was: 10
jdbc/CloudSparkyPool: Number pooled connections = 10.
jdbc/CloudSparkyPool: Number free connections = 10.

jdbc/CloudSparkyPool: Enforced minimum!
NrFreeConnections was: 10
jdbc/CloudSparkyPool: Number pooled connections = 10.
jdbc/CloudSparkyPool: Number free connections = 10.

jdbc/CloudSparkyPool: Enforced maximum!
NrFreeConnections was: 10
jdbc/CloudSparkyPool: Number pooled connections = 10.
jdbc/CloudSparkyPool: Number free connections = 10.

jdbc/CloudSparkyPool: Dumped free connection. 7
jdbc/CloudSparkyPool: Number pooled connections = 9.
jdbc/CloudSparkyPool: Number free connections = 9.

jdbc/CloudSparkyPool: Dumped free connection.
jdbc/CloudSparkyPool: Number pooled connections = 8.
jdbc/CloudSparkyPool: Number free connections = 8.

jdbc/CloudSparkyPool: Dumped free connection.
jdbc/CloudSparkyPool: Number pooled connections = 7.
jdbc/CloudSparkyPool: Number free connections = 7.

jdbc/CloudSparkyPool: Dumped free connection.
jdbc/CloudSparkyPool: Number pooled connections = 6.
jdbc/CloudSparkyPool: Number free connections = 6.

jdbc/CloudSparkyPool: Dumped free connection.
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 5.

jdbc/CloudSparkyPool: Dumped free connection.
jdbc/CloudSparkyPool: Number pooled connections = 4.
jdbc/CloudSparkyPool: Number free connections = 4.

jdbc/CloudSparkyPool: Dumped free connection.
jdbc/CloudSparkyPool: Number pooled connections = 3.
jdbc/CloudSparkyPool: Number free connections = 3.

jdbc/CloudSparkyPool: Dumped free connection.
jdbc/CloudSparkyPool: Number pooled connections = 2.
jdbc/CloudSparkyPool: Number free connections = 2.

jdbc/CloudSparkyPool: Dumped free connection.
jdbc/CloudSparkyPool: Number pooled connections = 1.
jdbc/CloudSparkyPool: Number free connections = 1.

jdbc/CloudSparkyPool: Dumped free connection.
jdbc/CloudSparkyPool: Number pooled connections = 0.
jdbc/CloudSparkyPool: Number free connections = 0.

jdbc/CloudSparkyPool: Enforced minimum! 8
NrFreeConnections was: 0
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 5.

jdbc/CloudSparkyPool: Enforced maximum!
NrFreeConnections was: 5
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 5.

jdbc/CloudSparkyPool: Closing a pool of the group
jdbc/CloudSparkyPool 9
jdbc/CloudSparkyPool: Number pooled connections = 5.
jdbc/CloudSparkyPool: Number free connections = 5.

jdbc/CloudSparkyPool: Pool closed 10
jdbc/CloudSparkyPool: Number pooled connections = 0.
jdbc/CloudSparkyPool: Number free connections = 0.

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.