Unexpected token limit in JPA

Question

Whenever i'm using LIMIT in JPA query exceptionn is Thrown.can any one suggest me alternative way to filter the record on the basis of their rowNum or ronCount.

Select a from EmployeeBo where a.batchId=:'127'and LIMIT :startPonit,:endPoint,

Answer 1

You can't use LIMIT in JPA Named Query, but you can restrict records up to a row count by using setMaxResult();

Answer 2

You should use Query#setFirstResult() and Query#setMaxResults() for this.