You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by Mike Gorman <mi...@rivermine.com> on 2005/03/04 11:26:26 UTC

[DBCP] API to get connection pool statistics?

We'd like to be able to report on how many connections are in use, how
many are available, etc.  Is there an accessible API to get those
statistics?
 
Regards,
 
Mike Gorman
Chief Software Architect
Rivermine Software
The smarter way to manage telecom.
http://www.rivermine.com <http://www.rivermine.com/> 
mike.gorman@rivermine.com
w: 703.652.4906
c: 803.318.8090
 

Re: [DBCP] API to get connection pool statistics?

Posted by Dirk Verbeeck <di...@pandora.be>.
The methods you are looking for are:
ds.getNumActive() => in use
ds.getNumIdle() => available in pool
ds.getMaxActive() - ds.getNumActive() => available for use

-- Dirk


Mike Gorman wrote:
> We'd like to be able to report on how many connections are in use, how
> many are available, etc.  Is there an accessible API to get those
> statistics?
>  
> Regards,
>  
> Mike Gorman
> Chief Software Architect
> Rivermine Software
> The smarter way to manage telecom.
> http://www.rivermine.com <http://www.rivermine.com/> 
> mike.gorman@rivermine.com
> w: 703.652.4906
> c: 803.318.8090
>  
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


RE: [DBCP] API to get connection pool statistics?

Posted by Alfredo Ledezma Melendez <al...@mail.telcel.com>.
Maybe not an API, but a tool. Almost any decent DBMS has one integrated.

Regards,
____________________________________________
Alfredo Ledezma Meléndez.
Consultor Externo de Sistemas de Atención a Clientes
RadioMovil DIPSA, S. A. de C. V.
Ejército Nacional No. 488, Col. Anahuac, C.P. 11570
México D.F.

 -----Original Message-----
From: 	Mike Gorman [mailto:mike.gorman@rivermine.com]
Sent:	Friday, March 04, 2005 4:26 AM
To:	Jakarta Commons Users List
Subject:	[DBCP] API to get connection pool statistics?

We'd like to be able to report on how many connections are in use, how
many are available, etc.  Is there an accessible API to get those
statistics?

Regards,

Mike Gorman
Chief Software Architect
Rivermine Software
The smarter way to manage telecom.
http://www.rivermine.com <http://www.rivermine.com/>
mike.gorman@rivermine.com
w: 703.652.4906
c: 803.318.8090



---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org