Re: Connection Problems - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Connection Problems
Date
Msg-id 41D33F13.8000801@fastcrypt.com
Whole thread Raw
In response to Connection Problems  (mmckenzie@unmc.edu)
List pgsql-jdbc
9 times out of 10 this is caused by a firewall.

Dave

mmckenzie@unmc.edu wrote:

>
> Hello All,
>
> I'm using 74.214 of the JDBC driver on a cold fusion datasource and
> periodically I receive the following error:
>
> Error Executing Database Query. An I/O error occured while reading
> from backend - Exception: java.net.SocketException: Connection reset
> Stack Trace: 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.core.PGStream.ReceiveChar(PGStream.java:166) at
> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:127) at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
> at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:298)
> at
> coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
> at coldfusion.sql.Executive.execu...
> The error occurred on line 1.
>
>
> It appears that the connection is timing out.
>
> What causes this?
>
> Mitchell S. McKenzie
> Programmer_
> __Learning Environment & Internet Services_ <http://app1.unmc.edu/leis>
> University of Nebraska Medical Center
> Phone: 402-559-9306
> Cell Phone: 402-708-1493
> *
> University of Nebraska Medical Center E-mail Confidentiality Disclaimer :*
> The information in this e-mail is privileged and confidential,
> intended only for the use of the addressee(s) above.
> Any unauthorized use or disclosure of this information is prohibited.
> If you have received this e-mail by mistake please delete it and
> immediately contact the sender.


--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561


pgsql-jdbc by date:

Previous
From: mmckenzie@unmc.edu
Date:
Subject: Connection Problems
Next
From: "Mohammad Altaf"
Date:
Subject: Out parameter support in PostgreSQL