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

Posted by seanizer on Stack Overflow See other posts from Stack Overflow or by seanizer
Published on 2010-05-21T16:40:58Z Indexed on 2010/05/21 18:00 UTC
Read the original article Hit count: 748

Filed under:
|
|

I am rather new to JPA 2 and it's CriteriaBuilder / CriteriaQuery API:

http://java.sun.com/javaee/6/docs/api/javax/persistence/criteria/CriteriaQuery.html

http://java.sun.com/javaee/6/docs/tutorial/doc/gjivm.html

I would like to count the results of a CriteriaQuery without actually retrieving them. Is that possible, I did not find any such method, the only way would be to do this:

    CriteriaBuilder cb = entityManager.getCriteriaBuilder();

    CriteriaQuery<MyEntity> cq = cb
            .createQuery(MyEntityclass);

    // initialize predicates here

    return entityManager.createQuery(cq).getResultList().size();

And that can't be the proper way to do it...

Is there a solution?

© Stack Overflow or respective owner

Related posts about java

Related posts about jpa2.0