Thanks. But this doesn't give me information like, say my pool is 10 connections, and my application is getting more traffic and those connections are all used up and there are 5 other callers waiting for a free connection, that informaiton isn't exposed and I want to create counters somehow to monitor this.
On Fri, Oct 19, 2012 at 8:53 AM, Mark Shifman <mark.shif...@yale.edu> wrote: > 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-unsubscribe@tomcat.**apache.org<users-unsubscr...@tomcat.apache.org> > For additional commands, e-mail: users-h...@tomcat.apache.org > >
