On 10/18/2012 02:51 PM, S Ahmed wrote:
Hi,

When using the jdbc connection pool library, would it be possible to
somehow record the # of connections that are being used, when the # of
connections in the pool are being saturated etc., or is that something that
would have to be modified in the library itself?
You can see the connections by doing an appropriate select on your database.  
For oracle select v$session like

select username, program, machine, client_identifier, osuser,logon_time,  sid, 
serial#
from v$session where osuser != 'oracle' order by program, machine, 
client_identifier, logon_time

There is also a simple way to see the connections in mysql but I can't remember 
it

i.e. assuming I have can keep track of these counters, is there a way to
monitor these events in the library or would the jdbc library itself need
to be modified to expose these events?


--
 Mark Shifman MD. Ph.D.
 Yale Center for Medical Informatics
 Phone (203)737-5219
 mark.shif...@yale.edu


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to