Re: Lost connection after postgres restarted

From: Vámos Balázs <bsomav(at)freemail(dot)hu>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Lost connection after postgres restarted
Date: 2004-01-22 08:52:36
Message-ID: MKELKNBDGMCKNGAKDLLCMEONDHAA.bsomav@freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Nicolas Modrzyk 2004-01-22 09:08:02 Re: Lost connection after postgres restarted
Previous Message Kris Jurka 2004-01-22 06:27:26 Re: Can I store Ms-Word document in a table.