Skip site navigation (1) Skip section navigation (2)

Re: Postmaster not dropping connections on tomcat restart.

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Paul Davis <pjdavis(at)engineering(dot)uiowa(dot)edu>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Postmaster not dropping connections on tomcat restart.
Date: 2004-03-22 15:34:25
Message-ID: 1079969665.1319.144.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-jdbc
Paul,

which pooling implementation are you using and are you explicitly
shutting it down on the servlet destroy method?

Dave
On Wed, 2004-03-17 at 02:59, Paul Davis wrote:
> 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*
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 
-- 
Dave Cramer
519 939 0336
ICQ # 14675561


In response to

pgsql-jdbc by date

Next:From: Paul ThomasDate: 2004-03-22 15:48:26
Subject: Re: Postmaster not dropping connections on tomcat restart.
Previous:From: Oliver JowettDate: 2004-03-22 03:26:23
Subject: Re: absolute positioning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group