Re: Connection Problems

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: mmckenzie(at)unmc(dot)edu
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Connection Problems
Date: 2004-12-29 23:34:43
Message-ID: 41D33F13.8000801@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

9 times out of 10 this is caused by a firewall.

Dave

mmckenzie(at)unmc(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mohammad Altaf 2004-12-30 11:06:47 Out parameter support in PostgreSQL
Previous Message mmckenzie 2004-12-29 20:48:25 Connection Problems