Row count with Criteria

andrepena · **Joined:** Thu Sep 13, 2007 4:00 pm **Posts:** 11

Hi all,
I'm using Criteria and I want to retrieve the total number of records without actually return the data. How do I do that? I've already seen Projections but I didn't find any example of usage

somu · **Posted:** Mon Sep 17, 2007 1:29 pm

criteria.setProjection(Projections.rowCount());
int count = (Integer) critera.uniqueResult() ;

Hope this helps.

nilayc · **Joined:** Tue Sep 18, 2007 11:13 am **Posts:** 8

with Scrollable results u can instatiate a cursor to the resultset,
then set the cursorr to point to last record cursor.last()
and get the row number by cursor.getRowNumber().
the returned value is the total number of rows returned.

Anybody having a better idea pls mail me.