That's very strange because the problem was resolved simply removing and recreating the DataService from the same XML configuration... ________________________________________ Da: [email protected] [[email protected]] per conto di Anjana Fernando [[email protected]] Inviato: lunedì 8 marzo 2010 18.44 A: [email protected] Oggetto: Re: [Carbon-dev] R: Problem with dataservice
Hi, Well, that's strange .. without requiredRoles, the response should come without any problems. You can deploy the samples in Data-Services and check how they are run. The samples are at "/wso2wsas-xxx/samples/DataService", goto that directory and run the "ant" command, which will deploy the samples and will be shown in the services list. Cheers, Anjana. On Mon, Mar 8, 2010 at 9:51 PM, Cappa Roberto <[email protected]> wrote: > Hi, > > It works if I add security as you have explained. But, If I remove both > requiredRoles and security, I obtain always the empty response. > > Thanks > ________________________________________ > Da: [email protected] [[email protected]] per conto di > Anjana Fernando [[email protected]] > Inviato: sabato 6 marzo 2010 15.16 > A: [email protected] > Oggetto: Re: [Carbon-dev] Problem with dataservice > > Hi Cappa, > > By checking your configuration, I see that you've given a > 'requiredRole' to the output element. When you specify a required > role, you have to enable security on the service and specify an > authentication method i.e. UsernameToken. So you can either remove the > required role or goto the service dashboard, click security -> Enable > Security -> UsernameToken, and provide username/password when invoking > the service. > > Cheers, > Anjana. > > On Fri, Mar 5, 2010 at 10:02 PM, Cappa Roberto > <[email protected]> wrote: >> Hi, I'm trying for the first time to create a dateService in WSAS 3.1.3 >> >> My test configuration is: >> >> <?xml version="1.0" encoding="UTF-8"?> >> <data name="LoggingData"> >> <config id="H2"> >> <property >> name="org.wso2.ws.dataservice.driver">org.h2.Driver</property> >> <property >> name="org.wso2.ws.dataservice.protocol">jdbc:h2:tcp://localhost/db/mydb</property> >> <property name="org.wso2.ws.dataservice.user">carbon</property> >> <property name="org.wso2.ws.dataservice.password">*****</property> >> <property name="org.wso2.ws.dataservice.minpoolsize">1</property> >> <property name="org.wso2.ws.dataservice.maxpoolsize">20</property> >> <property name="org.wso2.ws.dataservice.autocommit">true</property> >> </config> >> <query id="totalCount" useConfig="H2"> >> <sql>select count(*) as counter from ESB_LOG</sql> >> <result element="counter" rowName="counter" defaultNamespace=""> >> <element name="counter" column="counter" requiredRoles="everyone" >> xsdType="xs:long"/> >> </result> >> </query> >> <operation name="getTotalCount"> >> <call-query href="totalCount"/> >> </operation> >> </data> >> >> The WS method give a response without error, but the result is empty (but >> the query executed on DB retrieves a number): >> >> <soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope";> >> <soapenv:Body> >> <datas3:counter xmlns:datas3="http://ws.wso2.org/dataservice";> >> <datas3:counter/> >> </datas3:counter> >> </soapenv:Body> >> </soapenv:Envelope> >> >> Any idea? Is there an error in configuration? >> >> Thanks >> _______________________________________________ >> Carbon-dev mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> > > _______________________________________________ > Carbon-dev mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > > _______________________________________________ > Carbon-dev mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > _______________________________________________ Carbon-dev mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev _______________________________________________ Carbon-dev mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
