Software caused connection abort: recv failed
Hello all,
I have a Web Service that uses a datasource from the OC4J. I had a very strange error this morning. The first error that I received was like this:
java.sql.SQLException: Io exception: Software caused connection abort: recv failed
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)
at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:497)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1109)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1560)
at com.evermind.sql.FilterStatement.executeUpdate(FilterStatement.java:61)
at com.evermind.sql.FilterStatement.executeUpdate(FilterStatement.java:61)
at com.evermind.sql.StatementBCELProxy.executeUpdate(StatementBCELProxy.java:53)
After this error occurs, every request that tries to pull a connection from the pool receives the following error when it tries to use the connection:
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:239)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:728)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:702)
at com.evermind.sql.FilterConnection.createStatement(FilterConnection.java:279)
at com.evermind.sql.FilterConnection.createStatement(FilterConnection.java:279)
at com.evermind.sql.ConnectionBCELProxy.createStatement(ConnectionBCELProxy.java:40)
I restarted the Home component from EM to refresh the Datasources, and that seems to have resolved the issue, but I want to ensure that It doesn't occur again. Does anyone have any ideas what could have caused this issue?
Thanks,
KS