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 correct first result size.