Io exception: Connection reset VendorError: 17002
abrueglFeb 27 2006 — edited Mar 24 2008When I switched from our development DB to our production DB, I now sometimes get this error when inserting a BLOB (average about 40k) using the Oracle Database 10g Release 2 (10.2.0.1.0) JDBC Drivers.
Any help would be grealy appreciated!
Here lies the debug:
2006-02-27 01:32:23,996: - ERROR - (FaxTransaction.java:1209) [JavaMail-EventQueue] - SQLException: Io exception: Connection reset
2006-02-27 01:32:23,996: - ERROR - (FaxTransaction.java:1210) [JavaMail-EventQueue] - SQLState: null
2006-02-27 01:32:23,996: - ERROR - (FaxTransaction.java:1211) [JavaMail-EventQueue] - VendorError: 17002
2006-02-27 01:32:23,998: - ERROR - (FaxTransaction.java:1212) [JavaMail-EventQueue] - SQLException:
java.sql.SQLException: Io exception: Connection reset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:977)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at net.nighthawk.faxviewer.server.database.FaxTransaction.addFaxPage(FaxTransaction.java:1195)
at net.nighthawk.faxviewer.server.database.FaxTransaction.addNewFaxStapleGroup(FaxTransaction.java:83)
at net.nighthawk.faxviewer.server.mail.NewMessageHandler.handle(NewMessageHandler.java:110)
at net.nighthawk.faxviewer.server.FaxViewerServer$NewFaxEmailHandler.messagesAdded(FaxViewerServer.java:360)
at javax.mail.event.MessageCountEvent.dispatch(MessageCountEvent.java:137)
at javax.mail.EventQueue.run(EventQueue.java:121)
at java.lang.Thread.run(Thread.java:595)
2006-02-27 01:32:24,000: - ERROR - (FaxTransaction.java:1247) [JavaMail-EventQueue] - SQLException: Closed Connection
2006-02-27 01:32:24,000: - ERROR - (FaxTransaction.java:1248) [JavaMail-EventQueue] - SQLState: null
2006-02-27 01:32:24,000: - ERROR - (FaxTransaction.java:1249) [JavaMail-EventQueue] - VendorError: 17008
2006-02-27 01:32:24,001: - ERROR - (NewMessageHandler.java:118) [JavaMail-EventQueue] - SQL Error trying to get the next sequence number for the FAX PAGE STAPLE.
java.lang.Exception: SQL Error trying to get the next sequence number for the FAX PAGE STAPLE.
at net.nighthawk.faxviewer.server.database.FaxTransaction.addFaxStaplePage(FaxTransaction.java:1251)
at net.nighthawk.faxviewer.server.database.FaxTransaction.addNewFaxStapleGroup(FaxTransaction.java:94)
at net.nighthawk.faxviewer.server.mail.NewMessageHandler.handle(NewMessageHandler.java:110)
at net.nighthawk.faxviewer.server.FaxViewerServer$NewFaxEmailHandler.messagesAdded(FaxViewerServer.java:360)
at javax.mail.event.MessageCountEvent.dispatch(MessageCountEvent.java:137)
at javax.mail.EventQueue.run(EventQueue.java:121)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:840)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:759)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.prepareStatement(PoolingDriver.java:338)
at net.nighthawk.faxviewer.server.database.FaxTransaction.addFaxStaplePage(FaxTransaction.java:1237)
... 6 more