SQLResultSetRowList
The item() method may take a long time to process. Shouldn't this
have an asynchronous version with a callback?
The ability to randomly access rows in the row set increases the
likelihood that the item operation will take an arbitrarily long time.
Plus, supporting random access is very expensive on limited memory
devices.
Offer next() and previous() methods that returns the next and previous
row respectively.
Offer absolute() and relative() call that may fail. See
java.sql.ResultSet.absolute() and java.sql.ResultSet.relative().
The length attribute could require accessing all the rows, which would
use too much memory on limited memory devices.
Specify that the SQLResultSetRowList that resulted from a call to
SQLTransaction.executeSql() can only be accessed during the execution
of the associated SQLStatementCallback
Property names on result sets are based on column names used in the
query or defined in the view/table. These name sources (colmns,
selections) are case insensitive but the row object would have to use
case-sensitive names. Is there a way that objects can be accessed
without case insensitivity?
Nikunj
http://o-micron.blogspot.com
