Title: How do you get a Web Service to return a record set in XML?

First, which style do you use? Service Styles - RPC, Document, Wrapped, and Message I have tried using RPC and Wrapped, but my return always looks the same:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>
 <getXMLResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <getXMLReturn xsi:type="soapenc:string" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
        &lt;ROWSET&gt;
                &lt;ROW num=&quot;0&quot;&gt;
                        &lt;cid&gt;CENSUSREG&lt;/cid&gt;
                        &lt;ccode&gt;CANADA&lt;/ccode&gt;
                        &lt;cdecode&gt;Canada&lt;/cdecode&gt;
                &lt;/ROW&gt;
                ...


In my Java code, I am attempting to return the following by looping through a record set.  This is stored in a string with tab and newline characters: <ROWSET>

        <ROW num="0">
                <cid>CENSUSREG</cid>
                <ccode>CANADA</ccode>
                <cdecode>Canada</cdecode>
        </ROW>
        ...
</ROWSET>

On the receiving end, in my code, all of the '<', '>', '"' characters get encoded.  Should I be using a different style to get my data.  I am passing in a SQL select statement, and just want the data returned in correct XML format.

Does anyone have an example of how to do this?

Thanks,

Ken Lee



Reply via email to