[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: JBoss JMXConsole ManagedConnection Pool Question

[PeterJ]

This is the number of connections created over time, not the number of currently active connections - that should never go over 200 based on you settings.

Example: your app opens a connection and 100 connections are created. Then the app asks for more connections. At some point the app reaches 200 connections. Then everyone goes to lunch and the number of connections drops down to 100. Everyone comes back from lunch and the app is busy and you again have 200 connections. Total connections create at this point is 300.

One other point - if there is no app activity, and the connection timeout happens, the existing 100 connections will be dropped and 100 new connections opened (there was another post about this - a search for "postgresql connection" should turn it up). Thus even in a system that is not doing anything you can see the total number of connections created increase.

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

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