tomcat datasource, find active connections

[Ashish Kulkarni]

Hi
I have following in context.xml, and it works fine.
But i would like to find how many active connections are there in data
source or how many total connections are there?
1 is it possible to do so?

2 Can i change type javax.sql.DataSource
to com.ibm.as400.access.AS400JDBCDataSource, as this has methods to find
active connections etc?

<Resource name="jdbc/mydev"  auth="Container"
 type="javax.sql.DataSource"
                  maxActive="2"
                  maxIdle="2"
                  maxWait="3000"
                  username="user"
                  password="pass"
                  driverClassName="com.ibm.as400.access.AS400JDBCDriver"
                  url="jdbc:as400://1mysystem;date format=iso;time
format=iso;errors=basic;trace=false;"
                  validationQuery="select * from   mytable" />


-- 
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com