-
1. Connection Pool Oracle 10g Jboss 4.2.3 GA problem
wdfink Jan 10, 2011 5:10 AM (in response to rajasundaram)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?
-
2. Connection Pool Oracle 10g Jboss 4.2.3 GA problem
rajasundaram Jan 11, 2011 11:57 AM (in response to wdfink)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.
-
3. Connection Pool Oracle 10g Jboss 4.2.3 GA problem
wdfink Jan 12, 2011 2:09 AM (in response to rajasundaram)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
-
4. Connection Pool Oracle 10g Jboss 4.2.3 GA problem
rajasundaram Jan 16, 2011 5:54 PM (in response to wdfink)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.