Can U Explain JDBC Adapter Transaction types..?

Answer Posted / moolawebmethods

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 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.

Is This Answer Correct ?    28 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to configure sap adapter6.1

2199


how to configure sap adapter 4.1

5556


Where do you implemented pub-sub architecture?

836


Explain about pub-sub architecture, where do you implemented this?

786


post me important interview question on webmethods

2505


How to convert document list to document? If document list contain documents and documents contain strings field. How to convert?

822


Explain what are the new features in 8.0 compared to 7.1?

760


If I have a parent sequence with the property set- exit on success, and the try sequence block set to exit on failure, and the catch sequence block too set to failure, what is the result?

856


Explain about pub-sub architecture?

828


When we use repeate, exit flow steps?

806


Explain what is indices in map flow step?

807


can we build loop step with in the branch in such a way that the interface is look like that branch sequence: Deposit loop xxxxxx sequence: current loop xxxxxxx sequence: savings loop can we achieve the above senario.

2190


can any one please post Q and Ans for Trading Networks in webMethods

2232


How we can catch exception error on run time mode using flow language in webmethods?

907


Explain header handlers in web services

2347