Hi Devs, I changed request as to PUT operation and remove the query pram form the URL. Then this worked fine. Thank you so much for supports.
On Fri, Jun 15, 2018 at 5:35 PM Madhawa Gunasekara <[email protected]> wrote: > Hi Sidath, > > There is a limitation when we define resource paths with path params, when > there is a payload available. Can you try to omit path param and use > payload to pass the parameter? > > Thanks, > Madhawa > > On Fri, Jun 15, 2018 at 5:20 PM, Janak Amarasena <[email protected]> wrote: > >> Hi Sidath, >> >> Is there a separate POST endpoint defined like *<resource method="POST" >> path="applications**">* (/applications)? If so, it seems that it is the >> endpoint being called as your JSON payload has the following >> *_postapplications*. The following link[1] has the proper way of >> constructing the JSON payload. >> >> [1] - >> https://docs.wso2.com/display/DSS351/Using+JSON+Messages+with+RESTful+Services >> >> Best Regards, >> >> On Fri, Jun 15, 2018 at 4:11 PM, Sidath Weerasinghe <[email protected] >> > wrote: >> >>> Hi devs, >>> >>> I changed the code as follows, >>> >>> <query id="update_applications" useConfig="test001"> >>> <sql>{call update_application_from_applicationId(?, ?, ?, ?, >>> ?)}</sql> >>> <param name="application_id" ordinal="1" paramType="SCALAR" >>> sqlType="INTEGER" type="IN"/> >>> <param name="word" ordinal="2" paramType="SCALAR" sqlType="STRING" >>> type="IN"/> >>> <param name="code" ordinal="3" paramType="SCALAR" sqlType="STRING" >>> type="IN"/> >>> <param name="status" ordinal="4" paramType="SCALAR" >>> sqlType="STRING" type="IN"/> >>> <param name="word_required" ordinal="5" paramType="SCALAR" >>> sqlType="BOOLEAN" type="IN"/> >>> </query> >>> >>> <resource method="POST" path="applications/{application_id}"> >>> <call-query href="update_applications"> >>> <with-param name="application_id" >>> query-param="application_id"/> >>> <with-param name="word" query-param="word"/> >>> <with-param name="code" query-param="code"/> >>> <with-param name="status" query-param="status"/> >>> <with-param name="word_required" >>> query-param="word_required"/> >>> </call-query> >>> </resource> >>> >>> >>> Request - >>> >>> curl -X POST \ >>> http://127.0.0.1:8280/services/test/applications/3 \ >>> -H 'Accept: application/json' \ >>> -H 'Cache-Control: no-cache' \ >>> -H 'Content-Type: application/json' \ >>> -H 'Postman-Token: 586ef320-573b-495e-9ce8-e64a90703fb5' \ >>> -d '{ >>> "_postapplications" : { >>> "word": "Sida", >>> "code": "12345", >>> "status": "active", >>> "word_required": true >>> } >>> }' >>> >>> >>> But still, I'm getting the below error, >>> >>> [2018-06-15 16:07:31,322] [EI-Core] ERROR - GsonXMLStreamReader Value >>> type miss match, Expected value type - 'null', but found - 'STRING' >>> [2018-06-15 16:07:31,324] [EI-Core] ERROR - ServerWorker Error >>> processing POST reguest for : /services/test/applications/3. Error detail: >>> Value type miss match, Expected value type - 'null', but found - 'STRING'. >>> java.lang.IllegalArgumentException: Value type miss match, Expected >>> value type - 'null', but found - 'STRING' >>> at >>> org.apache.axis2.json.gson.GsonXMLStreamReader.nextValue(GsonXMLStreamReader.java:737) >>> at >>> org.apache.axis2.json.gson.GsonXMLStreamReader.readValue(GsonXMLStreamReader.java:626) >>> at >>> org.apache.axis2.json.gson.GsonXMLStreamReader.stateTransition(GsonXMLStreamReader.java:532) >>> at >>> org.apache.axis2.json.gson.GsonXMLStreamReader.next(GsonXMLStreamReader.java:178) >>> at >>> org.apache.axiom.om.impl.builder.StAXOMBuilder.parserNext(StAXOMBuilder.java:681) >>> at >>> org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:214) >>> at >>> org.apache.axiom.om.impl.llom.OMSerializableImpl.build(OMSerializableImpl.java:78) >>> at >>> org.apache.axiom.om.impl.llom.OMElementImpl.build(OMElementImpl.java:722) >>> at >>> org.apache.axiom.om.impl.llom.OMElementImpl.detach(OMElementImpl.java:700) >>> at >>> org.apache.axiom.om.impl.llom.OMNodeImpl.setParent(OMNodeImpl.java:105) >>> at >>> org.apache.axiom.om.impl.llom.OMElementImpl.addChild(OMElementImpl.java:296) >>> at >>> org.apache.axiom.om.impl.llom.OMElementImpl.addChild(OMElementImpl.java:212) >>> at >>> org.apache.axiom.soap.impl.llom.SOAPBodyImpl.addChild(SOAPBodyImpl.java:231) >>> at >>> org.apache.axis2.json.gson.JSONMessageHandler.invoke(JSONMessageHandler.java:84) >>> at org.apache.axis2.engine.Phase.invokeHandler(Phase.java:340) >>> at org.apache.axis2.engine.Phase.invoke(Phase.java:313) >>> at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:261) >>> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:167) >>> at >>> org.apache.synapse.transport.passthru.ServerWorker.processNonEntityEnclosingRESTHandler(ServerWorker.java:326) >>> at >>> org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:372) >>> at >>> org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:151) >>> at >>> org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) >>> at >>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) >>> at java.lang.Thread.run(Thread.java:748) >>> >>> >>> >>> >>> >>> On Fri, Jun 15, 2018 at 9:45 AM Madhawa Gunasekara <[email protected]> >>> wrote: >>> >>>> Hi Sidath, >>>> >>>> Why are you using XML Mapping instead of JsonMapping [1]. This issue >>>> won't be occured if you use JSON mapping. >>>> >>>> [1] https://docs.wso2.com/display/DSS350/JSON+Mapping >>>> >>>> Thanks, >>>> Madhawa >>>> >>>> On Thu, Jun 14, 2018 at 11:05 AM, Sidath Weerasinghe < >>>> [email protected]> wrote: >>>> >>>>> Hi devs, >>>>> >>>>> Is this error related to this >>>>> <http://wso2-oxygen-tank.10903.n7.nabble.com/Issue-with-EI-6-1-1-update-22-and-24-td156180.html> >>>>> ? >>>>> >>>>> http://wso2-oxygen-tank.10903.n7.nabble.com/Issue-with-EI-6-1-1-update-22-and-24-td156180.html >>>>> >>>>> On Thu, Jun 14, 2018 at 10:21 AM Sidath Weerasinghe < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi Chanika, >>>>>> >>>>>> Im using EI 6.1.1 version and please find the dataservice config. >>>>>> >>>>>> >>>>>> <query id="update_applications" useConfig="test001"> >>>>>> <sql>{call update_application_from_applicationId(?, ?, ?, ?, >>>>>> ?)}</sql> >>>>>> <param name="application_id" ordinal="1" paramType="SCALAR" >>>>>> sqlType="INTEGER" type="IN"/> >>>>>> <param name="word" ordinal="2" paramType="SCALAR" >>>>>> sqlType="STRING" type="IN"/> >>>>>> <param name="code" ordinal="3" paramType="SCALAR" >>>>>> sqlType="STRING" type="IN"/> >>>>>> <param name="status" ordinal="4" paramType="SCALAR" >>>>>> sqlType="STRING" type="IN"/> >>>>>> <param name="word_required" ordinal="5" paramType="SCALAR" >>>>>> sqlType="BOOLEAN" type="IN"/> >>>>>> <result element="applications" rowName="application"> >>>>>> <element column="application_id" name="application_id" >>>>>> xsdType="integer"/> >>>>>> <element column="word" name="word" xsdType="string"/> >>>>>> <element column="code" name="code" xsdType="string"/> >>>>>> <element column="status" name="status" xsdType="string"/> >>>>>> <element column="word_required" name="word_required" >>>>>> xsdType="boolean"/> >>>>>> </result> >>>>>> </query> >>>>>> <resource method="POST" path="applications/{application_id}"> >>>>>> <call-query href="update_applications"> >>>>>> <with-param name="application_id" >>>>>> query-param="application_id"/> >>>>>> <with-param name="word" query-param="word"/> >>>>>> <with-param name="code" query-param="code"/> >>>>>> <with-param name="status" query-param="status"/> >>>>>> <with-param name="word_required" >>>>>> query-param="word_required"/> >>>>>> </call-query> >>>>>> </resource> >>>>>> >>>>>> >>>>>> Request - >>>>>> http://127.0.0.1:8280/services/test/applications/3 >>>>>> { "_postapplications" : { "word": "Sida", "code": "12345", "status": >>>>>> "active", "word_required": true } } >>>>>> >>>>>> >>>>>> On Thu, Jun 14, 2018 at 9:50 AM Chanika Geeganage <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> Hi Sidath, >>>>>>> >>>>>>> What is the DSS version? Is it EI? Also can you please attach the >>>>>>> dataservice config and a sample request to identify the issue? >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>>> On Thu, Jun 14, 2018 at 9:12 AM, Sidath Weerasinghe < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> Hi Devs, >>>>>>>> >>>>>>>> I wrote a DSS service in the WSO2 EI 6.1.1 and I got the following >>>>>>>> error. >>>>>>>> >>>>>>>> [2018-06-14 09:08:33,557] [EI-Core] ERROR - GsonXMLStreamReader >>>>>>>> Value type miss match, Expected value type - 'null', but found - >>>>>>>> 'STRING' >>>>>>>> [2018-06-14 09:08:33,563] [EI-Core] ERROR - ServerWorker Error >>>>>>>> processing POST reguest for : /services/test/applications/3. Error >>>>>>>> detail: >>>>>>>> Value type miss match, Expected value type - 'null', but found - >>>>>>>> 'STRING'. >>>>>>>> java.lang.IllegalArgumentException: Value type miss match, Expected >>>>>>>> value type - 'null', but found - 'STRING' >>>>>>>> at >>>>>>>> org.apache.axis2.json.gson.GsonXMLStreamReader.nextValue(GsonXMLStreamReader.java:737) >>>>>>>> at >>>>>>>> org.apache.axis2.json.gson.GsonXMLStreamReader.readValue(GsonXMLStreamReader.java:626) >>>>>>>> at >>>>>>>> org.apache.axis2.json.gson.GsonXMLStreamReader.stateTransition(GsonXMLStreamReader.java:532) >>>>>>>> at >>>>>>>> org.apache.axis2.json.gson.GsonXMLStreamReader.next(GsonXMLStreamReader.java:178) >>>>>>>> at >>>>>>>> org.apache.axiom.om.impl.builder.StAXOMBuilder.parserNext(StAXOMBuilder.java:681) >>>>>>>> at >>>>>>>> org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:214) >>>>>>>> at >>>>>>>> org.apache.axiom.om.impl.llom.OMSerializableImpl.build(OMSerializableImpl.java:78) >>>>>>>> at >>>>>>>> org.apache.axiom.om.impl.llom.OMElementImpl.build(OMElementImpl.java:722) >>>>>>>> at >>>>>>>> org.apache.axiom.om.impl.llom.OMElementImpl.detach(OMElementImpl.java:700) >>>>>>>> at >>>>>>>> org.apache.axiom.om.impl.llom.OMNodeImpl.setParent(OMNodeImpl.java:105) >>>>>>>> at >>>>>>>> org.apache.axiom.om.impl.llom.OMElementImpl.addChild(OMElementImpl.java:296) >>>>>>>> at >>>>>>>> org.apache.axiom.om.impl.llom.OMElementImpl.addChild(OMElementImpl.java:212) >>>>>>>> at >>>>>>>> org.apache.axiom.soap.impl.llom.SOAPBodyImpl.addChild(SOAPBodyImpl.java:231) >>>>>>>> at >>>>>>>> org.apache.axis2.json.gson.JSONMessageHandler.invoke(JSONMessageHandler.java:84) >>>>>>>> at org.apache.axis2.engine.Phase.invokeHandler(Phase.java:340) >>>>>>>> at org.apache.axis2.engine.Phase.invoke(Phase.java:313) >>>>>>>> at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:261) >>>>>>>> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:167) >>>>>>>> at >>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.processNonEntityEnclosingRESTHandler(ServerWorker.java:326) >>>>>>>> at >>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:372) >>>>>>>> at >>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:151) >>>>>>>> at >>>>>>>> org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) >>>>>>>> at >>>>>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) >>>>>>>> at java.util.concurrent.ThreadPoolExecut >>>>>>>> >>>>>>>> any idea for this ? >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Thank You, >>>>>>>> Best Regards, >>>>>>>> >>>>>>>> Sidath Weerasinghe >>>>>>>> Senior Software Engineer >>>>>>>> M: +94719802550 | E: [email protected] >>>>>>>> Blog: https://medium.com/@sidath >>>>>>>> Linkedin: https://lk.linkedin.com/in/sidathweerasinghe >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Dev mailing list >>>>>>>> [email protected] >>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Best Regards.. >>>>>>> >>>>>>> Chanika Geeganage >>>>>>> +94773522586 >>>>>>> WSO2, Inc.; http://wso2.com >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> Thank You, >>>>>> Best Regards, >>>>>> >>>>>> Sidath Weerasinghe >>>>>> Senior Software Engineer >>>>>> M: +94719802550 | E: [email protected] >>>>>> Blog: https://medium.com/@sidath >>>>>> Linkedin: https://lk.linkedin.com/in/sidathweerasinghe >>>>>> >>>>>> >>>>> >>>>> -- >>>>> Thank You, >>>>> Best Regards, >>>>> >>>>> Sidath Weerasinghe >>>>> Senior Software Engineer >>>>> M: +94719802550 | E: [email protected] >>>>> Blog: https://medium.com/@sidath >>>>> Linkedin: https://lk.linkedin.com/in/sidathweerasinghe >>>>> >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> [email protected] >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> *Madhawa Gunasekara* >>>> Senior Software Engineer >>>> WSO2 Inc.; http://wso2.com >>>> lean.enterprise.middleware >>>> >>>> mobile: +94 719411002 <+94+719411002> >>>> blog: *http://madhawa-gunasekara.blogspot.com >>>> <http://madhawa-gunasekara.blogspot.com>* >>>> linkedin: *http://lk.linkedin.com/in/mgunasekara >>>> <http://lk.linkedin.com/in/mgunasekara>* >>>> >>> >>> >>> -- >>> Thank You, >>> Best Regards, >>> >>> Sidath Weerasinghe >>> Senior Software Engineer >>> M: +94719802550 | E: [email protected] >>> Blog: https://medium.com/@sidath >>> Linkedin: https://lk.linkedin.com/in/sidathweerasinghe >>> >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> *Janak Amarasena* >> >> Software Engineer >> >> Email: [email protected] >> >> Mobile: +94777764144 >> >> Web: https://wso2.com >> >> >> <http://wso2.com/signature> >> > > > > -- > *Madhawa Gunasekara* > Senior Software Engineer > WSO2 Inc.; http://wso2.com > lean.enterprise.middleware > > mobile: +94 719411002 <+94+719411002> > blog: *http://madhawa-gunasekara.blogspot.com > <http://madhawa-gunasekara.blogspot.com>* > linkedin: *http://lk.linkedin.com/in/mgunasekara > <http://lk.linkedin.com/in/mgunasekara>* > -- Thank You, Best Regards, Sidath Weerasinghe Senior Software Engineer M: +94719802550 | E: [email protected] Blog: https://medium.com/@sidath Linkedin: https://lk.linkedin.com/in/sidathweerasinghe
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
