Can U Explain JDBC Adapter Transaction types?

We have 3 types of JDBC Adapter Transactions.

1) NO_TRANSACTION: The connection automatically commits the operations.

2) LOCAL_TRANSACTION: The connection uses local transactions.

If we plan to use the connection with BatchInsertSQL or BatchUpdateSQl adapter services, we must specify LOCAL_TRANSACTIONS types.

If we are configuring a Basic Notification and using the exactly once notification and delete stored records options we must configure the notification to use LOCAL_TRANSACTION type.

3) XA_TRANSACTION: The connection uses XA transactions. When we are connecting to Teradata we use XA transaction.