From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: cristi <cristi@dmhi.ct.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: connection delay
Date: Thu, 22 Jul 2004 11:07:44 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0407221052340.12415-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <005501c46fc3$a518fa80$7202a8c0@aaa>
O kyrios cristi egrapse stis Jul 22, 2004 :
> I have a client made in java who interogate postgres using jdbc driver.
> If the tcp conection falls (for a few seconds) the client give an error
> message about that connection.
> How can I avoid this error?
If its not a jdbc issue, maybe you can play with
/* for a new connection */
System.setProperty("sun.net.client.defaultConnectTimeout", "10000");
/* for already established connection */
System.setProperty("sun.net.client.defaultReadTimeout", "10000");
the interval is given in milliseconds.
I have tested on FreeBSD 5.1-RELEASE-p10,
1.4.2-p5 JVM
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
-Achilleus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, cristi@dmhi.ct.ro
Subject: Re: connection delay
In-Reply-To: <Pine.LNX.4.44.0407221052340.12415-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox