How to serialize parts of an orchestration (procedure invoking)?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to serialize parts of an orchestration (procedure invoking)?

Viewing 1 reply thread
  • Author
    Posts
    • June 29, 2010 at 10:26 AM #25082
      community-content

        Hi,

        I’ve developed an orchestration which calls a MS SQL procedure by a send port.

        I believe that the orchestration will be called serveral times if there are any simultaneos inbound messages and then my procedure would be invoked by a number of the threads of the same kind of  orchestration.

        Based on last statement I want to serialize the invoking of procedure so how can I prevent the simultaneos call of my procedure by several orchestration-threads?

         

      • June 29, 2010 at 12:45 PM #25083
        community-content

          Hi,

           

             How is your orchestration (which calls a MS SQL procedure by Send port) being invoked? Are you using a Call or Start Orchestration shape to invoke it?

           

             Have you looked into implementing a Singleton Orchestration? Here’s an example that you can follow:

          http://aspalliance.com/1208_Singleton_Orchestration_in_BizTalk_Server.all

           

             Daniel.

           

          • June 30, 2010 at 2:08 AM #25086
            community-content

              Hi Daniel,

              thanks for quick reply.

              I do not use any Call or Start Orchestration shapes.
              I only have the one orchestration. Shall I use any
              of those shapes?
              I use of course a Soap Message to start the procedure by a send port
              using WCF-SQL Adpater.

              The proposed article seems to be interesting, I’ll let you know if it
              could solve that problem.

              Hiwa

              • June 30, 2010 at 4:15 AM #25088
                community-content

                  Ok, it seems that I have to use correlation types and correlation sets to associate orchestration instances to each other creating one message per message-shape in the same time interval.

                  Which BTS.* property should I use as correlation type for my send-shape (related to a Soap Message which call a procedure “myPrc”) to relate them to the one send-port specified by the WCF-SQL Adapter and the Soap Header “Procedure/dbo/myPrc”?

                  (My intention has been to prevent the simultaneous call of the procedure “myPrc”)

                  Hiwa

                   

                   

              • June 30, 2010 at 4:33 AM #25089
                community-content

                  Hi Daniel,

                  thanks for quick reply.

                  I do not use any Call or Start Orchestration shapes.
                  I only have the one orchestration. Shall I use any
                  of those shapes?
                  I use of course a Soap Message to start the procedure by a send port
                  using WCF-SQL Adpater.

                  The proposed article seems to be interesting, I’ll let you know if it
                  could solve that problem.

                  The proposed article seems to be interesting: it seems that I have to use correlation types and correlation sets to associate orchestration instances to each other creating one message per message-shape in the same time interval.

                  Which BTS.* property should I use as correlation type for my send-shape (related to a Soap Message which call a procedure “myPrc”) to relate them to the one send-port specified by the WCF-SQL Adapter and the Soap Header “Procedure/dbo/myPrc”?

                  (My intention has been to prevent the simultaneous call of the procedure “myPrc”)

                  • June 30, 2010 at 12:07 PM #25098
                    community-content

                      Hi,

                       

                         You can use the BTS.MessageType property to correlate on, and specify the Namespace#Root value combination associated with the request message for the WCF-SQL adapter port.

                       

                         Best.

                       

              • Author
                Posts
              Viewing 1 reply thread
              • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.