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

Re: Postmaster not dropping connections on tomcat restart.

From: dinakar <din_akar(at)yahoo(dot)com>
To: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>,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 16:15:02
Message-ID: 20040322161502.12292.qmail@web10707.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Even i have the same problem what Paul Davis said with
respect to connection, 

>>Is the connection pool defined within you web app's
>>context?
yes i have defined the pool in the server.xml file and
reference in the web.xml file. 

pls provide us a solution. 

thanks
dinakar


--- Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> wrote:
> 
> 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   |
>
+------------------------------+---------------------------------------------+
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
>       joining column's datatypes do not match


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

In response to

Responses

pgsql-jdbc by date

Next:From: markwDate: 2004-03-22 18:00:19
Subject: call syntax for record returning stored function
Previous:From: Paul ThomasDate: 2004-03-22 15:48:26
Subject: Re: Postmaster not dropping connections on tomcat restart.

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