Check whether the following message formatter is in axis2.xml <messageFormatter contentType="application/json" class="org.apache.axis2.json.JSONMessageFormatter"/>
thanks Eranda On Tue, Jun 17, 2014 at 4:59 AM, Bhathiya Jayasekara <[email protected]> wrote: > Just observed that [1] works fine, while [2] gives above error. > > [1] curl *-H "accept:application/xml"* > http://10.213.209.1:9763/services/samples/RDBMSSample.HTTPEndpoint/getAddress/firstName/Juri/lastName/Yoshido > > [2] curl *-H "accept:application/json"* > http://10.213.209.1:9763/services/samples/RDBMSSample.HTTPEndpoint/getAddress/firstName/Juri/lastName/Yoshido > > Any ideas? > > Thanks, > > > On Mon, Jun 16, 2014 at 4:18 PM, Bhathiya Jayasekara <[email protected]> > wrote: > >> Hi all, >> >> I added a resource to *samples/RDBMSSample* which comes with DSS*.* >> >> <resource method="GET" >> path="getAddress/firstName/{firstName}/lastName/{lastName}"> >> <call-query href="customerAddressSQL"> >> <with-param name="lastName" query-param="lastName"/> >> <with-param name="firstName" query-param="firstName"/> >> </call-query> >> </resource> >> >> Now when I call, >> >> *GET* >> *http://10.213.209.1:9763/services/samples/RDBMSSample.HTTPEndpoint/getAddress/firstName/Juri/lastName/Yoshido >> <http://10.213.209.1:9763/services/samples/RDBMSSample.HTTPEndpoint/getAddress/firstName/Juri/lastName/Yoshido>* >> >> I get following response and backend exceptions. >> >> *Response: * {"Fault":{"Code":"","Reason":"Error while writing to the >> output stream using JsonWriter","Detail":""}} >> >> >> >> *Backend Exception:* >> >> >> [2014-06-16 16:14:59,876] ERROR >> {org.wso2.carbon.dataservices.core.description.query.SQLQuery} - >> java.lang.IllegalStateException >> at com.google.gson.stream.JsonWriter.name(JsonWriter.java:338) >> at >> org.apache.axis2.json.gson.GsonXMLStreamWriter.writeStartJson(GsonXMLStreamWriter.java:134) >> at >> org.apache.axis2.json.gson.GsonXMLStreamWriter.writeStartElement(GsonXMLStreamWriter.java:227) >> at >> org.wso2.carbon.dataservices.core.engine.XMLWriterHelper.writeResultElement(XMLWriterHelper.java:144) >> at >> org.wso2.carbon.dataservices.core.engine.StaticOutputElement.executeElement(StaticOutputElement.java:250) >> at >> org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89) >> at >> org.wso2.carbon.dataservices.core.engine.OutputElementGroup.executeElement(OutputElementGroup.java:106) >> at >> org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89) >> at >> org.wso2.carbon.dataservices.core.description.query.Query.writeResultEntry(Query.java:396) >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:857) >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:2290) >> at >> org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:282) >> at >> org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(CallQuery.java:179) >> at >> org.wso2.carbon.dataservices.core.engine.CallQueryGroup.executeElement(CallQueryGroup.java:111) >> at >> org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89) >> at >> org.wso2.carbon.dataservices.core.description.resource.Resource.execute(Resource.java:67) >> at >> org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:462) >> at >> org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMDataSource.java:96) >> at >> org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:107) >> at >> org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerialize(OMSourcedElementImpl.java:691) >> at >> org.apache.axiom.om.impl.llom.OMSourcedElementImpl.serializeAndConsume(OMSourcedElementImpl.java:754) >> at >> org.apache.axis2.json.gson.JsonFormatter.writeTo(JsonFormatter.java:100) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.sendUsingOutputStream(CommonsHTTPTransportSender.java:411) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:288) >> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) >> at >> org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:45) >> at >> org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110) >> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) >> at >> org.apache.axis2.transport.http.util.RESTUtil.invokeAxisEngine(RESTUtil.java:144) >> at >> org.apache.axis2.transport.http.util.RESTUtil.processURLRequest(RESTUtil.java:139) >> at >> org.apache.axis2.transport.http.AxisServlet$RestRequestProcessor.processURLRequest(AxisServlet.java:837) >> at >> org.wso2.carbon.core.transports.CarbonServlet.handleRestRequest(CarbonServlet.java:303) >> at >> org.wso2.carbon.core.transports.CarbonServlet.doGet(CarbonServlet.java:152) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:735) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:178) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:49) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:141) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >> at java.lang.Thread.run(Thread.java:662) >> [2014-06-16 16:14:59,876] ERROR >> {org.wso2.carbon.dataservices.core.engine.DataService} - DS Fault Message: >> Error in 'SQLQuery.processNormalQuery' >> DS Code: DATABASE_ERROR >> Source Data Service:- >> Name: RDBMSSample >> Location: /samples/RDBMSSample.dbs >> Description: N/A >> Default Namespace: http://ws.wso2.org/dataservice/samples/rdbms_sample >> Current Request Name: _getgetaddress_firstname_firstname_lastname_lastname >> Current Params: {lastName=Yoshido, firstName=Juri} >> Nested Exception:- >> java.lang.IllegalStateException >> >> DS Fault Message: Error in 'SQLQuery.processNormalQuery' >> DS Code: DATABASE_ERROR >> Source Data Service:- >> Name: RDBMSSample >> Location: /samples/RDBMSSample.dbs >> Description: N/A >> Default Namespace: http://ws.wso2.org/dataservice/samples/rdbms_sample >> Current Request Name: _getgetaddress_firstname_firstname_lastname_lastname >> Current Params: {lastName=Yoshido, firstName=Juri} >> Nested Exception:- >> java.lang.IllegalStateException >> >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:864) >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:2290) >> at >> org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:282) >> at >> org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(CallQuery.java:179) >> at >> org.wso2.carbon.dataservices.core.engine.CallQueryGroup.executeElement(CallQueryGroup.java:111) >> at >> org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89) >> at >> org.wso2.carbon.dataservices.core.description.resource.Resource.execute(Resource.java:67) >> at >> org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:462) >> at >> org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMDataSource.java:96) >> at >> org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:107) >> at >> org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerialize(OMSourcedElementImpl.java:691) >> at >> org.apache.axiom.om.impl.llom.OMSourcedElementImpl.serializeAndConsume(OMSourcedElementImpl.java:754) >> at >> org.apache.axis2.json.gson.JsonFormatter.writeTo(JsonFormatter.java:100) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.sendUsingOutputStream(CommonsHTTPTransportSender.java:411) >> at >> org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:288) >> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) >> at >> org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:45) >> at >> org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110) >> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) >> at >> org.apache.axis2.transport.http.util.RESTUtil.invokeAxisEngine(RESTUtil.java:144) >> at >> org.apache.axis2.transport.http.util.RESTUtil.processURLRequest(RESTUtil.java:139) >> at >> org.apache.axis2.transport.http.AxisServlet$RestRequestProcessor.processURLRequest(AxisServlet.java:837) >> at >> org.wso2.carbon.core.transports.CarbonServlet.handleRestRequest(CarbonServlet.java:303) >> at >> org.wso2.carbon.core.transports.CarbonServlet.doGet(CarbonServlet.java:152) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:735) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:178) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:49) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:141) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >> at java.lang.Thread.run(Thread.java:662) >> Caused by: java.lang.IllegalStateException >> at com.google.gson.stream.JsonWriter.name(JsonWriter.java:338) >> at >> org.apache.axis2.json.gson.GsonXMLStreamWriter.writeStartJson(GsonXMLStreamWriter.java:134) >> at >> org.apache.axis2.json.gson.GsonXMLStreamWriter.writeStartElement(GsonXMLStreamWriter.java:227) >> at >> org.wso2.carbon.dataservices.core.engine.XMLWriterHelper.writeResultElement(XMLWriterHelper.java:144) >> at >> org.wso2.carbon.dataservices.core.engine.StaticOutputElement.executeElement(StaticOutputElement.java:250) >> at >> org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89) >> at >> org.wso2.carbon.dataservices.core.engine.OutputElementGroup.executeElement(OutputElementGroup.java:106) >> at >> org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89) >> at >> org.wso2.carbon.dataservices.core.description.query.Query.writeResultEntry(Query.java:396) >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:857) >> ... 54 more >> >> >> >> Am I doing it wrong or is it a bug? >> >> >> Thanks, >> >> -- >> *Bhathiya Jayasekara* >> *Software Engineer,* >> *WSO2 inc., http://wso2.com <http://wso2.com>* >> >> *Phone: +94715478185 <%2B94715478185>* >> *LinkedIn: http://www.linkedin.com/in/bhathiyaj >> <http://www.linkedin.com/in/bhathiyaj>* >> *Twitter: https://twitter.com/bhathiyax <https://twitter.com/bhathiyax>* >> *Blog: http://movingaheadblog.blogspot.com >> <http://movingaheadblog.blogspot.com/>* >> > > > > -- > *Bhathiya Jayasekara* > *Software Engineer,* > *WSO2 inc., http://wso2.com <http://wso2.com>* > > *Phone: +94715478185 <%2B94715478185>* > *LinkedIn: http://www.linkedin.com/in/bhathiyaj > <http://www.linkedin.com/in/bhathiyaj>* > *Twitter: https://twitter.com/bhathiyax <https://twitter.com/bhathiyax>* > *Blog: http://movingaheadblog.blogspot.com > <http://movingaheadblog.blogspot.com/>* > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Eranda Sooriyabandara*Senior Software Engineer; Integration Technologies Team; WSO2 Inc.; http://wso2.com Lean . Enterprise . Middleware E-mail: eranda AT wso2.com Mobile: +94 716 472 816 Linked-In: http://www.linkedin.com/in/erandasooriyabandara Blog: http://emsooriyabandara.blogspot.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
