[FINERACT-1104] Adjust JPQL query in likelihood repository

• Type: Sub-task
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.4.0
• Assignee: Yemdjih Kaze Nasser
• Reporter: Yemdjih Kaze Nasser
• Created: 03/Aug/20 12:05
• Updated: 21/Aug/20 08:41
• Resolved: 03/Aug/20 13:10

Description

Caused by: org.eclipse.persistence.exceptions.JPQLException:  
Exception Description: Problem compiling [select liklihood FROM Likelihood liklihood WHERE ppi_name =:ppiName AND id <>:id].  
[49, 57] The identification variable 'ppi_name' is not defined in the FROM clause. 
[73, 75] The identification variable 'id' is not defined in the FROM clause. 
        at org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildException(HermesParser.java:157) ~[org.eclipse.persistence.core-2.7.7.jar:na] 
        at org.eclipse.persistence.internal.jpa.jpql.HermesParser.validate(HermesParser.java:349) ~[org.eclipse.persistence.core-2.7.7.jar:na] 
        at org.eclipse.persistence.internal.jpa.jpql.HermesParser.populateQueryImp(HermesParser.java:280) ~[org.eclipse.persistence.core-2.7.7.jar:na] 
        at org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildQuery(HermesParser.java:165) ~[org.eclipse.persistence.core-2.7.7.jar:na] 
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:142) ~[org.eclipse.persistence.jpa-2.7.7.jar:na] 
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:118) ~[org.eclipse.persistence.jpa-2.7.7.jar:na] 
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:104) ~[org.eclipse.persistence.jpa-2.7.7.jar:na] 
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:88) ~[org.eclipse.persistence.jpa-2.7.7.jar:na] 
        at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1749) ~[org.eclipse.persistence.jpa-2.7.7.jar:na]

Issue Links

• links to: GitHub Pull Request #1231