Re: Lost connection after postgres restarted

Thomas,

And how can I solve this connection pooling problem?

Restarting the application is not good, because this process must be
automatic instead of manual.

somav

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Paul Thomas
> Sent: Tuesday, January 20, 2004 8:00 PM
> To: Vámos Balázs
> Cc: pgsql-jdbc @ postgresql . org
> Subject: Re: [JDBC] 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 |
> +------------------------------+----------------------------------
> -----------+
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>
>