Does HIBERNATE support the limit statement in MySql??

Question

I am working on a project which uses Java,MySql,Struts2 MVC and Hibernate. I tried using limit statement in hql query but its not working properly.

Select t from table1 t where t.column1 = :someVal limit 0,5

EDIT: I am using this as a namedQuery and calling this namedQuery using JPA Template

This works correctly in MySql but when I ran this as a hql query this returns all records without regard to limit statement. Has anyone faced the same problem?? Any help appreciated!!

Regards, RDJ

Answer 1

use Query.setMaxResults(..)

Answer 2

Use hibernates functions for paging! setFirstResult(), setMaxResults()

http://www.javalobby.org/java/forums/t63849.html