jpa 2 hibernate limit (max results) to a CriteriaQ

Question

maybe it's a silly question but I cannot find the answer in the docs: How can set a limit to the CriteriaQuery using JPA2?

Thanks

Answer 1

A CriteriaQuery is not an executable Query. You need to create a TypedQuery first using EntityManager.createQuery(criteriaQuery). You can then set the max results of this and execute it.

Answer 2

I usually use:

em.createQuery(criteria).setFirstResult(offset).setMaxResults(max).getResultList();

Answer 3

You could define the offset/limit like this:

return em.createQuery(query)
     .setFirstResult(offset) // offset
     .setMaxResults(limit) // limit
     .getResultList();