I've configured my DB connection pool as follows: context.xml
<Resource name="jdbc/myserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="xxx" password="xxx" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://a.b.c:3306/Test" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true" /> web.xml <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/myserver</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> In my code, I use a javax.sql.DataSource object to get connections and call connection.close() to return connections. How do I get stats on the connection pool? I would like to check how many connections are active/idle at any point in time. Thanks, Dhiren
