locked
TypedPoling - Consuming Adapter Service RRS feed

  • Question

  • Hi there, 

    This is just a nosy question: 

    Why in TypedPoling I am getting three nodes in the schema generated ?

    May I use any node ? Or is one of the nodes the only valid node to use fro maping ?


    God bless you all :)

    Friday, October 9, 2015 2:01 PM

Answers

  • It's because that's the actual structure returned over TDS (the SQL protocol), and it also helps with Debatching as well.

    • TypedPolling represents the entire response from the database which can include multiple Result Sets (TypedPollingResultSet0)
    • TypedPollingResutlSet0 (the first one) is the actual result set or table.
    • TypedPollingResutlSet0 (the second one) is a Row.

    You can have a structure like:

    TypedPolling

      TypedPollingResutlSet0

        TypedPollingResutlSet0

      TypedPollingResutlSet1

        TypedPollingResutlSet1

      TypedPollingResutlSet2

        TypedPollingResutlSet2

    • Proposed as answer by Angie Xu Wednesday, October 14, 2015 2:07 AM
    • Marked as answer by Angie Xu Wednesday, October 21, 2015 5:57 AM
    Friday, October 9, 2015 2:31 PM
    Moderator

All replies

  • It's because that's the actual structure returned over TDS (the SQL protocol), and it also helps with Debatching as well.

    • TypedPolling represents the entire response from the database which can include multiple Result Sets (TypedPollingResultSet0)
    • TypedPollingResutlSet0 (the first one) is the actual result set or table.
    • TypedPollingResutlSet0 (the second one) is a Row.

    You can have a structure like:

    TypedPolling

      TypedPollingResutlSet0

        TypedPollingResutlSet0

      TypedPollingResutlSet1

        TypedPollingResutlSet1

      TypedPollingResutlSet2

        TypedPollingResutlSet2

    • Proposed as answer by Angie Xu Wednesday, October 14, 2015 2:07 AM
    • Marked as answer by Angie Xu Wednesday, October 21, 2015 5:57 AM
    Friday, October 9, 2015 2:31 PM
    Moderator
  • Hi,

    Actual schema which you will be getting out of any polling statement is Typed Polling .

    As the typed polling can return you multiple instances or row of the SQL table ,TypedPolling result set is defined which is iterative in nature . Actual Typed polling resultrest will be like below 

    <?xml version="1.0" encoding="utf-8" ?> 
    <TypedPollingResultSet xmlns="http://schemas.microsoft.com/Sql/2008/05/TypedPolling">
       <COLUMN1>[Value]</Column1>
       <COLUMN2>[Value]</Column2>
       …     
    </TypedPollingResultSet>
    You can refer MSDN Link Message Schemas for the Polling and TypedPolling Operations
     

    As been correctly pointed out by BoatSeller  TypedPollingResultSet0 ,1.. is mainly used  when your incoming message contains multiple Iterative records which you can debatch in the Pipeline by setting the Xpath node.

    Once example is listed in link http://www.mpspartners.com/2012/12/GeneratingaBiztalkSchemaforTypedPolling/

    Thanks

    Abhishek

    Friday, October 9, 2015 2:49 PM
  • It is the structure returned from consume adapter service and the only node you care about to do some mapping is Typed Polling. This sturucture is useful for debatching on the port level using envelopschema.

    Cheers


    JB


    Saturday, October 10, 2015 6:28 AM