eclipse-ee4j / eclipse-ee4j/eclipselink

Exception [EclipseLink-6089] (Eclipse Persistence Services - 2.7.14.v20231208-d05cebc9b0): org.eclipse.persistence.exceptions.QueryException

Open
#2,153 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
246
Forks
202
Avg merge
1d 22h
Merged PRs (30d)
14

Description

When I start my application I get the following error

Exception [EclipseLink-6089] (Eclipse Persistence Services - 2.7.14.v20231208-d05cebc9b0): org.eclipse.persistence.exceptions.QueryException
Exception Description: The expression has not been initialized correctly. Only a single ExpressionBuilder should be used for a query.
For parallel expressions, the query class must be provided to the ExpressionBuilder constructor, and the query's ExpressionBuilder must
always be on the left side of the expression.

at org.eclipse.persistence.exceptions.QueryException.noExpressionBuilderFound(QueryException.java:922)
at org.eclipse.persistence.expressions.ExpressionBuilder.getDescriptor(ExpressionBuilder.java:203)
at org.eclipse.persistence.internal.expressions.DataExpression.getContainingDescriptor(DataExpression.java:216)
at org.eclipse.persistence.internal.expressions.DataExpression.getMapping(DataExpression.java:223)
at org.eclipse.persistence.internal.expressions.QueryKeyExpression.getMapping(QueryKeyExpression.java:477)
at org.eclipse.persistence.internal.expressions.RelationExpression.checkForeignKeyJoinOptimization(RelationExpression.java:544)
at org.eclipse.persistence.internal.expressions.RelationExpression.normalize(RelationExpression.java:569)
at org.eclipse.persistence.expressions.ExpressionBuilder.normalize(ExpressionBuilder.java:272)
at org.eclipse.persistence.internal.expressions.RelationExpression.checkForeignKeyJoinOptimization(RelationExpression.java:543)
at org.eclipse.persistence.internal.expressions.RelationExpression.normalize(RelationExpression.java:569)
at org.eclipse.persistence.internal.expressions.SQLSelectStatement.normalize(SQLSelectStatement.java:1546)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.buildReportQuerySelectStatement(ExpressionQueryMechanism.java:649)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.buildReportQuerySelectStatement(ExpressionQueryMechanism.java:603)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.prepareReportQuerySelectAllRows(ExpressionQueryMechanism.java:1697)
at org.eclipse.persistence.queries.ReportQuery.prepareSelectAllRows(ReportQuery.java:1249)
at org.eclipse.persistence.queries.ReadAllQuery.prepare(ReadAllQuery.java:841)
at org.eclipse.persistence.queries.ReportQuery.prepare(ReportQuery.java:1117)
at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:675)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.checkPrepare(ObjectLevelReadQuery.java:968)
at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:624)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:194)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:118)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.(EJBQueryImpl.java:104)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.(EJBQueryImpl.java:88)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1749)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
at java.base/java.lang.reflect.Method.invoke(Method.java:577)
at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:362)
at jdk.proxy2/jdk.proxy2.$Proxy266.createQuery(Unknown Source)
at org.springframework.data.jpa.repository.query.SimpleJpaQuery.validateQuery(SimpleJpaQuery.java:90)
... 164 more

The error is relevant to a JPQL query

@Query("SELECT NEW com.x.y.z.service.models.model1(rs.id, rs.a, rs.b, rs.c, rs.d, rs.e, " +
"rs.f, rs.g, rs.h, rs.i, rs.j, rs.k, rs.l, rs.m, rs.n, rs.o, rs.p, rs.q) " +
"FROM model1 rs " +
"inner join model2 s on s.model1.id = rs.id " +
"WHERE s.model3.name = :name")
Page findByName(@Param("name") String name, Pageable pageable);

hints that may help to track the issue\cause for the bug.
In case I add another condition in the where its passes for example:

"WHERE s.model3.name = :name and 'a' = 'a'"

- EclipseLink version 2.7.14
- Java/JDK version 2.7
- Database Postgres

Contributor guide

Open the contributing guide

Research direction

Start with the JPQL query in the report and trace the stack from ExpressionBuilder.getDescriptor through RelationExpression.normalize. Reproduce the query against PostgreSQL, including its paginated Spring Data repository method; done means the query validates without EclipseLink-6089 while retaining the reported projection and join behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, postgresql, spring
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.