Skip to content

Latest commit

 

History

History
47 lines (30 loc) · 3.11 KB

configure-transaction-isolation-level-and-transaction-timeout-with-oracle-db.md

File metadata and controls

47 lines (30 loc) · 3.11 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 Oracle Database
Configure transaction isolation level and transaction timeout with Oracle Database
06/08/2017
biztalk-server
article

Configure transaction isolation level and transaction timeout with Oracle Database

While performing inbound operation (Polling) using the [!INCLUDEadapteroracle] 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 BizTalk application that you have deployed after generating the metadata using the [!INCLUDEadapteroracle_short].

  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 oracleDBAdapterInboundTransactionBehavior, and click OK.

  12. In the left pane of the WCF-Custom Transport Properties, select the oracleDBAdapterInboundTransactionBehavior service under ServiceBehavior.

  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. For information about these transaction isolation levels, see the Members section at https://go.microsoft.com/fwlink/?LinkId=126983.

    [!IMPORTANT] The [!INCLUDEadapteroracle_short] supports only the following two transaction isolation levels: ReadCommitted and Serializable.

    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.