[GENERAL] Problem with leaking connections

2009-09-03 Thread Mark Lange
Hi, we have an webapplication running on tomcat6 with hibernate. We are using the apache DBCP connection pool (tomcat built in) and an postgres 8.19 database server on an different host. Every few days the pool is running out of connections. The pool is configured to aggressively close

Re: [GENERAL] Problem with leaking connections

2009-09-03 Thread Joshua D. Drake
On Thu, 2009-09-03 at 17:55 +0200, Mark Lange wrote: Hi, The pool is configured to aggressively close connections when it is exhausted, but the application gets very slow when this happens, mostly we have to restart the tomcat server. #ps –aux | grep postgres on the database host shows

Re: [GENERAL] Problem with leaking connections

2009-09-03 Thread Andy Colson
Mark Lange wrote: Hi, we have an webapplication running on tomcat6 with hibernate. We are using the apache DBCP connection pool (tomcat built in) and an postgres 8.19 database server on an different host. Every few days the pool is running out of connections. The pool is configured