Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>is there a solution other than giving different names to resultsets?</p> <p>If I have 3 methods in a web service and all of them export the same </p> <p>Then it feels unnatural to me to rename them to Customers1, Customers2 and Customers3 for example</p> <p>Here is my sample which causes problems in .NET because there are 3 methods all returning Entries->Entry</p> <pre><code>&lt;data name="ws_getSubnoCCInfo" serviceNamespace="com.test.ws"&gt; &lt;config id="tro"&gt; &lt;property name="driverClassName"&gt;oracle.jdbc.driver.OracleDriver&lt;/property&gt; &lt;property name="url"&gt;jdbc:oracle:thin:xxx/yyy@10.10.10.10:1521/DB&lt;/property&gt; &lt;property name="username"&gt;xxx&lt;/property&gt; &lt;property name="password"&gt;yyy&lt;/property&gt; &lt;/config&gt; &lt;query id="subnoHasCCSQL" useConfig="tro"&gt; &lt;sql&gt;select case when count(*) &amp;gt; 0 then 'OK' else 'NOK' end hasCC from ccinfo where subno = :subno&lt;/sql&gt; &lt;result element="Entries" rowName="Entry"&gt; &lt;element column="hasCC" name="hasCC" xsdType="string"/&gt; &lt;/result&gt; &lt;param name="subno" sqlType="STRING"/&gt; &lt;/query&gt; &lt;query id="idNoHasCCSQL" useConfig="tro"&gt; &lt;sql&gt;select case when count(*) &amp;gt; 0 then 'OK' else 'NOK' end hasCC from ccinfo cc, tabs.crm_departement ui where cc.contrno = ui.contrno and ui.id_no = :id_no&lt;/sql&gt; &lt;result element="Entries" rowName="Entry"&gt; &lt;element column="hasCC" name="hasCC" xsdType="string"/&gt; &lt;/result&gt; &lt;param name="id_no" sqlType="STRING"/&gt; &lt;/query&gt; &lt;query id="contrnoHasCCSQL" useConfig="tro"&gt; &lt;sql&gt;select case when count(*) &amp;gt; 0 then 'OK' else 'NOK' end hasCC from ccinfo cc where contrno = :contrno&lt;/sql&gt; &lt;result element="Entries" rowName="Entry"&gt; &lt;element column="hasCC" name="hasCC" xsdType="string"/&gt; &lt;/result&gt; &lt;param name="contrno" sqlType="STRING"/&gt; &lt;/query&gt; &lt;operation name="subnoHasCC"&gt; &lt;call-query href="subnoHasCCSQL"&gt; &lt;with-param name="subno" query-param="subno"/&gt; &lt;/call-query&gt; &lt;/operation&gt; &lt;operation name="idNoHasCC"&gt; &lt;call-query href="idNoHasCCSQL"&gt; &lt;with-param name="id_no" query-param="id_no"/&gt; &lt;/call-query&gt; &lt;/operation&gt; &lt;operation name="contrnoHasCC"&gt; &lt;call-query href="contrnoHasCCSQL"&gt; &lt;with-param name="contrno" query-param="contrno"/&gt; &lt;/call-query&gt; &lt;/operation&gt; &lt;/data&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload