0 Replies Latest reply on Mar 6, 2006 6:53 AM by robertovieira

    SQLServer Connection Pooling

    robertovieira

      Hi, i'm trying to stablish a connection pool with a SQLServer DB.

      The problem i'm getting is that even setting the max-pool-size parameter to 50, there are a lot more connections stablished.

      I am guessing that i should limit the number of subpools or somethig, but i don´t find the way to do this. I am using the following datasource descriptor.


      <datasources>
       <local-tx-datasource>
       <jndi-name>jdbc/SQLServerDS</jndi-name>
       <connection-url>jdbc:microsoft:sqlserver://SQLDEV:1433;DatabaseName=MyDB</connection-url>
       <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
       <user-name>myUser</user-name>
       <password>myPwd</password>
       <!--pooling parameters-->
       <min-pool-size>5</min-pool-size>
       <max-pool-size>50</max-pool-size>
       <PreparedStatementCacheSize>15</PreparedStatementCacheSize>
       <blocking-timeout-millis>15000</blocking-timeout-millis>
       <idle-timeout-minutes>10</idle-timeout-minutes>
       <track-statements>false</track-statements>
       </local-tx-datasource>
      </datasources>



      I would appreciate any hint.
      Thanks in advance for your help.