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 convert document list to document? If document list contain documents and documents contain strings field. How to convert?

620


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

650


Where do you implemented pub-sub architecture?

616


When we use repeate, exit flow steps?

587


how to configure sap adapter6.1

1954






how to configure sap adapter 4.1

5261


Explain about pub-sub architecture?

618


in filepooling process the document is not updated in target location means its in error directory how to achieve this problem?

2243


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

568


How many minutes have you spent in your lifetime reading documentation or actually (gasp) working with any webMethods product on a real project?

1978


post me important interview question on webmethods

2280


How many kinds of log files in webmethods?

588


Explain header handlers in web services

2107


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.

1973


What are the advantages of eai?

645