[jboss-user] [Datasource Configuration] - When and why does JBoss open more database connections than the maximum requested?

Glauber Ribeiro [http://community.jboss.org/people/theglauber] created the discussion "When and why does JBoss open more database connections than the maximum requested?" To view the discussion, visit: http://community.jboss.org/message/573910#573910 -------------------------------------------------------------- I have a data source configured like this: <datasources>   <ha-local-tx-datasource> <datasources>   <ha-local-tx-datasource> ...     <min-pool-size>25</min-pool-size>     <max-pool-size>30</max-pool-size>     <validate-on-match>true</validate-on-match>     <background-validation>true</background-validation>     <background-validation-minutes>17</background-validation-minutes>     <prefill>true</prefill>     <set-tx-query-timeout>true</set-tx-query-timeout>     <query-timeout>60</query-timeout>   </ha-local-tx-datasource> </datasources> In my interpretation, his should mean: * start with 25 connections * grow to 30 if needed * but not more than 30 I have seen in several occasions the number of open connections go higher than 30. Some times i could correlate this with high activity, but not always. I've heard the number of connections went once to over 100 with no apparent provocation. Is this a known problem or feature? What triggers it? JBoss version: [4.3.0.GA_CP03 (build: SVNTag=JBPAPP_4_3_0_GA_CP03 date=200810241616)] Thank you for any help or ideas. glauber -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/573910#573910] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]