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

jguser do-not-reply at jboss.com
Mon Mar 9 13:13:21 EDT 2009


Hello, 
      I have a doubt in the behavior of the connection pool of the Jboss.
We are using JBoss 4.0.2 with java version "1.5.0_10"

I'm trying to understand the behavior of the ConnectionCount in relation with the InUseConnectionCount, and it seems like the JBoss create connections that he don't realy use.
I'm being looking in the source of JBoss to understand this but I can't find much about it.

Our datasource configuration is:

  <local-tx-datasource>
    <jndi-name>XXXXXXX</jndi-name>
    <connection-url>XXXXXXX</connection-url>
    <driver-class>XXXXXXX</driver-class>
    <user-name>XXXXXXX</user-name>
    XXXXXXX
    <min-pool-size>5</min-pool-size>
    <max-pool-size>40</max-pool-size>
    <idle-timeout-minutes>5</idle-timeout-minutes>
    <check-valid-connection-sql>some valid sql select</check-valid-connection-sql>
  </local-tx-datasource>



For example, a common behavior of one normal day, sometimes we have 40 ConnectionCount (the max-pool configurated) where is only 5 InUseConnection.
We have a average of a 16.88 of difference between de ConnectionCount and InUseConnectionCount


Anyone can tell me wich is the behavior of the connection pool?? When he creates new connection that re don't realy needs?

Thanks

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

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



More information about the jboss-user mailing list