| From: | Ben Carterette <bcarterette(at)mail(dot)liberty(dot)k12(dot)mo(dot)us> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | my connections never die |
| Date: | 2001-05-10 16:11:05 |
| Message-ID: | 3AFABD99.615BCF2D@mail.liberty.k12.mo.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm running a web server on one machine (Apache 1.3+Tomcat 3.2+mod_jk)
with some databases (postgresql 7.1), and a dedicated database server on
another machine (postgresql 7.0.2). A lot of my web pages establish a
connection to a database on either machine and store the Connection
object in a session so's I don't have to create a new one every page.
Well, it seems these connections, which never get explicitly closed, are
never dying. Some of them, anyway. I haven't been able to predict
which ones are going to close themselves and which ones will stay open
for days, but some of them are still taking up a process days later.
Greatly appreciating any explanation,
Ben Carterette
bcarterette(at)mail(dot)liberty(dot)k12(dot)mo(dot)us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl DeBisschop | 2001-05-10 16:19:00 | Re: Norm SQL? |
| Previous Message | Bruce Momjian | 2001-05-10 16:09:42 | Re: [GENERAL] Oracle to Pg tool |