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 <madha...@wso2.com>
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 <sid...@wso2telco.com
> > 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 <sid...@wso2telco.com>
>> 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 <chan...@wso2.com>
>>> 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 <
>>>> sid...@wso2telco.com> 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: sid...@wso2telco.com
>>>>> Blog: https://medium.com/@sidath
>>>>> Linkedin: https://lk.linkedin.com/in/sidathweerasinghe
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Dev mailing list
>>>>> Dev@wso2.org
>>>>> 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: sid...@wso2telco.com
>>> Blog: https://medium.com/@sidath
>>> Linkedin: https://lk.linkedin.com/in/sidathweerasinghe
>>>
>>>
>>
>> --
>> Thank You,
>> Best Regards,
>>
>> Sidath Weerasinghe
>> Senior Software Engineer
>> M: +94719802550 | E: sid...@wso2telco.com
>> Blog: https://medium.com/@sidath
>> Linkedin: https://lk.linkedin.com/in/sidathweerasinghe
>>
>>
>> _______________________________________________
>> Dev mailing list
>> Dev@wso2.org
>> 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: sid...@wso2telco.com
Blog: https://medium.com/@sidath
Linkedin: https://lk.linkedin.com/in/sidathweerasinghe
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
