Re: Lost connection after postgres restarted

On 20/01/2004 17:22 Vámos Balázs wrote:
> Hi,
> 
> I have the following problem with my PostgreSQL+Tomcat+JDBC:
> 
> I have got a PostgreSQL server, a Tomcat, and some jsp file what connects
> to
> the postgresql via JDBC.
> 
> I stop postmaster (because of file system level backup)
> After the backup I start postmaster
> But the connection between JDBC and postgresql doesn't recover any more.
> 
> I need to restart Tomcat to build up the connection again. Why?

IMHO, this is more a limitation of the connection pooling which doesn't 
seem to be able to recognise that a connection has gone bad and that it 
should discard it and create a new one. BTW, its not necessary to stop 
Tomcat as you can use its manager application to simply stop and restart 
your application.

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