Hi Nirodha,
In the "get City by ID" query you have given a result element (ID) which is
not returned by the specified query. Query only returns Name and
CountryCode, but you have configured the result with ID as well. In that
case the mentioned exception has occurred. Removing ID result element,
makes this service work correctly.
<query id="get City by ID" useConfig="World">
<sql>Select Name, CountryCode from City WHERE ID=:id</sql>
<properties>
<property
name="org.wso2.ws.dataservice.query_timeout">15</property>
<property
name="org.wso2.ws.dataservice.fetch_direction">reverse</property>
<property
name="org.wso2.ws.dataservice.force_jdbc_batch_requests">true</property>
<property name="org.wso2.ws.dataservice.fetch_size">100</property>
<property name="org.wso2.ws.dataservice.max_rows">50</property>
</properties>
<result element="Keys" rowName="Key">
<element name="ID" column="ID" />
<element name="Name" column="Name" />
<element name="CountryCode" column="CountryCode" />
</result>
<param name="id" sqlType="INTEGER" />
</query>
Thanks
On Wed, Dec 7, 2011 at 12:02 PM, Nirodha Pramod <[email protected]> wrote:
> Hi DSS team,
>
> Services with input parameters does not work. Please have a look.
>
> https://wso2.org/jira/browse/CARBON-11753
>
> --
> *Nirodha Pramod*
> Software Engineer, QA.
> Tel : 0716429078
>
>
> _______________________________________________
> Carbon-dev mailing list
> [email protected]
> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>
>
--
*Lakmali Baminiwatta
*
*Software Engineer
*
*WSO2, Inc.: http://wso2.com*
*lean.enterprise.middleware*
*mobile: +94 71 2335936*
*
*
_______________________________________________
Carbon-dev mailing list
[email protected]
http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
