I have HQL like this:
from Table1 t1 where t1.name not in (select t2.name from Table2 t2 order by t2.date limit 10)
The problem is it doesn't understand limit
keyword. Is there a way to run such query without splitting it into two subqueries?
I have HQL like this:
from Table1 t1 where t1.name not in (select t2.name from Table2 t2 order by t2.date limit 10)
The problem is it doesn't understand limit
keyword. Is there a way to run such query without splitting it into two subqueries?
look at http://stackoverflow.com/questions/1239723/how-do-you-do-a-limit-query-in-hql
you can't limit a query written in hql with hql. You need to make a call to setMaxResults on the Query object, which i guess will prevent you from applying a limit on a hql subquery.
This leave you with the option of