wso2dss - can i pass query in request parameter in wso2 DSS -


i have written query in dss like:

select id,name,age,address person id in (?) 

now when accessing above created service in soap ui utility, there passing request :

<soapenv:envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:person="http://tempuri.org">    <soapenv:header/>    <soapenv:body>       <person:getpersondata>          <person:id>select distinct id person</person:id>       </person:getpersondata>    </soapenv:body> </soapenv:envelope> 

now in request passing query, above request doesn't give me response,but when execute above query i.e.

select id,name,age,address person id in (select distinct id person) 

in query browser of mysql response. question how can pass query in input parameter of service. looking forward answers. in advance

please refer sample @ [1}. demonstrates exact scenario.

[1].http://wso2.com/project/data-services/2.6.2/docs/samples/rdbms_sample.html

thank you, dharshana.


Comments