Yes, It did. Thanks. BTW this same service (same dbs) worked fine in 2.6.0.
On Wed, Dec 7, 2011 at 1:01 PM, Lakmali Baminiwatta <[email protected]>wrote: > > 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 > > -- *Nirodha Pramod* Software Engineer, QA. Tel : 0716429078
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
