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

[Maksim Kaszynski (JIRA)]

    [ 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.

> rich:scrollableDataTable. problem with getting property from the ResultSet
> --------------------------------------------------------------------------
>
>                 Key: RF-1005
>                 URL: http://jira.jboss.com/jira/browse/RF-1005
>             Project: RichFaces
>          Issue Type: Bug
>    Affects Versions: 3.0.1
>         Environment: MS Windows XP Professional 
>            Reporter: Greg Ritzinger
>         Assigned To: Konstantin Mishin
>             Fix For: 3.2.0
>
>
> This is the same problem as described in RF-40, except its happening in the ScrollableDataTable component. I've included a reference to the forum discussion regarding the original DataTable problem.

-- 
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