Could you check with the jmx-console?
Interesting values are
- max connectins in use
- created / destroyed
- available con. count
- current in use
Where do you see that new connections are created?
2011-01-11 16:00:01,120 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Returned connection to pool org.jboss.resource.connectionmanager.NoTxConnectionManager$NoTxConnectionEventListener@899fa9[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@15147ea handles=0 lastUse=1294761601120 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@4be496 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@1fbda8c] [InUse/Available/Max]: [7/93/100]
we checked the oracle session only few connections are active and other connections are idle but still it creates new connections instead of using the existing connection from pool.
That's not the expected answer to my question above.
The log shows that the connection is returned to pool.
How does your code looks like (JDBC access or EntityBeans? EIB version?)
And please test what happen if you run the code multiple times, each time a new connection is opened? look to jmx-console statistics
We have identified the issue was in coding the connection was not released one of the function and it created the pool to create new connections.
I thank for your time to respond.