How does the Adapter Handle Transactions? - BizTalk

How does the Adapter Handle Transactions?

This topic has not yet been rated - Rate this topic

Microsoft BizTalk Adapter for Oracle Database does not initiate a transaction while performing an operation on the Oracle database. Instead, the adapter performs the operations using the transaction context provided by the adapter clients. In order to perform operations in a transaction using the Oracle Database adapter, you must:

• Enable transactions in the adapter clients. For example, to enable transactions in BizTalk Server 2009, you must select the Use Transaction check box in the Transactions area of the Messages tab for a WCF-Custom or WCF-OracleDB port.
  
• Set the value of the UseAmbientTransaction binding property to True in the adapter. For more information about the binding property, seeWorking with BizTalk Adapter for Oracle Database Binding Properties.
  

Important
To use the adapter to perform transactions on the Oracle database, you must have installed the Oracle Services For Microsoft Transaction Servercomponent, while installing the Oracle client, on the computer running the adapter client.

Transactions in the Outbound Operations

---

The Oracle Database adapter performs an outbound operation in a single transaction. For composite operations, all the operations are performed in a single transaction but using different ODP.NET connections. For more information about the outbound operations surfaced by the Oracle Database adapter, see How Does the Adapter Surface Oracle Metadata?.

Transactions in the Inbound Operations

---

The Oracle Database adapter exposes the following two inbound operations:

• Polling: The polling statement and the post-poll statement (if specified) are executed in a transaction, whereas, the polled data available statement is executed in a different transaction. Similarly, the polling statement and the post-poll statement are executed using the same ODP.NET connection, whereas, the polled data available statement is executed using a different ODP.NET connection.
  
• Notification: The notification operation is performed in a transaction using a single ODP.NET connection.
  

For more information about the inbound operations surfaced by the Oracle Database adapter, see How Does the Adapter Surface Oracle Metadata?.