We are attempting to do some simple transactions on Oracle but can’t seem to get our commit statements to work in WM. We have a simple flow that looks like this:
startTransaction (transactionName = 123)
commitTransaction(transactionName = 123)
If I run the “incrementDBField” adapter service by itself, it properly increments the database field. If I attempt to run the flow service above, I receive the following error by attempting to step through the commit statement:
error : [ART.114.303] Adapter Runtime (Transaction): Unable to commit transaction. null
errorType : com.wm.pkg.art.error.DetailedServiceException
errorDump : com.wm.pkg.art.error.DetailedServiceException: [ART.114.303] Adapter Runtime (Transaction): Unable to commit transaction.
We have tried using “NO TRANSACTION”, “LOCAL_TRANSACTION”, and “XA_TRANSACTION” on our connection. All versions still give us the “null error” above. We have also tried using different oracle drivers (e.g. the thin and the OCI.) to no avail.
Is there some property we’re missing that is preventing us from using the commitTransaction?