[richfaces-issues] [JBoss JIRA] Commented: (RF-1005) rich:scrollableDataTable. problem with getting property from the ResultSet

[ http://jira.jboss.com/jira/browse/RF-1005?page=comments#action_12379098 ] Maksim Kaszynski commented on RF-1005: -------------------------------------- Personally, I don't like the idea of passing resultSet as scrollableDataTable value. It will require additional hacks when it comes to sorting (you'll need to recreate result set based on sorting attributes). Or, you'll just have entire result set fetched, and then sorted by component. There's better solution. What you need is to extend abstract class {code} org.richfaces.model.ScrollableTableDataModel {code} by implementing two basic methods {code} public abstract List loadData(int startRow, int endRow, SortOrder sortOrder); public int getRowCount(); {code} In first method you can build appropriate SQL query (with proper ordering and bounds), navigate over it and return data you need. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira