olingo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Bolz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OLINGO-1095) JPAQueryBuilder.normalizeMembers encounters issue when EmbedId
Date Thu, 23 Mar 2017 19:26:41 GMT

    [ https://issues.apache.org/jira/browse/OLINGO-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15939080#comment-15939080
] 

Michael Bolz commented on OLINGO-1095:
--------------------------------------

Hi [~evildracula],

I will take a look into.

The problem seems that the normalization necessary for the navigation property (OLINGO-414)
must not be done for the embedded key case.

Sample: http://localhost:8080/SalesOrderProcessing.svc/SalesOrderLineItems(liId=10L,soId=2L)
Correct (not normalised):
{code}
SELECT E1 FROM SalesOrderItem E1 WHERE E1.salesOrderItemKey.liId = 10L AND E1.salesOrderItemKey.soId
= 2L
{code}

Not correct (normalised):
{code}
SELECT DISTINCT E1 FROM SalesOrderItem E1 JOIN E1.salesOrderItemKey R1 WHERE R1.liId = 10L
AND R1.soId = 2L
{code}

> JPAQueryBuilder.normalizeMembers encounters issue when EmbedId
> --------------------------------------------------------------
>
>                 Key: OLINGO-1095
>                 URL: https://issues.apache.org/jira/browse/OLINGO-1095
>             Project: Olingo
>          Issue Type: Bug
>          Components: odata2-core
>    Affects Versions: V2 2.0.8
>            Reporter: evildracula
>            Assignee: Michael Bolz
>
> org.apache.olingo.odata2.jpa.processor.core.access.data.JPAQueryBuilder
> normalizeMembers failed to process EmbedKeyId when JPA query is:
> SELECT E1 FROM EndUser E1 WHERE E1.id.pid= 'T001' AND E1.id.rid= 'E001'
> the normalized query will be:
> SELECT DISTINCT E1 FROM EndUser E1 JOIN E1.id R1 WHERE R1.pid = 'T001' AND R1.rid = 'E001'
> |This will cause problem when validated by boolean org.eclipse.persistence.jpa.jpql.AbstractSemanticValidator.validateCollectionValuedPathExpression(Expression
expression, boolean collectionTypeOnly)|



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message