Monday, October 8, 2012

ADF: Resolving random JBO-27122 and closed statement errors


Problem: 
  • Resolving random JBO-27122 and closed statement errors 
  • <java.sql.SQLException: Statement cancelled, probably by transaction timing out.

Resolution:

Fusion web applications are not compatible with data sources defined with the JDBC XA driver. When creating a data source on Oracle WebLogic Server, be sure to change the Fusion web application data source's JDBC driver from “Oracle's Driver (Thin XA)” to “Oracle's Driver (Thin)”. Because XA data sources close all cursors upon commit, random JBO-27122 and closed statement errors may result when running the Fusion web application with an XA data source. 

Reference: http://docs.oracle.com/cd/E24382_01/web.1112/e16182/deployment_topics.htm#ADFFD23083

1 comment:

  1. Thanks a lot , the solution worked for us.

    ReplyDelete