From: | Paul Davis <pjdavis(at)engineering(dot)uiowa(dot)edu> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Postmaster not dropping connections on tomcat restart. |
Date: | 2004-03-17 07:59:04 |
Message-ID: | F5D238F1-77E8-11D8-8ED2-0003936B766C@engineering.uiowa.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Dear List,
I've finally managed to get connection pooling going in tomcat. I've
noticed that when i reload my web app the postmaster will not drop any
of the connections.
Basically the order of things is I start Tomcat, check out my servlet
and there's a connection that shows up to the postmaster. Now while
I've been doing some development I notice that when i reload my web app
that the connection stays around. And after enough connections are
just sitting there, it doesn't allow me to make anymore. It gives a
JDBC error about not being able to make any more connections without
superuser status.
I'm not even sure if this would be a problem in production, but right
now I'm finding it quite annoying to have to restart tomcat on a
regular basis.
Before I get flamed, I just want to note that I'm only asking here
because I don't even know if this is a postgresql problem or a tomcat
one. So I'm asking on both mailing lists.
Thanks,
Paul Davis.
*Insert witty quote*
From | Date | Subject | |
---|---|---|---|
Next Message | Fuchs Clemens | 2004-03-17 15:19:24 | BYTEA with large files leads to OutOfMemory |
Previous Message | Kris Jurka | 2004-03-17 07:29:07 | Re: Register arbitrary types Framework |