Re: Postmaster not dropping connections on tomcat restart.

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
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:48:26
Message-ID: 20040322154826.A23344@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


On 17/03/2004 07: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.

Is the connection pool defined within you web app's context?

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message dinakar 2004-03-22 16:15:02 Re: Postmaster not dropping connections on tomcat restart.
Previous Message Dave Cramer 2004-03-22 15:34:25 Re: Postmaster not dropping connections on tomcat restart.