I/O error

Lists: pgsql-jdbc
From: Antonini Roberto <Roberto(dot)Antonini(at)TILAB(dot)COM>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: I/O error
Date: 2004-08-13 09:57:53
Message-ID: 95F2F6B57A08F94FBAEE314B62B4CB1A05770D@EXC01B.cselt.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc

Hi all,

Someone could explain to me the meaning of this exception:

An I/O error occured while reading from backend - Exception:
java.net.SocketException: Connection reset

java.net.SocketException: Connection reset

at java.net.SocketInputStream.read(SocketInputStream.java:168)

at
java.io.BufferedInputStream.fill(BufferedInputStream.java:183)

at
java.io.BufferedInputStream.read(BufferedInputStream.java:201)

at org.postgresql.PG_Stream.ReceiveChar(Unknown Source)

at org.postgresql.core.QueryExecutor.execute(Unknown Source)

at org.postgresql.Connection.ExecSQL(Unknown Source)

at org.postgresql.jdbc2.Statement.execute(Unknown Source)

at org.postgresql.jdbc2.Statement.executeQuery(Unknown Source)

when I try to invoke DB function to remote DB.

could it be a driver trouble?

Thanks,

Roberto.

Gruppo Telecom Italia - Direzione e coordinamento di Telecom Italia S.p.A.

====================================================================
CONFIDENTIALITY NOTICE
This message and its attachments are addressed solely to the persons
above and may contain confidential information. If you have received
the message in error, be informed that any use of the content hereof
is prohibited. Please return it immediately to the sender and delete
the message. Should you have any questions, please send an e_mail to
MailAdmin(at)tilab(dot)com(dot) Thank you
====================================================================


From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Antonini Roberto <Roberto(dot)Antonini(at)TILAB(dot)COM>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: I/O error
Date: 2004-08-13 11:37:57
Message-ID: 411CA815.3030300@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc

Antonini Roberto wrote:
> Hi all,
>
> Someone could explain to me the meaning of this exception:
>
>
>
> *An I/O error occured while reading from backend - Exception:
> java.net.SocketException: Connection reset*
>
> when I try to invoke DB function to remote DB.
>
> could it be a driver trouble?

The driver is reporting a TCP/IP-level communication error.

The usual cause is a stateful firewall betweeen the JDBC client and the
server. A connection that stays idle for a long time may be considered
dead and dropped by the firewall, and you will see a "connection reset"
error when it is eventually reused.

-O