Implementation of transaction in Try-catch and SQL in Webmethods-developer/designer

The Trycatch has a structure of three sequence:

-main (Exit On:success)

+try (Exit On:failure)

+catch (Exit On:done)

* The above approach is the previous implementation of WebMethods for database operations, and now with the JDBC adapter, database operations have become simple and flexible, thus replacing this practice. This method is still applicable if there are other special purposes.

There are three transaction options available in the process of JDBC Adapter setup:

No_transaction: No transaction used

Local_transaction: Use a local transaction to commit and rollback all operations on the same connection from the beginning of the transaction to the end of the transaction.

xa_transaction: A connection that can be applied to multiple databases, and all operations in one transaction are simultaneously commit and rollback.

If you need to insert notifications, update notifications, delete notifications, control notifications, and more, only use local_transaction mode is supported.