Thread: Connection Pooling?

Connection Pooling?

From
Adam Haberlach
Date:
    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

RE: Connection Pooling?

From
"Dave Cramer"
Date:
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



Re: Connection Pooling?

From
Tony Grant
Date:
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