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
|