SOA 11g/12c: JDBC driver does not support XA, hence cannot be a participant in two-phase commit:

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 = EBSProdDataBase

Solution:

Step 1: Go to your WebLogic Admin Server console.

Step 2: Home -> Summary of JDBC Data Sources -> myDatasource ->Transactions.

Step 3: Uncheck: One-Phase Commit

Step 4: Check: Emulate Two-Phase Commit

Step 5: Save and Click Active Changes

Step 6: Restart the services.