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 interfaces you implemented sofar?

693


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.

1988


post me important interview question on webmethods

2301


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

579


Explain what is indices in map flow step?

616






Explain about pub-sub architecture?

627


how to configure sap adapter 4.1

5280


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?

649


When Should You Use Flow Diagram View?

2082


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

1988


When we use repeate, exit flow steps?

594


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)

1417


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

581


how to configure sap adapter6.1

1963


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

636