[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [eclipselink-users] JPQL + LIKE + Subquery = MismatchedTokenException
|
Hi Jed,
The reason you are seeing an issue is that JPQL does not allow a subquery as
the argument to a LIKE expression.
You may have to rewrite this JPQL expression as two queries, the first one
containing you inner query and the second one using the results of your inner
query to form your outer query.
-Tom
Jed Smallwood wrote:
Hi,
I'm trying to execute the following JPQL against a Derby database using
eclipse link 1.0.2
SELECT COUNT(j.jobName) FROM Job j WHERE (((j.lineage LIKE (SELECT
j.filterLineage FROM Job j WHERE j.jobName = '100_box' AND j.server =
'server-nc0')) AND j.server = 'server-nc0')) AND (j.jobType<>'BOX')
<skip if you are not interested in the rational of the query>
The idea here is to get a set of jobs that reside underneath the lineage
path that the parent is located in. For example, a containing node, a
box, may have a lineage of '/' meaning that it is at the top. This box
has an ID of 100, and sub nodes of this box will have a lineage of
'/100/'. At the time that this query is constructed all that is known
is the box name. Therefore all sub nodes of this box need to be
gathered in terms of the box name. To assist this query, a second field
filterLineage is defined that has the form '/100/%'. This "AND j.server
=..." you see twice in the query is necessary to scope certain portions
of the query to only operate on one server. More than likely this query
will be operation against multiple servers at the same time.
</skip>
Executing this query causes a MismatchedTokenExcep tion in eclipse link.
Exception Description: Syntax error parsing the query [SELECT
COUNT(j.jobName) FROM Job j WHERE (((j.lineage LIKE (SELECT
j.filterLineage FROM Job j WHERE j.jobName = '100_box' AND j.server =
'server-nc0')) AND j.server = 'server-nc0')) AND (j.jobType<>'BOX')],
line 1, column 61: syntax error at [LIKE].
Internal Exception: MismatchedTokenException(37!=70)
at
org.eclipse.persistence.exceptions.JPQLException.syntaxErrorAt(JPQLException.java:355)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.handleRecognitionException(JPQLParser.java:304)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.addError(JPQLParser.java:245)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.reportError(JPQLParser.java:362)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticPrimary(JPQLParser.java:8904)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticFactor(JPQLParser.java:8620)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticTerm(JPQLParser.java:8444)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.simpleArithmeticExpression(JPQLParser.java:8351)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticPrimary(JPQLParser.java:8890)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticFactor(JPQLParser.java:8620)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticTerm(JPQLParser.java:8444)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.simpleArithmeticExpression(JPQLParser.java:8351)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticPrimary(JPQLParser.java:8890)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticFactor(JPQLParser.java:8620)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticTerm(JPQLParser.java:8444)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.simpleArithmeticExpression(JPQLParser.java:8351)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticExpression(JPQLParser.java:8292)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.simpleConditionalExpression(JPQLParser.java:7039)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.conditionalPrimary(JPQLParser.java:6997)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.conditionalFactor(JPQLParser.java:2989)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.conditionalTerm(JPQLParser.java:2879)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.conditionalExpression(JPQLParser.java:2805)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.whereClause(JPQLParser.java:2762)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectStatement(JPQLParser.java:356)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.document(JPQLParser.java:261)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.parse(JPQLParser.java:133)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParserFactory.parseEJBQLString(JPQLParserFactory.java:33)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParserFactory.populateQuery(JPQLParserFactory.java:51)
at
org.eclipse.persistence.queries.JPQLCall.populateQuery(JPQLCall.java:177)
at
org.eclipse.persistence.internal.queries.JPQLCallQueryMechanism.buildSelectionCriteria(JPQLCallQueryMechanism.java:68)
at
org.eclipse.persistence.queries.DatabaseQuery.buildSelectionCriteria(DatabaseQuery.java:347)
at
org.eclipse.persistence.queries.ObjectLevelReadQuery.prePrepare(ObjectLevelReadQuery.java:1641)
at
org.eclipse.persistence.queries.ObjectLevelReadQuery.checkPrePrepare(ObjectLevelReadQuery.java:632)
at
org.eclipse.persistence.queries.ObjectLevelReadQuery.checkEarlyReturn(ObjectLevelReadQuery.java:567)
at
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:615)
at
org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:840)
at
org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:456)
at
org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108)
...
Caused by: MismatchedTokenException(37!=70)
at
org.eclipse.persistence.internal.libraries.antlr.runtime.BaseRecognizer.mismatch(Unknown
Source)
at
org.eclipse.persistence.internal.libraries.antlr.runtime.BaseRecognizer.match(Unknown
Source)
at
org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.arithmeticPrimary(JPQLParser.java:8893)
My question is, should this type of query be valid with JPQL? If this
is valid and this is not a bug how should it be written? I know I can
go to an ij prompt of Derby and type in the following query against the
same database and it works.
SELECT COUNT(j.job_name) FROM m_job j WHERE (((j.lineage LIKE (SELECT
j.flineage FROM m_job j WHERE j.job_name = '100_box' AND j.server =
'server-nc0')) AND j.server = 'server-nc0')) AND (j.type<>'BOX');
Thanks,
Jed
------------------------------------------------------------------------
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
