[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
[eclipselink-users] JPQL + JOIN + SELECT IN
|
I am trying to issue the next JPQL query:
SELECT Object(job) FROM EntityJob job, Dependency dep WHERE (job IN(SELECT
Object(j) FROM EntityJob j where j.jobName = 'TG_HTTP_JOB1')) and
(job.nameId=dep.targetNameId)
Exception Description: Syntax error parsing the query [
SELECT Object(job) FROM EntityJob job, Dependency dep WHERE (job IN(SELECT
Object(j) FROM EntityJob j where j.jobName = 'TG_HTTP_JOB1')) and
(job.nameId=dep.targetNameId)], line 1, column 62: unexpected token [(].
Internal Exception: NoViableAltException(69!=[593:1: conditionalPrimary
returns [Object node] : ( ( LEFT_ROUND_BRACKET conditionalExpression )=>
LEFT_ROUND_BRACKET n= conditionalExpression RIGHT_ROUND_BRACKET | n=
simpleConditionalExpression );])
at
org.eclipse.persistence.exceptions.JPQLException.unexpectedToken(JPQLException.java:365)
I tried to remove the ( and I got a different exception.
--
View this message in context: http://www.nabble.com/JPQL-%2B-JOIN-%2B-SELECT-IN-tp22355819p22355819.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.