Count

Using criteria API:

session.createCriteria(Book.class).setProjection(Projections.rowCount()).uniqueResult();

or native SQL:

session.createQuery("select count(*) from Book").uniqueResult()

Ref:

https://stackoverflow.com/questions/1372317/how-do-we-count-rows-using-hibernate