This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Software caused connection abort: recv failed

 
Kevin G Scott
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
I have a Web Service that uses a datasource from my J2EE container. 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 container 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 in advance!
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34178
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kevin,
That is typically caused when a connection gets stale or closes after a timeout. The DataSource doesn't know it is stale until you use it. Usually, if you code to try again, it will work. Alternatively, you can keep pinging your application to prevent the connection from getting stale in the first place.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic