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

[Glauber Ribeiro]

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&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101201/bf0b97cc/attachment.html