hi all,
i have an application that has a conn pool with initial size of 30 connections.
i'm controling the db sessions and for hours i see 30 sessions on db.
but after a time the number of connections are starting to become higher and higher.
in a minute it becomes to 400 connections.
here is the output of jdbc monitor session:
NumConnCreated 153 Count
Last Sample Time: Aug 10, 2010 11:51:02 PM
Start Time: Aug 10, 2010 11:48:01 PM
Provides a count value reflecting the number of connections that were created by the pool since the last sampling.
NumConnAcquired 163463 Count
Last Sample Time: Aug 10, 2010 11:51:02 PM
Start Time: Aug 10, 2010 11:48:01 PM
Provides a count value reflecting the number of connections acquired from the pool since the last sampling
NumConnReleased 163451 Count
Last Sample Time: Aug 10, 2010 11:51:02 PM
Start Time: Aug 10, 2010 11:48:01 PM
Provides a count value reflecting the number of connections released back to the pool since the last sampling
also i have seen that only 2 or 3 of the connections are active when there were 600 inactive connections on db.
how can i find the problem?
regards,
[Message sent by forum member 'yavuzs']
http://forums.java.net/jive/thread.jspa?messageID=479811