I am using an Integration Server 7.1.1 JDBC adapter in an XA transaction to perform an update to an Oracle database, but an error is occurring upon commit, indicating that a different JDBC adapter is failing, and then the rollback fails anyway, so the commit worked after all.
My flow looks basically like this:
SEQUENCE (exit on success)
SEQUENCE (try - exit on failure)
pub.art.transaction:commitTransaction (input transactionName mapped from startTransaction)
SEQUENCE (catch - exit on success)
Do you have any adapter service with local transaction in the same flow service ??
A single transaction context can contain any number of XA_TRANSACTION connections but no more than one LOCAL_TRANSACTION connection. If the flow contains adapter services that use more then one LOCAL_TRANSACTION connection, the you must use explicit transactions.
Also note that we do get this error if try to execute the flow service which has implicit transactions in debug more.