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: 745
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