Thread: Connection Problems

Connection Problems

From
mmckenzie@unmc.edu
Date:

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
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.

Re: Connection Problems

From
Dave Cramer
Date:
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