[dbcp] - How to programmatically check the pool status?

[Raffaele Gambelli <rg...@gecod.com>]

Hi all,

I'm using Tomcat 6.0.26 and its default dbcp connection pooling system 
(tomcat-dbcp.jar inside the default installation dir)

My question is:
How could I check programmatically the connection pool status ? For 
example inside a catch of some exception related to some database issues 
I would like to log some info like the number of currenlty open 
connections, idle etc...

Thanks in advance and best regards

-- 

Raffaele Gambelli

_*Gecod s.r.l.*_ <http://gecod.com/it/contatti/index.do>

/Development Area/

phone: +39 051 4075795

fax: +39 051.9525291

e-mail: _rgambelli@gecod.com_ <ma...@gecod.com>

web: _www.gecod.com_ <http://www.gecod.com/>

skype-id: _rgambelli.gecod_ <skype:rgambelli.gecod?add>


/Gecod s.r.l. - Tutti i diritti riservati./

/Il presente messaggio e i documenti allegati possono contenere 
informazioni di carattere confidenziale o riservato. Qualora non foste i 
destinatari, vogliate immediatamente informarci via e-mail ed eliminare 
il messaggio, con gli eventuali allegati senza trattenerne copia./


/Gecod s.r.l. - All rights reserved./

/This message and the enclosed documents may contain information which 
is confidential or privileged. If you are not the intended recipient, 
please advise the sender immediately by reply e-mail and delete this 
message and any attachments without retaining a copy./