Is this syntactically correct?



I'm passing in the number 58, which is the number returned from a list called q1. I've written the parameter into the query as ':q1' but unfortunately hibernate cannot extract the resultset.

What am I missing? thank you.

I've found out that Hibernate does not recognise offsetting.

I used setFirstResult(int) and setMaxResults(int) to achieve this :-)

Hibernate does not support the LIMIT keyword because that's only recognized by MySQL and PostgreSQL.

By using the:

- setFirstResult
- setMaxResults

Your query is guaranteed to work on all databases supported by Hibernate. For instance, on Oracle 11g, it will use a derived table to limit the result set by ROWNUM. On Oracle 12c, it can use the SQL 2008 syntax: OFFSET N ROWS FETCH NEXT M. But you don't have to worry about the database-specific syntax since Hibernate will take care of that.

I am not seeing that behavior in 5.2.5. Looking at the source code, in every LimitHandler (except for SQLServer2005LimitHandler) I see the following code in processSql():


I am using both setMaxResults() and setFirstResult() and I see that exception every time.

Update - I tried using SQLServer2005LimitHandler and my queries are now working as they did with previous Hibernate versions. I was previously using the SQLServerDialect and its default LimitHandler seemed to support MaxResults and FirstResult. Now I will specifically set my (SQL) dialect to use SQLServer2005LimitHandler.