Resolving java.sql.SQLRecoverableException with the Oracle 11 driver

LiveCycle ES2 and ES3 both support Oracle 11g.  There have been reports of LiveCycle customers experiencing the following database connectivity failure intermittently even when the database is running and the data source has been configured properly for LiveCycle connectivity:

 WARN  [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Destroying connection that is not valid, due to the following exception: oracle.jdbc.driver.T4CConnection@2b739450
java.sql.SQLRecoverableException: Io exception: Software caused connection abort: recv failed
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:458)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:785)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)

In some cases this failure has been linked to Oracle Thin Client bug 9373409 (see https://forums.oracle.com/forums/thread.jspa?threadID=2425542 for more details).  The issue appears to be related to the driver failing on Windows Vista and 2008 systems.  The fix is to upgrade the Oracle driver to version 11.2.0.3.

Also, to reduce the impact of these type of connection interruptions on LiveCycle process execution, you can apply auto-reconnect configuration to the data source.  This will not resolve the connection problem but it usually allows transactions to eventually succeed when they would otherwise fail.  More information on how this can be configured in JBoss can be found here:  http://blogs.adobe.com/livecycle/2011/03/setting-up-jboss-to-auto-reconnect-after-database-outage.html

VN:F [1.9.22_1171]
Was this helpful? Please rate the content.
Rating: 6.8/10 (4 votes cast)
Resolving java.sql.SQLRecoverableException with the Oracle 11 driver, 6.8 out of 10 based on 4 ratings

About Justin Poole

Justin is team lead for the North American LiveCycle Strategic Account Services team (aka Technical Account Managers) at Adobe. He has worked in Enterprise Support for over 12 years handling all varieties of support issues. Currently he works closely with many of Adobe's most strategic LiveCycle customers, helping with POC's, development/implementation and maintenance of LiveCycle solutions.
This entry was posted in Adobe LiveCycle ES2 (9.0.x), Adobe LiveCycle ES3. Bookmark the permalink.

One Response to Resolving java.sql.SQLRecoverableException with the Oracle 11 driver

  1. Andy says:

    Excellent, thanks for the share Adobe.