How do we count rows using Hibernate with where clause?

Question

Possible Duplicate:
How do we count rows using Hibernate?

select count(*) from table where recName = 'any'

I think this question already available,check the link http://stackoverflow.com/questions/1372317/how-do-we-count-rows-using-hibernate — aravindKrishna, May 22 '12 at 09:40
int count = (Integer) session.CreateQuery("select count(*) from table where recName = 'any'").UniqueResult(); — AurA, May 22 '12 at 10:06

score 5 · Answer 1 · edited May 23 '17 at 12:18

This questions was basically already answered on stackoverflow:

How do we count rows using Hibernate?

In addition to the solution using Projections you just have to add your where clause as an additional Criterion to the Criteria.

Criteria criteria = session.createCriteria("Book");
criteria.add(Restrictions.eq("title", "My Title"));
criteria.setProjection(Projections.rowCount());
Number numRows = (Number)criteria.uniqueResult();

score 1 · Answer 2 · answered May 22 '12 at 09:40

1

SELECT Count(*) from DomainClass d where d.someProperty='someValue'

answered May 22 '12 at 09:40

jmj

237,923
42
401
438

How do we count rows using Hibernate with where clause?

2 Answers2