In JPA 2, using a CriteriaQuery, how to count results

A query of type MyEntity is going to return MyEntity. You want a query for a Long.

CriteriaBuilder qb = entityManager.getCriteriaBuilder();CriteriaQuery<Long> cq = qb.createQuery(Long.class);cq.select(qb.count(cq.from(MyEntity.class)));cq.where(/*your stuff*/);return entityManager.createQuery(cq).getSingleResult();

Obviously you will want to build up your expression with whatever restrictions and groupings etc you skipped in the example.

I've sorted this out using the cb.createQuery() (without the result type parameter):

public class Blah() {    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();    CriteriaQuery query = criteriaBuilder.createQuery();    Root<Entity> root;    Predicate whereClause;    EntityManager entityManager;    Class<Entity> domainClass;    ... Methods to create where clause ...    public Blah(EntityManager entityManager, Class<Entity> domainClass) {        this.entityManager = entityManager;        this.domainClass = domainClass;        criteriaBuilder = entityManager.getCriteriaBuilder();        query = criteriaBuilder.createQuery();        whereClause = criteriaBuilder.equal(criteriaBuilder.literal(1), 1);        root = query.from(domainClass);    }    public CriteriaQuery<Entity> getQuery() {        query.select(root);        query.where(whereClause);        return query;    }    public CriteriaQuery<Long> getQueryForCount() {        query.select(criteriaBuilder.count(root));        query.where(whereClause);        return query;    }    public List<Entity> list() {        TypedQuery<Entity> q = this.entityManager.createQuery(this.getQuery());        return q.getResultList();    }    public Long count() {        TypedQuery<Long> q = this.entityManager.createQuery(this.getQueryForCount());        return q.getSingleResult();    }}

Hope it helps :)

CriteriaBuilder cb = em.getCriteriaBuilder();CriteriaQuery<Long> cq = cb.createQuery(Long.class);cq.select(cb.count(cq.from(MyEntity.class)));return em.createQuery(cq).getSingleResult();