Examples of org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet

Package org.apache.derby.impl.sql.execute

Examples of org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet

org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet
Provide insensitive scrolling functionality for the underlying result set. We build a disk backed hash table of rows as the user scrolls forward, with the position as the key. For read-only result sets the hash table will containg the following columns:
```
 +-------------------------------+ | KEY                           | +-------------------------------+ | Row                           | +-------------------------------+ 
```
where key is the position of the row in the result set and row is the data. And for updatable result sets it will contain:
```
 +-------------------------------+ | KEY                           | [0] +-------------------------------+ | RowLocation                   | [POS_ROWLOCATION] +-------------------------------+ | Deleted                       | [POS_ROWDELETED] +-------------------------------+ | Updated                       | [POS_ROWUPDATED] +-------------------------------+ | Row                           | [extraColumns ... n] +-------------------------------+ 
```
where key is the position of the row in the result set, rowLocation is the row location of that row in the Heap, Deleted indicates whether the row has been deleted, Updated indicates whether the row has been updated, and row is the data.

                      getResultSetStatistics(mrs.source)
                      );
    }
    else if (rs instanceof ScrollInsensitiveResultSet)
    {
      ScrollInsensitiveResultSet sirs = (ScrollInsensitiveResultSet) rs;


      return new RealScrollInsensitiveResultSetStatistics(
                      sirs.numOpens,
                      sirs.rowsSeen,
                      sirs.rowsFiltered,

View Full Code Here

                      getResultSetStatistics(mrs.source)
                      );
    }
    else if (rs instanceof ScrollInsensitiveResultSet)
    {
      ScrollInsensitiveResultSet sirs = (ScrollInsensitiveResultSet) rs;


      return new RealScrollInsensitiveResultSetStatistics(
                      sirs.numOpens,
                      sirs.rowsSeen,
                      sirs.rowsFiltered,

View Full Code Here

                      getResultSetStatistics(mrs.source)
                      );
    }
    else if (rs instanceof ScrollInsensitiveResultSet)
    {
      ScrollInsensitiveResultSet sirs = (ScrollInsensitiveResultSet) rs;


      return new RealScrollInsensitiveResultSetStatistics(
                      sirs.numOpens,
                      sirs.rowsSeen,
                      sirs.rowsFiltered,

View Full Code Here

                      getResultSetStatistics(mrs.source)
                      );
    }
    else if (rs instanceof ScrollInsensitiveResultSet)
    {
      ScrollInsensitiveResultSet sirs = (ScrollInsensitiveResultSet) rs;


      return new RealScrollInsensitiveResultSetStatistics(
                      sirs.numOpens,
                      sirs.rowsSeen,
                      sirs.rowsFiltered,

View Full Code Here

                      getResultSetStatistics(mrs.source)
                      );
    }
    else if (rs instanceof ScrollInsensitiveResultSet)
    {
      ScrollInsensitiveResultSet sirs = (ScrollInsensitiveResultSet) rs;


      return new RealScrollInsensitiveResultSetStatistics(
                      sirs.numOpens,
                      sirs.rowsSeen,
                      sirs.rowsFiltered,

View Full Code Here

                      getResultSetStatistics(mrs.source)
                      );
    }
    else if (rs instanceof ScrollInsensitiveResultSet)
    {
      ScrollInsensitiveResultSet sirs = (ScrollInsensitiveResultSet) rs;


      return new RealScrollInsensitiveResultSetStatistics(
                      sirs.numOpens,
                      sirs.rowsSeen,
                      sirs.rowsFiltered,

View Full Code Here

                      getResultSetStatistics(mrs.source)
                      );
    }
    else if (rs instanceof ScrollInsensitiveResultSet)
    {
      ScrollInsensitiveResultSet sirs = (ScrollInsensitiveResultSet) rs;


      return new RealScrollInsensitiveResultSetStatistics(
                      sirs.numOpens,
                      sirs.rowsSeen,
                      sirs.rowsFiltered,

View Full Code Here

                      getResultSetStatistics(mrs.source)
                      );
    }
    else if (rs instanceof ScrollInsensitiveResultSet)
    {
      ScrollInsensitiveResultSet sirs = (ScrollInsensitiveResultSet) rs;


      return new RealScrollInsensitiveResultSetStatistics(
                      sirs.numOpens,
                      sirs.rowsSeen,
                      sirs.rowsFiltered,

View Full Code Here

                      getResultSetStatistics(mrs.source)
                      );
    }
    else if (rs instanceof ScrollInsensitiveResultSet)
    {
      ScrollInsensitiveResultSet sirs = (ScrollInsensitiveResultSet) rs;


      return new RealScrollInsensitiveResultSetStatistics(
                      sirs.numOpens,
                      sirs.rowsSeen,
                      sirs.rowsFiltered,

View Full Code Here

TOP

Related Classes of org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet

org.apache.derby.iapi.sql.execute.ExecRow

org.apache.derby.iapi.store.access.BackingStoreHashtable

org.apache.derby.iapi.types.RowLocation

org.apache.derby.iapi.types.SQLBoolean

org.apache.derby.iapi.types.SQLInteger

org.apache.derby.impl.sql.execute.RealResultSetStatisticsFactory

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.