pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: connection delay
2+ messages / 2 participants
[nested] [flat]

* Re: connection delay
@ 2004-07-22 08:07  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  parent: cristi <cristi@dmhi.ct.ro>
  0 siblings, 0 replies; 2+ messages in thread

From: Achilleus Mantzios @ 2004-07-22 08:07 UTC (permalink / raw)
  To: cristi <cristi@dmhi.ct.ro>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* connection delay
@ 2004-07-22 08:12  cristi <cristi@dmhi.ct.ro>
  0 siblings, 1 reply; 2+ messages in thread

From: cristi @ 2004-07-22 08:12 UTC (permalink / raw)
  To: pgsql-sql

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?




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-07-22 08:12 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-22 08:12 connection delay cristi <cristi@dmhi.ct.ro>
2004-07-22 08:07 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>

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