DB Transaction Commit Errors From ADF Webservices (Doc ID 2300619.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

DB Transaction Commit Errors out from ADF Webservices


We have following scenario in Oracle ADF Application which is deployed on JCS-SaaS extension environment.

1) We have created an application module in ADF application which has a function, which calls ERP cloud webservice PublicReport Webservice to run a BIP report on the cloud. Once the report is run and response is sent back, we create some data in custom table for book keeping purpose for example to update report run time etc.
We call the commit operation explicitly as this.getDBTransaction().commit() to commit the transaction.
2) We have exposed this function as a BC4J ADF webservice and deployed this application on Java Cloud Service SaaS extension.
3) We are testing this webservice using SOAP UI. Once we run the webservice method, we are getting following error on SOAP UI
"JDBC driver does not support XA, hence cannot be a participant in two-phase commit. To force this participation, set the GlobalTransactionsProtocol attribute to LoggingLastResource (recommended) or EmulateTwoPhaseCommit for the Data Source = apex"
4) When we check in the JCS-SX logging user interface, we see our webservice is called properly and logs originate from the same, but the database transaction is not committed.

We have no access to administration console to change any transaction/JNDI settings as well.

I am attaching SOAP UI screenshot and logs collected during the process of webservice run.

This application works well in other WebLogic on-premise servers, but throws error in JCS-SX environment.

ERROR
-----------------------
"JDBC driver does not support XA, hence cannot be a participant in two-phase commit. To force this participation, set the GlobalTransactionsProtocol attribute to LoggingLastResource (recommended) or EmulateTwoPhaseCommit for the Data Source = apex"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.