Search code examples
javatransactionsweblogicdatasourceosb

Cannot call commit when using distributed transactions

This error occured when trying to call stored procedure from Oracle SQL using DBAdapter with WebLogic.

Solution

  • Some forums offered to change the datasource from XA to NonXA, and deselect the checkbox "Supports Global Transactions". I do that and got other error "Cannot call Connection.commit in distributed transaction". I've restarted the WebLogic server and thats it. Problem Solved. FYI :)