HIbernate query parameter binding throws QuerySyntaxException

Question

I have this hql query :

... DATE_ADD(p.bar.foo, INTERVAL :param SECOND) < NOW() ...

Hibernate throws this exception :

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 715

Hibernate says that the syntax exception is related to :param.

What i wanted to do is just to bind param in a none hql experssion.

Could you please provide minimized but complete hql to reproduce your problem. What database do you use? — SternK
– SternK, Commented Sep 5, 2020 at 5:21

v.ladynev · Accepted Answer · 2020-09-04 23:00:30Z

1

Hibernate HQL doesn't have INTERVAL. You can try to use Criteria with native SQL using Restrictions.sqlRestriction()

answered Sep 4, 2020 at 23:00

v.ladynev

20.1k9 gold badges50 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1