Обсуждение: 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   |
+------------------------------+---------------------------------------------+

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.lemasson@mak-system.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@tmsl.demon.co.uk>
To: "Lemasson Sylvain" <s.lemasson@mak-system.net>
Cc: "pgsql-jdbc @ postgresql . org" <pgsql-jdbc@postgresql.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   |
>
+------------------------------+--------------------------------------------
-+
>

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.lemasson@mak-system.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@tmsl.demon.co.uk>
> To: "Lemasson Sylvain" <s.lemasson@mak-system.net>
> Cc: "pgsql-jdbc @ postgresql . org" <pgsql-jdbc@postgresql.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@micro-automation.net>

"Lemasson Sylvain" <s.lemasson@mak-system.net> writes:
> 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 can assure you that the Postgres backend will never do any such thing.
Your problem must be somewhere in the communication pathway.

One likely possibility is that you have an address-translating firewall
(NAT box) between you and the database server.  NAT boxes will commonly
forget about connections that have been idle for too long.  It may not
be possible to persuade the firewall not to do this --- if you cannot
bypass the firewall, your best bet may be to issue an empty query every
so often to keep the connection alive.

            regards, tom lane