'java.lang.NullPointerException' While Executing JPQL Query using IS NOT EMPTY for element-collection of String
(Doc ID 1525818.1)
Last updated on MARCH 01, 2019
Applies to:
Oracle TopLink - Version 11.1.1.4.0 to 11.1.1.4.0 [Release Oracle11g]Information in this document applies to any platform.
Symptoms
Using Toplink Grid version 11.1.1.4.0 with JPA 2.0, created a application while executing JPQL query using 'IS NOT EMPTY' or 'SIZE()' for element-collection Strings.
The JPQL like below:
Example:
You might get the following exception
Caused by: java.lang.NullPointerException
at org.eclipse.persistence.internal.expressions.SubSelectExpression.normalizeSubSelect(SubSelectExpression.java:120)
at org.eclipse.persistence.internal.expressions.ExpressionNormalizer.normalizeSubSelects(ExpressionNormalizer.java:93)
at org.eclipse.persistence.internal.expressions.SQLSelectStatement.normalize(SQLSelectStatement.java:1373)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.buildNormalSelectStatement(ExpressionQueryMechanism.java:491)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.prepareSelectAllRows(ExpressionQueryMechanism.java:1553)
at org.eclipse.persistence.queries.ReadAllQuery.prepareSelectAllRows(ReadAllQuery.java:680)
at org.eclipse.persistence.queries.ReadAllQuery.prepare(ReadAllQuery.java:626)
at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:509)
EclipseLink Bug 318195
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |