[jboss-user] [JCA/JBoss] - Re: ConnectionCount and InUseConnectionCount behavior

[jguser]

"PeterJ" wrote : The ConnectionCount is the total number of connections that have been established since JBoss AS started. Consider this scenario. An app accesses the database so 5 connections (min-pool-size) are created. Then the app gets busy and it needs more connections, let's say a total of 20 connections. At this point both InUseConnectionCount and ConnectionCount are 20. The the app is no longer busy, so after 5 minutes (idle-timeout-minutes) the number of connections in use (InUseConnectionCount) goes back down to 5. At this point ConnectionCount is still 20. Later the app gets busy again and let's assume that 25 connections are required. Thus 20 new connections were created. At this point ConnectionCount is 40 and InUseConnectionCount is 25. Then the app is no longer busy and those connections are no longer needed, so the InUseConnectionCount goes back down to 5. But ConnectionCount is still at 40.
  | 
  | Hope this helps.

I think you are confused with the ConnectionCreatedCount parameter.
The ConnectionCount is the number of connection established to the database, but not necessarily in use. Every idle-timeout-millis time the connections that was idle for more than that time, es be destroyed, so ConnectionCount decrease. 

I have a graphic showing the value of this two parameters in time, but i don't know how to put it here to show you what I meen to say.

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4216338#4216338

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4216338