paging

[beewax67]

I am working on a website that contains a table that is too big to be displayed on a single page; hence, the user must be able to select the page number to which he/she would like to navigate from a list of pages.

Is there a method to handle this type of functionality in spring?

[Stefan Arentz]

See the jpetstore example in the Spring distribution. The ViewCategoryController uses a PagedListHolder.

Another solution would be to use the DisplayTag library. Google for it, pretty cool stuff.

S.

[standev]

What about performance?

I assume, PagedListHolder works only when you load the entire result set into it and then displays only the current page, right?
But that means we have to load the entire result set of maybe 1,000 rows first.

However we need only 10 rows to display and it's not performance-wise to load more than 10 for our needs. Can you please clarify a little bit, if I'm wrong here?

[Edward Kenworthy]

DisplayTag is entirely view so yes you are right you would load everything into memory.

Options to consider are: demand loading any component parts (still need to load all the parents but it would make what you are loading smaller) and hand-coding a solution in the controller. Tricky bit of course comes if you or another process modifys whichever collection you're working with: you really dont want to keep a transaction open whilst the user pages a list...

[standev]

Okay, so as long as we need to operate large result sets from database, it would be much more preferrable to use database means for results paging.
Like "LIMIT 0, 10" in MySQL or setFirstResult() and setMaxResults() in Hibernate Queries.

[j2eeguru]

Have you seen this?

http://valuelist.sourceforge.net/

[standev]

The setup process seems to be a little bit overcomplicated.
Some people might like it, but I guess just for my application I'll use custom solution like Hibernate features.

[liren]

I think valuelist is better than displaytag now. It seems that I need have to write an adapter to paging using Hibernate.

Is there anyone who have written this paging adapter?

[puffybsd]

Perhaps this isn't the best idea, but I just expose an int firstResult, int maxResults to queries in my hibernate dao that need paging, and
add a query to return the count for the corresponding query.

I manage page counts, etc in a service object, and use jstl tags to render
the html table view. Simple and works.

[strbuf]

Okay, so as long as we need to operate large result sets from database, it would be much more preferrable to use database means for results paging.
Like "LIMIT 0, 10" in MySQL or setFirstResult() and setMaxResults() in Hibernate Queries.

I don't think this is a good idea since it is a dbms dependant.