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.
