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

Re: Lost connection after postgres restarted

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: Vámos Balázs <bsomav(at)freemail(dot)hu>
Cc: "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Lost connection after postgres restarted
Date: 2004-01-20 19:00:18
Message-ID: 20040120190018.D13643@bacon (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
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         |   |

In response to


pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-01-21 02:11:08
Subject: Re: updatable resultsets -> SQLException: -1
Previous:From: Vámos BalázsDate: 2004-01-20 17:22:26
Subject: Lost connection after postgres restarted

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