Friday, July 10, 2015

WLS: non-XA JDBC Datasource

Recently I faced below error, when tried to test SOA composite, due to incorrect configuration of the data source.

Error:
Unable to roll back JCA LocalTransaction due to:
Internal Exception: java.sql.SQLException: Cannot call Connection.rollback in distributed transaction.  Transaction Manager will commit the resource manager when the distributed transaction is committed.

Fix: 
Unchecked 'Supports Global Transactions' option in the data source configuration. This is applicable in case  Non-XA driver used to configure data source.


No comments:

Post a Comment

Provide your thoughts !