Transanction Types Problem

In JDBC Adapter Connection We Use Different Types Of Transanctions What Exactly the Difference Between Those 3 T Types

1 Like

Please help us to understand the difference between transaction types with examples if possible.

NO_TRANSACTION
The connection provides no transaction control over the operations being performed. That is, the connection automatically commits all operations.
LOCAL_TRANSACTION
With this transaction type, all of the operations on the same connection in one transaction boundary will be committed or rolled back together. A transaction boundary means the scope of the transaction, from the beginning to the end of a transaction. It can be in one adapter service, one flow service, one Java service, or several steps in a flow service.
XA_TRANSACTION
This transaction type allows the connection to support two-phase transactions executed across multiple databases. In one transaction boundary, all of the operations on multiple connections will be committed or rolled back together. A transaction boundary means the scope of the transaction, from the beginning to the end of a transaction. It can be in one adapter service, one flow service, one Java service, or several steps in a flow service.

More information in the JDBC Adapter Users Guide