W3C home > Mailing lists > Public > public-webapps@w3.org > July to September 2009

WebDatabase review: SQLResultSetRowList

From: Nikunj R. Mehta <nikunj.mehta@oracle.com>
Date: Mon, 31 Aug 2009 15:56:53 -0700
Message-Id: <5C804180-DA0E-4BC1-A875-E81ABC8D8C46@oracle.com>
To: Web Applications Working Group WG <public-webapps@w3.org>
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
Received on Monday, 31 August 2009 22:59:28 GMT

This archive was generated by hypermail 2.3.1 : Tuesday, 26 March 2013 18:49:33 GMT