[Carbon-dev] Blocker issue in DSS 2.6.3

Nirodha Pramod nirodha at wso2.com
Wed Dec 7 03:41:26 EST 2011


Hi Anjana,

On Wed, Dec 7, 2011 at 1:51 PM, Anjana Fernando <anjana at wso2.com> wrote:

> Hi Nirodha,
>
> On Wed, Dec 7, 2011 at 1:49 PM, Nirodha Pramod <nirodha at wso2.com> 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 <lakmali at wso2.com>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 <nirodha at wso2.com>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
>>>> Carbon-dev at wso2.org
>>>> 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
>>> Carbon-dev at wso2.org
>>> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>>
>>>
>>
>>
>> --
>> *Nirodha Pramod*
>> Software Engineer, QA.
>> Tel : 0716429078
>>
>>
>> _______________________________________________
>> Carbon-dev mailing list
>> Carbon-dev at wso2.org
>> 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
> Carbon-dev at wso2.org
> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>
>


-- 
*Nirodha Pramod*
Software Engineer, QA.
Tel : 0716429078
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.wso2.org/pipermail/carbon-dev/attachments/20111207/585ad3e7/attachment.html>


More information about the Carbon-dev mailing list