4 / 166
Types of JDBC transactions and their working methods.
Local Transaction,
No Transaction,
XA Transaction.
Asked In ::
Local Transaction,
No Transaction,
XA Transaction.
can it is possible to explan with live example.
Local Transaction: At any cause or exception we want to roll
back the data from table means Local Transaction can be used.
Local Transaction: At any cause or exception we want to roll
back the data from table means Local Transaction can be used.
Local Transaction = means IS manages the transaction; can only involve one Local transaction connection and 0 or more "No transaction" connections
No Transaction = means the DB manages the transaction (not IS); this is "auto-commit"
XA Transaction = means IS manages the transaction and can handle distributed transactions (operation over more than 1 database)