From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
Cc: | dinakar <din_akar(at)yahoo(dot)com>, "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 20:36:50 |
Message-ID: | 1079987809.1318.208.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Please look a the docs at
http://doc.postgresintl.com/jdbc/ch11s04.html
I set his up and tested it, it works!
Dave
On Mon, 2004-03-22 at 13:09, Paul Thomas wrote:
> On 22/03/2004 16:15 dinakar wrote:
> >
> > 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.
>
> That's not what I meant. Refer to the Tomcat docs and you'll see that you
> can declare resources in various places. I declare my connection pool
> stuff with my apps <Context></Context> block. I do this primarily because
> I can then put all of this in a seperate XML file named myapp.xml and just
> drop this file into Tomcat 4.1's webapps directory (again, refer to
> Tomcat's docs for this). As I'm sure you know, Tomcat gives each web app
> its own class loader so that when I stop my app, the connection pool also
> gets closed down and PostgreSQL cleans up its connections. But if you
> declare your connection pool outside of any context, I doubt that it would
> be closed down except when you stop Tomcat itself.
>
> > pls provide us a solution.
>
> I don't have a solution. I _never_ get the problem. All I can suggest is
> that you try it my way and see if helps. Other than that, you need to get
> support from the Tomcat lists.
--
Dave Cramer
519 939 0336
ICQ # 14675561
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-03-22 20:52:33 | Re: call syntax for record returning stored function |
Previous Message | Harry Mantheakis | 2004-03-22 19:11:21 | Re: Postmaster not dropping connections on tomcat restart. |