Hi Peter,
Thank you so much for the reply and sorry for the confusion. Actually I was depicting the value connectionTimeout="20000" for the AJP port. The http port is not in use and has been commented.
Here is what the mssql-ds.xml file looks like.
<datasources>
<local-tx-datasource>
<jndi-name>DS</jndi-name>
<connection-url>
jdbc:sqlserver://xxx.xxx.xxx.xxx:1433;database=abc</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>user</user-name>
<password>password</password>
<min-pool-size>500</min-pool-size>
<max-pool-size>4000</max-pool-size>
<blocking-timeout-millis>10000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>MS SQLSERVER2000</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
We have set the max-pool-size to 4000. I was eager to know why our ConnectionCount is always rising and not resetting even when the application is idle. Since the timeout is set to 10 seconds i was thinking that the connection count should decrease as the connections are timed out. Please help me if i have misunderstood. Also the InUseConnectionCount has a value in thousands even when the application is idle. Do they increase until the AvailableConnectionCount reaches the MinSize? Shouldn't they reset after the connections are terminated?
Any help will be greatly appreciated.
Thank You
Lochan Serma