Обсуждение: Connection Pooling?
This may be a Postgres JDBC question, but it may also be an
Apache Jakarta/Tomcat question...
I recently moved a few of my pages over from PHP to .jsp and
now I notice that I've got postgres backends sitting around, as
though some of my connections are being pooled or persistant.
As far as I can tell, my scripts are correctly closing the
connections, so they shouldn't be sitting around--does anyone
know if there is some automatic pooling/persistant connecting
happening, either in the JDBC driver or in Tomcat? How would I
turn this off or adjust it down?
--
Adam Haberlach | "Pancakes don't make hardly any juice
adam@newsnipple.com | and bacon makes too much."
http://www.newsnipple.com | -- bug-eyed earl
'88 EX500 '00 >^< | http://youlook.org
Adam,
No there isn't automatic pooling in jdbc. I would look over your jsp
again.
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Adam Haberlach
Sent: June 27, 2001 2:45 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Connection Pooling?
This may be a Postgres JDBC question, but it may also be an
Apache Jakarta/Tomcat question...
I recently moved a few of my pages over from PHP to .jsp and
now I notice that I've got postgres backends sitting around, as
though some of my connections are being pooled or persistant.
As far as I can tell, my scripts are correctly closing the
connections, so they shouldn't be sitting around--does anyone
know if there is some automatic pooling/persistant connecting
happening, either in the JDBC driver or in Tomcat? How would I
turn this off or adjust it down?
--
Adam Haberlach | "Pancakes don't make hardly any juice
adam@newsnipple.com | and bacon makes too much."
http://www.newsnipple.com | -- bug-eyed earl
'88 EX500 '00 >^< | http://youlook.org
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Adam Haberlach wrote: > This may be a Postgres JDBC question, but it may also be an > Apache Jakarta/Tomcat question... > > I recently moved a few of my pages over from PHP to .jsp and > now I notice that I've got postgres backends sitting around, as > though some of my connections are being pooled or persistant. > As far as I can tell, my scripts are correctly closing the > connections, so they shouldn't be sitting around--does anyone > know if there is some automatic pooling/persistant connecting > happening, either in the JDBC driver or in Tomcat? How would I > turn this off or adjust it down? SOmething is amiss... How is Apache Tomcat set up? are you using mod_jk? Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html