@neilac333: I think it is a good idea that someone focuses on a generic database backed pagination for the Richfaces datatable. Unfortunately I had no time to do so and ended up in using Trinidads table (for our project sorting and paging is needed) with in-memory pagination/sorting, because Pete's code gives me an exception when sorting/paging through a very large resultset. Besides it is not really fast and does a lot of count(*) when paging to the next page. I would appreciate if you could keep me/us updated with your results / researches on this topic! :-) Regards, Alexander View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4123649#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...