Savepoint Error and Support Global Transactions


By W.ZH Nov 2011

Issue:


When you try to use the AM(ADF – Application Module) to commit one new created object, you get this save error in jdbc:oracle.jbo.DMLException: JBO-26041: Failed to post data to database during
“Rollback to Savepoint”: SQL Statement “null”.


This error can happen also in the Exposed Web Service by AM, Such as to the SDO Web Service object create/save from WS API.

Solution:

You can read the
ADF guide and also the “JDBC Data Source Transaction Options” in  Oracle® Fusion Middleware Configuring and Managing JDBC Data Sources for Oracle WebLogic Server 11g Release 1 (10.3.4)


In the Tansaction of the JDBC Datasource configuration for WLS. You need to enable the “Support Global Transactions” and “Emulate Two-Phase Commit”, can solve this issue.

Advertisements