Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Built-In Transaction Management Services | Transaction Management Overview | Transactions
 
Transactions
Integration Server considers a transaction to be one or more interactions with one or more resources that are treated as a single logical unit of work. The interactions within a transaction are either all committed or all rolled back. For example, if a transaction includes multiple database inserts, and one or more inserts fail, all inserts are rolled back.
Transaction Types
Integration Server supports the following kinds of transactions:
*A local transaction (LOCAL_TRANSACTION) which is a transaction to a resource's local transaction mechanism
*An XAResource transaction (XA_TRANSACTION) which is a transaction to a resource's XAResource transaction mechanism
Integration Server can automatically manage both kinds of transactions, without requiring the adapter user to do anything. Integration Server uses a container-managed (implicit) transaction management approach based on the Connector Architecture standard, and also performs some additional connection management. This is because adapter services use connections to create transactions. For more information about implicit transactions, see Implicit and Explicit Transactions.
However, there are cases where adapter users need to explicitly control the transactional units of work. Examples of these cases are provided in Implicit and Explicit Transaction Examples.
To support transactions, Integration Server relies on an Oracle transaction manager. The transaction manager is responsible for beginning and ending transactions, maintaining a transaction context, enlisting newly connected resources into existing transactions, and ensuring that local and XAResource transactions are not combined in illegal ways.
The transaction manager only manages operations performed by adapter services, a transacted JMS trigger, or a built-in JMS service that uses a transacted JMS connection alias.
Important:
You cannot step or trace a flow that contains a transacted adapter service or a transacted JMS service.
XA Transactions
If an XA transactional connection throws an exception during a service transaction and the exception results in an inconsistent state, you may need to resolve the transaction using the tools provided with the database.
For information about using Integration Server to manage XA transactions, see the webMethods Integration Server Administrator’s Guide for your release.