Hi And Regards,

I would like to know how to convert hibernate query for Count.

Example:- For query Like:---

select count(monthid) from month where name='"c1";

The Hibernate Query Is:---


Criteria crit1 = session.createCriteria(Honey1.class);
crit1.add(Restrictions.eq("name",userId));

crit1.setProjection(Projections.projectionList()
.add(Projections.count("monthid"))
)
.list();

List a=(List)crit1.list();


System.out.println("The Count is " +a);

Ans:== 1



The Same thing I would like to know for query Like:--

select count(*) from month where name='"c1";

Plz Do Help Me.
I Will Be So Greatful to You.

Thanks Lot.

Try doing it in HQL:

http://www.hibernate.org/hib_docs/v3/re ... ryhql.html

See section 14.7, 'Aggregate functions'. Cheers,
Roger