rss
SOATUBE
Oracle
Custom Search SOABYTE here

Friday, August 27, 2010

Cannot call commit/rollback when using distributed transactions


















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.

3 comments:

Post a Comment

 
Blogger Profile