hello guys

I need db level [hibernate] paging on my application

like

<< first < previous [1 2 3 4 5 6 7 8 .......] next > Last >>

---------or paging like in this forum 1 2 3 ... 317 318 319 next-----------

i used display tag and value list but the problem is that resulting query data is just infinite and i need to have db level paging [server memory issue]

please guide me if there is any hibernate plug in that automatically does this
or any other way of archiving this in a spring hibernate [web] application

I search about this on internet and find some good examples but being not so intelligent i need to know

1) how << first < previous [1 2 3 4 5 6 7 8 .......] next > Last >> should be calculated for jsp page

2) and how clicking on a particular link from << first < previous [1 2 3 4 5 6 7 8 .......] next > Last >> gets the result for that particular number

please help me

..................................
kind regards

All you need to do is set a MaxResultCount, and keep track of the index.

So if each page is 50 results, you'll send in an index of 0, and a maxresultset of 50.

Like so.

ICriteria crit = NHibernateSession...

crit.SetFirstResult(index);
crit.SetMaxResults(50);

return crit.List();

then your next index will be "50", "100", "150", etc...

thank you mbraunwart for your reply actually my problem is that i also need to display the user that how many record(s) are there in database and

You can set a projection (aggregate) and perform a row count, its minimal hit with usually subsecond results. return a unique result with a count.