Table size using JPA query language

Question

Using JPA query language, how do I determine the size (number of rows) in an entity (table)?

Answer 1

Use the count aggregate function:

EntityManager em = ...
Query q = em.createQuery ("SELECT count(x) FROM Magazine x");
Number result = (Number) q.getSingleResult ();