Query query = entityManager.createQuery("SELECT r " + "FROM Customer AS c , " + "IN( c.reservations ) AS r");
The query parser doesn't like the 'AS' between the 'IN' and the 'r'. I double checked EJB3 PFD and this is valid. (Also verbatum from RMH's book)
The exception:
[java] THE IN OPERATOR and INNER JOIN [java] --------------------------------
[java] SELECT r [java] FROM Customer AS c, IN( c.reservations ) AS r [java] Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: unexpected token: r near line 1, colu mn 72 [SELECT r FROM com.titan.domain.Customer AS c , IN( c.reservations ) AS r] [java] at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59) [java] at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:244) [java] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:155) [java] at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:105) [java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:74) [java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:53) [java] at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71) [java] at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:134) [java] at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:113) [java] at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1600) [java] at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:54) [java] at com.titan.clients.InnerJoin.innerJoin(InnerJoin.java:38) [java] at com.titan.clients.InnerJoin.main(InnerJoin.java:22)
Activity
Show:
Brett Meyer March 3, 2014 at 3:40 PM
Bulk rejecting issues lacking a test case or recent response.
Brett Meyer December 19, 2013 at 10:31 PM
Note: In an attempt to clean up the HHH JIRA, we will be rejecting any ticket that sits in the "Awaiting Test Case" state for 2-3 months with no response. So, if this issue is critical to you, please attach a reproducing test case ASAP. Thanks!
Brett Meyer December 18, 2013 at 9:20 PM
If this is still an issue on ORM 4.2 or 4.3, anyone have a test case to attach?
The Query:
Query query =
entityManager.createQuery("SELECT r " +
"FROM Customer AS c , " +
"IN( c.reservations ) AS r");
The query parser doesn't like the 'AS' between the 'IN' and the 'r'. I double checked EJB3 PFD and this is valid. (Also verbatum from RMH's book)
The exception:
[java] THE IN OPERATOR and INNER JOIN
[java] -------------------------------- [java] SELECT r
[java] FROM Customer AS c, IN( c.reservations ) AS r
[java] Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: unexpected token: r near line 1, colu
mn 72 [SELECT r FROM com.titan.domain.Customer AS c , IN( c.reservations ) AS r]
[java] at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:244)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:155)
[java] at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:105)
[java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:74)
[java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:53)
[java] at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
[java] at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:134)
[java] at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:113)
[java] at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1600)
[java] at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:54)
[java] at com.titan.clients.InnerJoin.innerJoin(InnerJoin.java:38)
[java] at com.titan.clients.InnerJoin.main(InnerJoin.java:22)