JDBC driver does not support XA issue

Question

I am getting "JDBC driver does not support XA issue"

Error committing transaction:; nested exception is: javax.transaction.xa.XAException: JDBC driver does not support XA, hence cannot be a participant in two-phase commit.

Answer 1

In the Weblogic Console, go to Services > Datasources.

Click on your datasource. Then, click on the Transaction tab:

• Supports Global Transactions should be already selected.
• Select Emulate Two-Phase Commit.

Save this configuration and restart the server.

Answer 2

set the GlobalTransactionsProtocol attribute to LoggingLastResource (recommended) or EmulateTwoPhaseCommit for the Data Source. This should work.