IBM Support

webMethods Knowlegebase : The user would like to understand implications of explicit transactions with LOCAL or NO transaction. (1756796)

Troubleshooting


Problem

Understanding implications of explicit transaction with LOCAL or NO transaction:

In a cluster (Tangosol) node 1 has LOCAL_TRANSACTION while the other has NO_TRANSACTION. The flow code that is running in this cluster is doing explicit transactions. The JDBC insert is inside a loop and the commit is outside the loop. Rollback is in the catch block.

What's the recommendation of changing the settings, either LOCAL or NO_TRANSACTION?

Is there any log that occurs on the server when the setting is changed that could be reviewed to see if someone changed this setting?

If recommendation is NO_TRANSACTION, should the explicit code be removed? If it's not removed will the ROLLBACKS still work?

Document Location

Worldwide

[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSVYEV","label":"IBM webMethods Integration"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Adapter Runtime (WAR)"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"}],"Version":"8.2.2"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFIWYE","label":"IBM webMethods B2B"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Adapter Runtime (WAR)"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"}],"Version":"8.2.2"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
19 March 2025

UID

ibm17191001

Page Feedback