Re: Postmaster not dropping connections on tomcat restart.

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  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