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 many kinds of log files in webmethods?

687


Where do you implemented pub-sub architecture?

727


how to configure sap adapter 4.1

5413


How many interfaces you implemented sofar?

772


Explain what is indices in map flow step?

690






What are the advantages of eai?

745


post me important interview question on webmethods

2390


can anyone explain in brief about TN Consloe and Webmethods...? As well as All flow steps in webmethods: Branch Repeat Loop Sequence (explain also Try -Catch block for error Handling)

1526


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

2353


When we use repeate flow steps?

694


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

667


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

665


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

716


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

2093


Explain header handlers in web services

2228