Hello All,

I am new to Hibernate and to this forum! :-) I need your help to figure out best way to calculate total pages for pagination I am implementing in my UI. I am using Criteria class and using .setFirstResult and .setMaxResults to get only specific page information. Like, for first page if my page size is 3 I set the .setFirstResult to 0 and .setMaxResults to 3. My problem is, for example, if in my database I have 30 records, when I do this way my result list size is also giving back 3.

Is there any way in Criteria I can use .setFirstResult and .setMaxResults but at the same time get a total count? What would be the best way to get total count for pagination if I use .setFirstResult and .setMaxResults?

I will appreciate any help or suggestion here.

Thanks!

Code has not been tested:

int count = 0;
int maxRecordsPerPage = 30;
List<cat> list = null;

void someMethod(){
Criteria cats = session.createCriteria(cat.class);
cats.setFirstResult(start);
cats.setMaxResults(maxSize);
list = cats.list();
count = list.size();
}

int getPageCount(){
int fullyFilledPages = count / maxRecordsPerPage;
int isPartialPage = ((count % maxRecordsPerPage) > 0)?(1):(0);
return fullyFilledPages + isPartialPage;
} //of course I would make the above one statement but then I like dense
//you could also use float for the number of pages and then use a ceiling function to round all cases up.

Thank you for your reply. I think I should have been more precise in my question.

What I am trying to ask is -if I have 30 records in the table but my page size is 3 records at a time, is there any way to both restrict fetch size to 3 but get total count of 30 using Criteria? Because, if I set maxResults to 3 then my count also will be 3, which is incorrect. And if I set mexResults to 30 then my query will always retrieve 30 records even if I need only 3 at a time.

Is there anyway I can get total count for the query (in this case 30) but fetch only the number I am looking for (3)?

Thanks,

any suggestion please?

OK..I got it. This is what I did -

int count=((Integer) c.setProjection(Projections.rowCount()).uniqueResult()).intValue();
int index=1;
int noofRcordsPerPage=3; //it can be any number u can update according to ur requirements


String action=ae.getActionCommand()
Criteria crit=null;

if(action.equalsIgnoreCase("next")){ //logic for next page
index=index+1;
crit =session.createCriteria(User.class)
.addOrder( Order.asc("fname") )
.setFirstResult((index*noofRcordsPerPage)-noofRcordsPerPage)
.setMaxResults(noofRcordsPerPage);
}else{
index=index-1; //logic for previous page
crit = session.createCriteria(User.class)
.addOrder( Order.asc("fname") )
.setFirstResult((index*noofRcordsPerPage)-noofRcordsPerPage)
.setMaxResults(noofRcordsPerPage);
}


page count is simple (no of records / noofpages per page) 30/3 =10
u can have no of pages =10
take n=10



code is tested
working fine
hope it willl help

Thanks

when I run your code, it shows error:
java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
at com.tpgsi.framework.services.SearchService.getSearchResult(SearchService.java:52)


how can you say you tested code. lair.