[wsas-java-dev] [jira] Created: (WSAS-655) Data services: Empty result set returns if the result of the query contains 'attribute' output mapping type

[Charitha Kankanamge (JIRA)]

Data services: Empty result set returns if the result of the query contains 'attribute' output mapping type
-----------------------------------------------------------------------------------------------------------

                 Key: WSAS-655
                 URL: http://wso2.org/jira/browse/WSAS-655
             Project: WSO2 WSAS
          Issue Type: Bug
          Components: data-services
    Affects Versions: Nightly
         Environment: winxp, jdk15
            Reporter: Charitha Kankanamge
         Assigned To: Saminda Wishwajith Abeyruwan 
            Priority: Blocker


I have a data service configuration as given below.

<data name="Employeedataservice">
<config>
<property name="org.wso2.ws.dataservice.driver">com.mysql.jdbc.Driver</property>
<property name="org.wso2.ws.dataservice.protocol">jdbc:mysql://localhost:3306/EmployeeDB</property>
<property name="org.wso2.ws.dataservice.user">root</property>
<property name="org.wso2.ws.dataservice.password">root</property>
</config>
<query id="MtlaviniaEmployees">
<sql>select * from employee where address='Mt. Lavinia'</sql>
<result element="employees" rowName="employee">
<attribute name="name" column="name" />
<attribute name="id" column="id" />
<attribute name="address" column="address" />
</result>
</query>
<operation name="getMtlaviniaemps">
<call-query href="MtlaviniaEmployees" />
</operation>
</data>

As you can see above,  the result of a query contains attribute as the output mapping. I tried to invoke the service by issuing "http://10.100.1.118:9762/services/Employeedataservice/getMtlaviniaemps"

I got the following empty result set.

<data:employees>
<employee/>
<employee/>
<employee/>
</data:employees>



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira