Can U Explain JDBC Adapter Transaction types..?

Answers were Sorted based on User's Feedback

Can U Explain JDBC Adapter Transaction types..?..

Answer / moolawebmethods

We have 3 types of JDBC Adapter Transactions.

1)NO_TRANSACTION:The connection automatically commits the

2)LOCAL_TRANSACTION:The connection uses local transactions.

If we plan to use the connection with BatchInsertSQL or
BatchUpdateSQl adapter services,we must specify
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

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

Can U Explain JDBC Adapter Transaction types..?..

Answer / bhokalibaba

While reading this material please do not confuse a Transaction with an Operation. A transaction might consist of multiple operations like select, insert, delete,update etc. Also multiple operations can be of two types:

A series of operations i.e operations taking place one after the other and are inter-related.
A batch of operations which takes place concurrently all together.

Some transactions involve a series of related operations, not just one single operation always. In webmethods such multiple operations are performed even using a single adapter service or a flow service or a Java service or in multiple steps in a flow service.

There is a loophole in such kind of transaction if the different operations are performed in different DB servers not in same DB server:

The webmethods makes use of multiple connections in one service itself, in this case.

If either of the operation fails in the transaction, the other operations which have been already performed in other DB servers will not be notified for roll back. This would result in incomplete transaction.

To get rid of this problem we have something called 2-Phase commit. That is whenever such multiple operations occur in multiple, distributed DB servers, they(the operations) occur in 2 phases. And also the operations are monitored by a coordinator.

The coordinator asks the data-source of the operation if it is ready to commit the operation in so called Prepare Phase.
If the operation is ready to be committed, the operation gets committed in the data-source in so called Commit Phase.

If not, then the coordinator rolls back all the previous operations from the DB servers to avoid an incomplete transaction from happening.

This concept of multiple operations in multiple, distributed DB servers in one single transaction belongs to DB not to webmethods. It's just webmethods supports such kind of transaction using so called XA_Transaction type of connection.

XA transaction stands for distributed transaction. It is also called Global Transaction.

Local transactions differ from XA_Transaction in using one single connection rather than multiple, distributed Database servers to perform a series of operations. In local transactions, it is not a big deal to commit all operations or roll back the operations together in case of a failure in any operation, as all the operations take place in one single data-source in one single DB server. So coordinator is also not required in local transactions.

No Transaction: If a connections is of type ''no connection'' then even if an operation fails,it does not matter, the other operations in the transaction will be committed. This is because such transactions have auto-commit capability only, no rolling back.

Is This Answer Correct ?    12 Yes 0 No

Can U Explain JDBC Adapter Transaction types..?..

Answer / malli

1.No_Transaction : It is a auto commit transaction.
2.Local_Transaction : It is a local and one way transaction.
3.XA_Transaction : It is a two way transaction

Is This Answer Correct ?    10 Yes 0 No

Can U Explain JDBC Adapter Transaction types..?..

Answer / ajitabh kumar sharma

There are three transaction types related to JDBC Adapter:

1. NO_TRANSACTION: The transaction gets committed automatically.
2. LOCAL_TRANSACTION: It involves transaction using only one
database [Non distributed transaction]
3. XA_TRANSACTION: It is used to control distributed
transaction and supports 2PC protocol etc.

Is This Answer Correct ?    7 Yes 0 No

Can U Explain JDBC Adapter Transaction types..?..

Answer / guest

There are 3 tranaction types in JDBC adapter

Is This Answer Correct ?    6 Yes 1 No

Can U Explain JDBC Adapter Transaction types..?..

Answer / gowtham raj

1.Local transaction
2.XA transaction
3.NO transaction

Is This Answer Correct ?    4 Yes 1 No

Can U Explain JDBC Adapter Transaction types..?..

Answer / rahul sharma

1. NO_TRANSACTION:This is , the connection automatically commits for all the Operation.
2.LOCAL_TRANSACTION:The connection uses local transactions[Using Only one database].

3.XA_TRANSACTION: This transaction type allows the connection to support two-phase transactions executed across multiple

Is This Answer Correct ?    3 Yes 2 No

Can U Explain JDBC Adapter Transaction types..?..

Answer / nvijay

three types jdbc adapter transaction:
1)local-transaction:commit&rollback must be used in bach
insert&bach uppdate

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More WebMethods Interview Questions

i have partner A,and partner B, then i want to send a document to partner B, what are requirements i will provide to partners ?

1 Answers   IBM,

How you can implement finally block in flow services ?

8 Answers   Cap Gemini,

What Is a Flow Step?

2 Answers  

How many kinds of log files in WebMethods???? and where are they exist???

7 Answers   Satyam,

How to open a session on a different server?

1 Answers  

How to store logs in DB?

1 Answers   TCS,

Can U Explain JDBC Adapter Transaction types..?

8 Answers   Tech Mahindra, Cap Gemini, LG CNS, STC,

How to Move Flow Steps?

1 Answers   IBM,

Hi I am using Wenmethods 7.1 since many years. I am on Webmethods project. Today my Boss asked me about CLSRIM (Webmethods service, when one server is down, automatically another will take over. Can you please throw some light on above ? OR from where can I get some help ? IT IS URGENT...... Komalika

4 Answers  

How Java Services Are Organized on the webmethods Server?

2 Answers  

use of finally block in exception handling in webmethods

1 Answers   IBM,

what is the difference between Schema and SchemaDT

2 Answers