jdbc transactions


Does any one let me know the usage of jdbc driver transaction i.e the purpose of local transacation,xa transaction,no transaction?

NO_TRANSACTION - automatically commits (Auto Commit) all operations.

LOCAL_TRANSACTION - With this transaction type, all of the operations on the same connection in one transaction boundary will be committed or rolled back together. A transaction boundary means the scope of the transaction, from the beginning to the end of a transaction. It can be in one adapter service, one flow service, one Java service, or several steps in a flow service

XA_TRANSACTION This transaction type allows the connection to support two‐phase transactions executed across multiple databases.

For more info Refer “webMethods_JDBC_Adapter_User’s_Guide.pdf”

I will always suggest you to post your queries, if you are unable to find anything in wmusers. As this is a common question, hope you can find more useful answers from different users.

So local transactions always work only on one database and XA transactions require at least 2 databases??