I am using Websphere3.5 Advanced Edition connecting to DB2 7.2. Here I am using two databases.
In one transaction, If I do even a simple Select from both the databses consecutively,
at the end of the method call when the EJB Container calls postInvoke, we get
When the hit is from a single Bean to both the databses by looking up two different datasources,
"TransactionRolledBack" exception is thrown.
We think it is an 2PC (2 Phase Commit) issue, and might not be doing the required setting or adjustments.
Can Anyone Suggest a solution in this regard or give the required setting for enabling 2PC (2 Phase Commit).
Thanks in Advance,