You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@olingo.apache.org by "Ramya (JIRA)" <ji...@apache.org> on 2018/06/07 05:26:00 UTC
[jira] [Commented] (OLINGO-1262) Executing multiple queries in
batch request leads to parameters mismatch / not found
[ https://issues.apache.org/jira/browse/OLINGO-1262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16504263#comment-16504263 ]
Ramya commented on OLINGO-1262:
-------------------------------
Another commit part of this issue - https://git-wip-us.apache.org/repos/asf?p=olingo-odata2.git;a=commit;h=733e1bc6bfa0c1381a266a2dc9099b1d3ef47547
> Executing multiple queries in batch request leads to parameters mismatch / not found
> ------------------------------------------------------------------------------------
>
> Key: OLINGO-1262
> URL: https://issues.apache.org/jira/browse/OLINGO-1262
> Project: Olingo
> Issue Type: Bug
> Components: odata2-jpa
> Affects Versions: V2 2.0.10
> Environment: SAP Cloud Platform
> Reporter: Milko Todorov
> Priority: Major
>
> Hello Olingo community,
> we have an issue when sending multiple queries packed in batch request. Often upon restart of our application (when the caches are empty), the first execution of a particular batch request which contains quite a number of queries we are getting one of the following errors (most of the time the first one):
> {color:#d04437}!/jira/images/icons/emoticons/error.png! You have attempted to set a value of type class java.lang.String for parameter 5 with expected type of int from query string {color}
> {color:#d04437}SELECT E1 FROM CreditProduct E1 WHERE (((E1.creditProductPk.creditAgencyId = ?2) AND ((E1.creditProductTypeCode = ?5) OR (E1.creditProductTypeCode = ?8))) AND (E1.isDeactivated = false)).{color}
> {color:#d04437}!/jira/images/icons/emoticons/error.png! Query argument 33 not found in the list of parameters provided during query execution.{color}
> {color:#d04437}!/jira/images/icons/emoticons/error.png! While trying to invoke the method java.lang.String.contains(java.lang.CharSequence) of a null object returned from org.apache.olingo.odata2.jpa.processor.core.ODataParameterizedWhereExpressionUtil.getJPQLStatement(){color}
> {color:#d04437}!/jira/images/icons/emoticons/error.png! Query argument 3 not found in the list of parameters provided during query execution.{color}
> {color:#333333}It looks like that the issue could be in class {color}*ODataParameterizedWhereExpressionUtil* where the *parameterizedQueryMap* is defined. It is defined as static and it looks like a concurrency issue. Is there a reason behind defining this map as static? It seems very similar to the already opened issue OLINGO-1254
> As soon as the queries runs one time and the caches are filled we don't have it anymore unless the app is restarted.
> Could you please assist us with finding a solution here?
> Thank you,
> Milko
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)