public Object doInHibernate(Session session) throws HibernateException { Query q = session.createQuery(dql); q.setFirstResult(size); q.setMaxResults(rInfo.getPageSize()); return q.list(); } We need to make sure the value of parameter of query.setFirstResult is bigger than 0. And it seems that we can also check if hibernate.jdbc.use_scrollable_resultset is set to true. I didn't try this for I resolve this issue by setting the ...