• Stephen W. Thomas
  • Azure Integration Gurus
BizTalkGurus
  • Home
  • Blogs
    • Stephen’s BizTalk and Integration Blog
    • BizTalk Community Blogs via Syndication
  • Forums
  • Downloads
  • Videos
  • Training
    • Online Training
    • Classroom Training
Select Page

Re: Multiple connection with sql adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Multiple connection with sql adapter › Re: Multiple connection with sql adapter

December 31, 2008 at 6:00 AM #21456
community-content

    If its a requirement to process the messages in order, then implement singleton pattern.  Only one instance of orchestration will process the messages.

    But if its not, I guess you need analyze the causes for database locks and try to avoid them. 

    -try using stored procedures

    -minimize the scope of database transaction


    Search this Site:


    Recent Posts

    • Logic App Consumption deployment: The secret of KeyVault parameter cannot be retrieved. Http status code: ‘Forbidden’. Error message: ‘Access denied to first party service
    • BizTalk Server Visual Studio project: attempted re-targeting of the project has been canceled.
    • BizTalk Oracle Adapter error: The assembly required for type mapping not found.
    • PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption
    • Friday (funny) Fact: There is no size limit for the Logic App parameter name

    Tweets by AzureIntGurus

    Recent Topics

    • Evaluating on the amount of items returned in a message
    • Send and Receive ports problem
    • How to config/costom a WS Security to SOAP header
    • Email attachments – POP3 adapter
    • Calling ASP page from Biztalk Orchestration

    • Home
    • Blogs
    • Forums
    • Downloads
    • Videos
    • Training
    • Facebook
    • X
    • RSS
    @BizTalkgurus.com