title: Does Hibernate support the limit statement in MySql?
body: <p>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.</p>
  
  <pre><code>Select t from table1 t where t.column1 = :someVal limit 0,5
  </code></pre>
  
  <p>EDIT: I am using this as a namedQuery and calling this namedQuery using JPA Template</p>
  
  <p>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!!</p>
  
  <p>Regards, RDJ</p>