- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.8K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.6K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
DB Transaction Commit not working on JCS-SX env
We are facing issues while using ADF application deployed on JCS-SX environment.
The Application has Application Module exposed as service interface, The AM has a method which saves some data into DB tables using getDBTransaction().commit();
The DB used by the AM to save the data is the default schema provided with the JCS-SX environment.
The issue is the records are not getting saved to the DB, and the error returned by the service is as below when called from the Soap client or Browser
“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”
Since we are using the JCS-SX provided schema as service, there is no control to make the settings on the JDBC driver as per the error.
PS : The version of JCS-SX that we are using is Version #17.2.6 and the same code worked in earlier version of JCS-SX which is decommissioned
The code snippet for commtting transaction is below
// Table already have the report name
_logger.severe("Inside if HasNext");
Row row_reportParameters = reportParameters.next();
// Create a row in table with the report parameters
_logger.severe("Inside else newdata");
Row row_reportParameters = reportParameters.createRow();
Can you please suggest if there is any ways to resolve this issue.