Thread: Connection Problems
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.
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