Qus:    Can U Explain JDBC Adapter Transaction types..?
Feb 09, 2021 10:57 1 Answers Views: 217 SWEETY
Prev Next
Answers (1)
SHIVA Feb 10, 2021 07:59
Answer:   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 BasicNotification and using theexactly 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.

Post Your Answer
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect