Hi, I am using 2 datasources. one for SQL server(XA datasource)and another for DB2(not an XA).
In the particular transaction, our code gets nearly 3 connections using getConnection of XA datasource and 2 connections using DB2 datasource. Getting the following exception when the transaction is about to commit: "An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred." Is it required to close all connections before committing?
Could you pls help me out of this problem soon??? Thanks in advance.