Thread: 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