Hi Nirodha, On Wed, Dec 7, 2011 at 1:49 PM, Nirodha Pramod <[email protected]> wrote:
> Yes, It did. Thanks. BTW this same service (same dbs) worked fine in > 2.6.0. It couldn't have worked in 2.6.0, can you please double check, in that case, where did it get the value for the "ID" column in the result? .. Cheers, Anjana. > > > 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 > > -- *Anjana Fernando* Senior Software Engineer WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
