Hi Anjana, On Wed, Dec 7, 2011 at 1:51 PM, Anjana Fernando <[email protected]> wrote:
> 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? .. > > Its the same copy of the dbs file I used in both versions. As I noticed now, in 2.6.0 it might be taking the value for the "ID" from the input param "id", regardless of the case sensitivity. When I changed the input parameter to 'idd' (and changed all the necessary mappings), the response didnt give the value for ID and logged an exception at the back end. /Nirodha > 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 > > -- *Nirodha Pramod* Software Engineer, QA. Tel : 0716429078
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
