Count rows using hibernate criteria API

naganirangen · **Posted:** Tue May 26, 2009 2:50 am

Hi,

Can some one help me to findout maximum number of rows in the list of specified values of a column.

Here is the seario.

Table( value , id)

Values (
value1,1
value1,1
value2,2
value2,2
value2,2
value2,2
}

Now I want to write a qurey to get maximum count in the table for the specified ids.
if I pass ids 1 and 2 the maximum count shoud be 4.

Please help me to write this using criteria API.

Thanks,
Naga.

Urmech · **Joined:** Thu Apr 14, 2005 10:39 am **Posts:** 115

See

Code:

org.hibernate.criterion.Projections
static Projection    rowCount() 

in combination with

Code:

org.hibernate.Criteria
Criteria    setProjection(Projection projection) 

E.g.

Code:

c.setProjection(Projections.projectionList().add(Projections.rowCount()));

Greetings Michael

naganirangen · **Posted:** Tue May 26, 2009 5:19 am

Thanks guys for all your replys.

It's working with projections.