tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oscar Carrillo <tom...@daydream.stanford.edu>
Subject Re: OT: db pool problems - jdbc connection count?
Date Thu, 30 Oct 2003 18:18:19 GMT
How about just watching the processes for postgresql while you access the 
site?:

ps auxw | grep "postgres"

Oscar

On Thu, 30 Oct 2003, john-paul delaney wrote:

> Hello List...
> 
> Sorry if this is off-topic.  Although I think I'm following the
> jndi-resources-howto fairly well, I find I'm running out of connections
> and I have to restart tomcat to free them up.  I'd like to know how many
> jdbc connections are in use at any given time with the intention of
> finding the offending servlet(s).  I'm using postgreSQL.  I've googled
> and looked at the postgres user lists but not found an example on how to
> detect the current number of connections in use.  Can anyone help?
> 
> tomcat 4.1.24
> postgresql 7.3.3
> pg73jdbc3.jar
> commons-pool 1.0.1
> 
> I believe I'be been pretty thorough in closing down resultsets, preparedstatements and
connections after use, and use the removeAbandoned parameter in the DataSource Resource section
of server.xml.
> 
> Any leads are much appreciated.
> 
> thanks
> /j-p.
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 


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


Mime
View raw message