[ 
https://issues.apache.org/jira/browse/ODE-726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Tammo van Lessen resolved ODE-726.
----------------------------------

    Resolution: Fixed

> When filtering with instance IDs (JPA): Cannot compare field _instanceId of 
> type java.lang.Long to value of type java.lang.String. Numeric comparisons 
> must be between numeric types only.
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: ODE-726
>                 URL: https://issues.apache.org/jira/browse/ODE-726
>             Project: ODE
>          Issue Type: Bug
>          Components: Management API
>    Affects Versions: 2.0
>            Reporter: Tammo van Lessen
>            Assignee: Tammo van Lessen
>             Fix For: 2.0
>
>
> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; 
> xmlns:pmap="http://www.apache.org/ode/pmapi";>
>    <soapenv:Header/>
>    <soapenv:Body>
>       <pmap:listInstances>
>          <filter>iid = 151|803</filter>
>          <order></order>
>          <limit>10</limit>
>       </pmap:listInstances>
>    </soapenv:Body>
> </soapenv:Envelope>
> ->
> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/";>
>    <soapenv:Body>
>       <soapenv:Fault>
>          <faultcode>soapenv:Server</faultcode>
>          <faultstring>java.lang.RuntimeException: Invocation of method 
> listInstances in management interface failed: Exception while listing 
> instances: &lt;openjpa-1.3.0-SNAPSHOT-r422266:724491 nonfatal user error> 
> org.apache.openjpa.persistence.ArgumentException: Filter invalid. Cannot 
> compare field _instanceId of type java.lang.Long to value of type 
> java.lang.String. Numeric comparisons must be between numeric types only. To 
> enable such comparisons for backwards-compatibility, add 
> "QuotedNumbersInQueries=true" to the org.apache.openjpa.Compatibility setting 
> in your configuration.</faultstring>
>          <detail>
>             <axis2ns1:RuntimeException 
> xmlns:axis2ns1="http://www.apache.org/ode/pmapi";>java.lang.RuntimeException: 
> Invocation of method listInstances in management interface failed: Exception 
> while listing instances: &lt;openjpa-1.3.0-SNAPSHOT-r422266:724491 nonfatal 
> user error> org.apache.openjpa.persistence.ArgumentException: Filter invalid. 
> Cannot compare field _instanceId of type java.lang.Long to value of type 
> java.lang.String. Numeric comparisons must be between numeric types only. To 
> enable such comparisons for backwards-compatibility, add 
> "QuotedNumbersInQueries=true" to the org.apache.openjpa.Compatibility setting 
> in your configuration.
>       at org.apache.ode.il.DynamicService.invoke(DynamicService.java:84)
>       at 
> org.apache.ode.axis2.service.ManagementService$DynamicMessageReceiver.invokeBusinessLogic(ManagementService.java:126)
>       at 
> org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
>       at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
>       at 
> org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
>       at 
> org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:133)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>       at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>       at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>       at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>       at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>       at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
>       at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>       at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>       at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>       at 
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
>       at 
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
>       at 
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
>       at java.lang.Thread.run(Thread.java:619)
> Caused by: org.apache.ode.bpel.pmapi.ProcessingException: Exception while 
> listing instances: &lt;openjpa-1.3.0-SNAPSHOT-r422266:724491 nonfatal user 
> error> org.apache.openjpa.persistence.ArgumentException: Filter invalid. 
> Cannot compare field _instanceId of type java.lang.Long to value of type 
> java.lang.String. Numeric comparisons must be between numeric types only. To 
> enable such comparisons for backwards-compatibility, add 
> "QuotedNumbersInQueries=true" to the org.apache.openjpa.Compatibility setting 
> in your configuration.
>       at 
> org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl.listInstances(ProcessAndInstanceManagementImpl.java:305)
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>       at java.lang.reflect.Method.invoke(Method.java:597)
>       at org.apache.ode.il.DynamicService.invoke(DynamicService.java:69)
>       ... 19 more</axis2ns1:RuntimeException>
>          </detail>
>       </soapenv:Fault>
>    </soapenv:Body>
> </soapenv:Envelope>

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to