none
WCF Adapter -Typed polling output RRS feed

  • Question

  • Hi,

    Recently i came accross a scenario where I had to xml pull messages from SQL column based on certain criteria and debatch the messages. So i chose to use typed polling as it supported debatching of pulled messages also. I had used For xml auto in stored procedure. My input was a xml file and the output was split as below:

    <TypedPolling xmlns="http://schemas.microsoft.com/Sql/2008/05/TypedPolling/ReceiveWSDL">
    - <TypedPollingResultSet0>
    - <TypedPollingResultSet0>
      <XML_F52E2B61-18A1-11d1-B105-00805F49916B><Mess.............................................></XML_F52E2B61-18A1-11d1-B105-00805F49916B>
    </TypedPollingResultSet0>
    <TypedPollingResultSet0>
    <XML_F52E2B61-18A1-11d1-B105-00805F49916B><.............age></XML_F52E2B61-18A1-11d1-B105-00805F49916B>
    </TypedPollingResultSet0>
    </TypedPollingResultSet0>
    <TypedPolling >

    Later I changed it to xml polling and other conditions and got the complete message as required.. Could you please let me know why a single message was split as above. Is there any restricted length for messages processed with typed polling or using this xml auto caused all the confusion.

    Please note that the messages are not split onthe basis of rows in SQL.

    Tuesday, September 10, 2013 12:16 PM

Answers

  • Ok, let's try to clear this up.

    What you were seeing is the correct behavior of the Adapter.

    TypedPolling causes the Adapter to treat the response as a RowSet so it sees your xml content as just the value of Row 1, Column 1.  The Guid is generated because it has to give the element a name.  It's null in the actual result set.

    XmlPolling tells the Adapter that the response is an xml stream (still in Row 1, Column 1 as the TDS is essentially the same) and should be returned by itself.

    XmlPolling is there specifically for FOR XML queries and is required when using it.

    • Marked as answer by Pengzhen Song Wednesday, September 18, 2013 1:26 AM
    Tuesday, September 10, 2013 1:35 PM

All replies