Oracle Fusion Middleware

Problem

(BINDING.JCA-12563)


Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception. insert failed. Descriptor name: []. Caused by java.sql.SQLException: Cannot call commit/rollback when using distributed transactions. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.

Happens when calling a commit command in a Stored Procedure call explicitly or implicitly in a XA datasource.

Specifying PRAGMA AUTONOMOUS_TRANSACTION doesn not work.


Solution

• Create data-store as a non-XA datasource by using this driver (Oracle Drive (Thin) for Instance creation).
• Uncheck Supports Global Transsaction option.

Do not modify the existing non-XAdatasource.Create a fresh one.