Skip to content

Latest commit

 

History

History
47 lines (30 loc) · 3.18 KB

configure-transaction-isolation-level-and-transaction-timeout-with-sql.md

File metadata and controls

47 lines (30 loc) · 3.18 KB
Raw
description title ms.custom ms.date ms.service ms.reviewer ms.suite ms.topic
Learn more about: Configure Transaction Isolation Level and Transaction Timeout with SQL
Configure Transaction Isolation Level and Transaction Timeout with SQL
06/08/2017
biztalk-server
article

Configure Transaction Isolation Level and Transaction Timeout with SQL

While performing inbound operations (Polling and Notification) using the [!INCLUDEadaptersql] with [!INCLUDEbtsBizTalkServerNoVersion], you should appropriately configure the transaction isolation level and the transaction timeout values. To do this:

  1. Start the [!INCLUDEbtsBizTalkServerNoVersion] Administration console.

  2. In the console tree, expand the BizTalk Group, and then expand Applications.

  3. Expand the application under which you want to deploy the [!INCLUDEadaptersqlshort].

  4. Right-click Receive Ports, point to New, and then click One-way Receive Port.

  5. In the Receive Port Properties dialog box, on the General tab, type a name for the receive port.

  6. In the left pane of the Receive Port Properties dialog box, click Receive Locations, and then click New in the right pane to define a new receive location.

  7. In the Receive Location Properties dialog box, click WCF-Custom in the Type list.

  8. Click Configure adjacent to the Type list.

  9. In the WCF-Custom Transport Properties dialog box, click the Behavior tab.

  10. In the Behavior list, right-click ServiceBehavior, and click Add extension.

  11. In the Select Behavior Extension dialog box, select sqlAdapterInboundTransactionBehavior, and click OK.

  12. In the left pane of the WCF-Custom Transport Properties, select the sqlAdapterInboundTransactionBehavior service under ServiceBehavior. For receive (Inbound operation message), one can use the sqlAdapterInboundTransactionBehavior to control the isolation level and the default value is ReadCommitted.

  13. In the right pane of the WCF-Custom Transport Properties, specify appropriate values for the transactionIsolationLevel and transactionTimeout parameters. You can select any of the following transaction isolation levels: Serializable, RepeatableRead, ReadCommitted, ReadUncommitted, Snapshot, Chaos, and Unspecified.

    [!NOTE] The default value of Transaction Isolation Level is Serializable for the WCF-SQL adapter for both inbound and outbound operations. For information about these transaction isolation levels, see the Members section at Isolation Level Enumeration (https://go.microsoft.com/fwlink/?LinkId=126983).

    Setting Transaction Isolation Level

  14. Click OK in the WCF-Custom Transport Properties dialog box.

  15. Click OK in the open dialog boxes to save the changes.