Hello,

What I would like to do is something like:

However Hibernate struggles with the OFFSET-Keyword. Is there anything I can do to make it tolerate it?
If possible I would prefer not to use createSQLQuery.

I also had a look at the Criteria-API which I prefer, however DetachedCriteria lacks the Methods setFirstResults() and setMaxResults() which I would require :(

Thank you in advance, Clemens

try those 2 methods, it's the only way i think

Hi Martin,

The Problem with using setFirstResult()/setMaxResult() on the Query directly is performance, because at least in my case PostgreSQL does JOIN all rows, not only the rows between OFFSET and LIMIT even if it would be possible to do so, because the columns joined in don't affect the ordering.

Is there some way to escape SQL keywords not known to Hibernate, so that it doesn't complain executing HQL queries it doesn't fully "understand"?

Thank you in advance, Clemens