Hibernate criteria + count

kssnatha1 · **Joined:** Thu May 24, 2007 3:01 am **Posts:** 11

Hello friends,

When we retrieving records using criteria, is it possible to have a count as one of the columns.
My requirement is this.

For example we have loan table and borrower table. Say a loan may contain one or many borrowers. (1 borrower, multiple coborrower like that)
I want to list the loans with number of borrowers as one of the columns. How to do this with criteria?

Thank you,

Regards,
K.Siva

plasmafire · **Posted:** Fri Dec 21, 2007 1:32 pm

Code:

        
Criteria crit = session.createCriteria(Product.class);
        crit.setProjection(Projections.rowCount());
        List results = crit.list();
        displayObjectList(results);

Please refer below for simple examples http://www.java2s.com/Code/Java/Hibernate/CatalogHibernate.htm

kssnatha1 · **Joined:** Thu May 24, 2007 3:01 am **Posts:** 11

this will tell only how many rows ie. row count. But what i need is, i want this count as one of the column along the lead details.

Thanks for your suggestions.