I'm trying to figure out the best way to implement a pageable data list with Spring and Hibernate.
I've set up a basic app which connects to a MySQL DB, selects all the records from a table and returns them to a JSP as a Collection, i.e.
getHibernateTemplate().find("from MyClass myObject");
I've hooked this up to Display Tag (http://displaytag.sourceforge.net), and it works perfectly for small data sets. However, as it reads the entire data set from the DB on every request, it clearly won't scale well.
Short from implementing the whole thing myself, which I'd rather not do as I'm sure I'd just be reinventing the wheel, the only alternative to Display Tag that I can find is ValueList (http://valuelist.sourceforge.net). ValueList looks like it'll do exactly what I want, but with a fairly steep learning curve.
I'm keen to hear how other people are tackling this everyday problem. Is there an established best practice? Am I on the right track with ValueList, shall I just get on with learning it?
Any pointers would be much appreciated.