From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Lemasson Sylvain <s(dot)lemasson(at)mak-system(dot)net> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Connection time out |
Date: | 2003-10-28 15:42:11 |
Message-ID: | 1067355731.1620.175.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Lemasson,
I would check to make sure that you don't have a firewall between you
and the database. As far as I know the default is infinite.
Check the archives for "dropping connections"
Dave
On Tue, 2003-10-28 at 09:21, Lemasson Sylvain wrote:
> Thank you for your reply thomas, but the setLoginTimout concernes the time a
> driver wait while attempting to connect to a database. My question was about
> the live time of a connection. I mean when we get a connection, postgres
> reset the connection after a time out ("connection reset by peer" error
> message). I want to set this time out to infinit but I do not know how.
>
> Lemasson Sylvain
> Ingénieur développeur
> s(dot)lemasson(at)mak-system(dot)net
> tel: 01.48.63.27.27
> MAK-SYSTEM SERVICES
> Groupe MAK-SYSTEM
> Paris Nord 2 - 13, rue de la Perdrix
> BP 50035-95946 Roissy CDG Cédex
> FRANCE
> ----- Original Message -----
> From: "Paul Thomas" <paul(at)tmsl(dot)demon(dot)co(dot)uk>
> To: "Lemasson Sylvain" <s(dot)lemasson(at)mak-system(dot)net>
> Cc: "pgsql-jdbc @ postgresql . org" <pgsql-jdbc(at)postgresql(dot)org>
> Sent: Tuesday, October 28, 2003 12:23 PM
> Subject: Re: [JDBC] Connection time out
>
>
> >
> > On 28/10/2003 08:33 Lemasson Sylvain wrote:
> > > Hi,
> > > where can we set the time-out of a connection ?.
> >
> > DriverManager.setLoginTimeout(int seconds);
> >
> > --
> > 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 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Dave Cramer <Dave(at)micro-automation(dot)net>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-10-28 15:55:53 | Re: Connection time out |
Previous Message | Lemasson Sylvain | 2003-10-28 14:21:33 | Re: Connection time out |