Custom Search SOABYTE here

Friday, August 27, 2010

Cannot call commit/rollback when using distributed transactions



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.


  • 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.


rohit said...

It is amazing that you have finally reached this point. i think that you had to overcome many obstacles that require the good physical availability.

kajal agarwal hot

Post a Comment

Blogger Profile