Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Servlets and the fly likes To find the run time  connection pool size in jboss3.2.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "To find the run time  connection pool size in jboss3.2.1" Watch "To find the run time  connection pool size in jboss3.2.1" New topic
Author

To find the run time connection pool size in jboss3.2.1

ddd sss
Greenhorn

Joined: Feb 10, 2004
Posts: 1
I am using jboss3.2.1 and sqlserver2000
Can any one help me to find out the run time Connection pool size?I want to do this to increase the perfomance of my website(To make sure the connection is released after use).
my mssql_ds.xml settings is as follows:
<local-tx-datasource>
<jndi-name>mySQLServerPool</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://cataract1:1433;DatabaseName=macstoret</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
macret
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<transaction-isolation>TRANSACTION_SERIALIZABLE</transaction-isolation>
</local-tx-datasource>
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: To find the run time connection pool size in jboss3.2.1