Re: Connection pool stats

2010-03-15 Thread Dhiren Bhatia
(for dbcp 1.3) > http://commons.apache.org/dbcp/api-1.3/index.html > > > > Dhiren Bhatia wrote: > > I've configured my DB connection pool as follows: > > > > context.xml > > > > type="javax.sql.DataSource" > > > > maxA

Connection pool stats

2010-03-15 Thread Dhiren Bhatia
I've configured my DB connection pool as follows: context.xml web.xml DB Connection jdbc/myserver javax.sql.DataSource Container 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 connecti

Re: Commons DBCP in Tomcat 6.x

2010-03-09 Thread Dhiren Bhatia
Thanks for the feedback, I've updated the Resource Tag and moved Context to META_INF. I've also changed the code to use javax.sql.DataSource. Is there any way to get the number of active/idle connections like you can with the BasicDataSource object's methods getNumActive etc? How do I get informati

Re: Commons DBCP in Tomcat 6.x

2010-03-09 Thread Dhiren Bhatia
< chuck.caldar...@unisys.com> wrote: > > From: Dhiren Bhatia [mailto:dhiren.for...@gmail.com] > > Subject: Re: Commons DBCP in Tomcat 6.x > > > > Why is it looking for > > org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory? > > For us to answer that, you need

Re: Commons DBCP in Tomcat 6.x

2010-03-09 Thread Dhiren Bhatia
n my way. > > > > -Original Message- > From: Konstantin Kolinko [mailto:knst.koli...@gmail.com] > Sent: Tuesday, March 09, 2010 11:38 AM > To: Tomcat Users List > Subject: Re: Commons DBCP in Tomcat 6.x > > 2010/3/9 Dhiren Bhatia : > > Hi, > > > > I'

Commons DBCP in Tomcat 6.x

2010-03-09 Thread Dhiren Bhatia
Hi, I'm trying to use the commons DBCP package with Tomcat 6.x. I know that the tomcat_dbcp.jar has the commons files renamed, however I would prefer to use the commons jar files so I can use the class org.apache.commons.dbcp.BasicDataSource in my code. To do this, I deleted the tomcat_dbcp.jar f

Tracking open database connections in a pool

2005-10-14 Thread Dhiren Bhatia
Hi, Is there any way to know how many open connections are in the database connection pool? I'd like to know how many connections are active/idle at any point in time. I'm using the javax.sql.DataSource with the MySQL JDBC driver. Tomcat version 5.5.9. Thanks, Dhiren