Hi Nirodha, On Wed, Dec 7, 2011 at 2:11 PM, Nirodha Pramod <[email protected]> wrote:
> 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. > You got a point there .. we must also be able to retrieve the passed in parameters as results, so please do a test with the correct case, so basically in your original data service, put the column value as "id" (not "ID"), and see if the call succeeds, if not, then it's a bug. The most correct way to get the external parameter values to the result is actually using "query-param" rather than "column", but to keep backward compatibility, what we do is we check query-params (those are the passed in params), and if it's not there, we check column values, and vice-versa. So the idea is basically, if you have a param called "id" and also a column named "id", you can address them separately in the result section. Cheers, Anjana. > > /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 > > -- *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
