im a little confused as to what type should I use if I need to do paging of data.

things I need to do are typical previous row/next row paging and also previous 50 rows/next 50 rows paging

i've been using set all along, but then I read that Sets were not ordered

then with further reading it mentioned using order-by with jdk 1.4 would order the sets, so my question is, can I convert that set to a list (by passing the Set into ArrayList constructor and everything will still be ordered?


or am i totally doing this wrong?

I just need some feedback here so I do go off on a wild tangent..

Check this out... it talks about using a comparator to order collections. http://www.hibernate.org/hib_docs/reference/html/collections.html#collections-s1-8a

This is how we do paging / navigatable list.
NOTE: the query String could have and probably would have an "order by" clause at the end of it.


hope this helped :)

excellent, that did the trick!

Do you know how I can get the previous and next row given the current row? Example, let's say I want to get 1row by a criteria. Now I have this row, I would like to get the previous and next row from this one. How would I do this?

Thanks!