hi ,

i have doubt with paging

here is my code

Criteria crit = session.createCriteria(TokenImpl.class);
Criterion userEq=Expression.eq("actorId",actorId);
crit.add(userEq);
// there may be more filters

crit.setFirstResult(startingRecordNo);
crit.setMaxResults(noOfRecords);

is there any method to get the total count of records with that criteria . ( like crit.totalRecords or something like that )

see i need to show (records 1 to 10 of 50 ) kind of report
or shall i use another count(*) query for that one with same filtering options .

please suggest me a best way to do this

thanks

Hibernate 3 has much more capabilities in the Criteria API - check here for some examples: http://www.gloegl.de/blog/archives/hibe ... ancements/

Sorry I forget to mention that i am using hibernate 2

it is presently impossible for me to shift to hibernate 3

then what will be the alternative

thanks

There is none. - There is a patch somewhere in JIRA you might apply that adds count() to criteria.