Hi all,

we are using Hibernate 4.2.21_FINAL and we defined a named query

@javax.persistence.NamedQuery (name = "Position.getByProperties", query = "select var from T_POSITION var WHERE var.properties=0")

in our entity.
The startup already fails with the following exception:

03.01.2017 17:24:47.123 ERROR [ErrorCounter] line 1:72: unexpected token: var
line 1:72: unexpected token: var
at org.hibernate.hql.internal.antlr.HqlBaseParser.primaryExpression(HqlBaseParser.java:991)
at org.hibernate.hql.internal.antlr.HqlBaseParser.atom(HqlBaseParser.java:3493)
at org.hibernate.hql.internal.antlr.HqlBaseParser.unaryExpression(HqlBaseParser.java:3271)
at org.hibernate.hql.internal.antlr.HqlBaseParser.multiplyExpression(HqlBaseParser.java:3143)
at org.hibernate.hql.internal.antlr.HqlBaseParser.additiveExpression(HqlBaseParser.java:2848)
at org.hibernate.hql.internal.antlr.HqlBaseParser.concatenation(HqlBaseParser.java:590)

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: var near line 1, column 72 [select var from com.syncrotess.gen.model.jpa.PositionJpaImpl var WHERE var.properties=0]
at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:79)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:278)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:138)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:104)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:79)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)

The problem only occurs if the property is named "properties". I know that "properties" is a HQL keywords token but I wonder why this one now actually fails, others like "count" work. Is this problem known, is it fixed in newer versions of Hibernate? Or can I escape it somehow? What other keywords cause this problem?

Bjoern

HQL defines the following syntax:



Therefore, the properties keyword is reserved and you can't use it in HQL. What you need to do is rename the "properties" attribute to something else, like "propertyList".