What Is the differences between LOCAL_TRANSACTION and XA_TRANSACTION. what kind of transactions we need to use if we want to use the transactions?
this depends on the connections involved in one transaction.
If there is only one connection involved you can use LOCAL_TRANSACTION.
But if the transaction multiple connections and/or multiple types of systems (JDBC, MQ, JMS, …) which need to be committed or rolled back together you have to use XA_TRANSACTION.