Top Description Fields Constructors Methods
org.hsqldb.navigator

public Class RowSetNavigatorDataTable

extends RowSetNavigatorData
Class Inheritance
Imports
org.hsqldb.HsqlException, .QueryExpression, .QuerySpecification, .Row, .Session, .SortAndSlice, .Table, .TableBase, org.hsqldb.lib.ArrayUtil, org.hsqldb.persist.PersistentStore, org.hsqldb.result.ResultMetaData, org.hsqldb.rowio.RowInputInterface, .RowOutputInterface
Implementation of RowSetNavigator using a table as the data store.
Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
1.9.0
Version
2.7.4

Field Summary

Modifier and TypeField and Description
pack-priv RowIterator
iterator

pack-priv int
iteratorPos

public PersistentStore
store

public TableBase
table

pack-priv Object[]
tempRowData

Inherited from org.hsqldb.navigator.RowSetNavigatorData:
emptyTablefullIndexgroupIndexgroupMapidIndexidMapisAggregateisSimpleAggregatemainIndexorderIndexreindexTablerowNumIndexsimpleAggregateDatasortAndSlicevisibleColumnCount

Constructor Summary

AccessConstructor and Description
public
RowSetNavigatorDataTable(Session session, QuerySpecification select)

public
RowSetNavigatorDataTable(Session session, QuerySpecification select, RowSetNavigatorData navigator)

public
RowSetNavigatorDataTable(Session session, QueryExpression queryExpression)

public
RowSetNavigatorDataTable(Session session, Table table)

Method Summary

Modifier and TypeMethod and Description
public boolean
absolute(int position)

Overrides org.hsqldb.navigator.RowSetNavigatorData.absolute.

Uses similar semantics to java.sql.ResultSet except this is 0 based.

public void
add(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.add.

Add data to the end

pack-priv void
addAdjusted(Object[] data, int[] columnMap)

Overrides org.hsqldb.navigator.RowSetNavigatorData.addAdjusted.

public void
clear()

Overrides org.hsqldb.navigator.RowSetNavigatorData.clear.

Clear the contents

pack-priv boolean
containsRow(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.containsRow.

public void
copy(RowSetNavigatorData other, int[] rightColumnIndexes)

public void
except(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.except.

public void
exceptAll(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.exceptAll.

public void
exceptNoDedup(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.exceptNoDedup.

pack-priv RowIterator
findFirstRow(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.findFirstRow.

public Object[]
getCurrent()

Overrides org.hsqldb.navigator.RowSetNavigatorData.getCurrent.

Implements org.hsqldb.navigator.RowIterator.getCurrent.

Returns the current row object.

public Row
getCurrentRow()

Overrides org.hsqldb.navigator.RowSetNavigatorData.getCurrentRow.

Implements org.hsqldb.navigator.RowIterator.getCurrentRow.

public Object[]
getData(long rowId)

Overrides org.hsqldb.navigator.RowSetNavigatorData.getData.

public Object[]
getGroupData(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.getGroupData.

Special case for isSimpleAggregate cannot use index lookup.

pack-priv boolean
hasNull(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.hasNull.

public boolean
hasUniqueNotNullRows()

Overrides org.hsqldb.navigator.RowSetNavigatorData.hasUniqueNotNullRows.

public void
intersect(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.intersect.

public void
intersectAll(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.intersectAll.

public boolean
isMemory()

Overrides org.hsqldb.navigator.RowSetNavigatorData.isMemory.

public boolean
next()

Overrides org.hsqldb.navigator.RowSetNavigatorData.next.

Implements org.hsqldb.navigator.RowIterator.next.

public void
read(RowInputInterface in, ResultMetaData meta)

Overrides org.hsqldb.navigator.RowSetNavigatorData.read.

public void
release()

Overrides org.hsqldb.navigator.RowSetNavigatorData.release.

Implements org.hsqldb.navigator.RowIterator.release.

Remove any resources and invalidate

public void
removeCurrent()

Overrides org.hsqldb.navigator.RowSetNavigatorData.removeCurrent.

Implements org.hsqldb.navigator.RowIterator.removeCurrent.

Remove current row

public void
removeDuplicates()

Overrides org.hsqldb.navigator.RowSetNavigatorData.removeDuplicates.

public void
reset()

Overrides org.hsqldb.navigator.RowSetNavigatorData.reset.

Implements org.hsqldb.navigator.RangeIterator.reset.

Reset to initial state

pack-priv void
resetIterator()

public void
sortFull()

Overrides org.hsqldb.navigator.RowSetNavigatorData.sortFull.

public void
sortOrder()

Overrides org.hsqldb.navigator.RowSetNavigatorData.sortOrder.

public void
sortOrderUnion(SortAndSlice sortAndSlice)

Overrides org.hsqldb.navigator.RowSetNavigatorData.sortOrderUnion.

private boolean
toCurrentRow()

public void
trim(int limitstart, int limitcount)

Overrides org.hsqldb.navigator.RowSetNavigatorData.trim.

public void
union(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.union.

public void
updateData(long oldRowId, Object[] newData)

Overrides org.hsqldb.navigator.RowSetNavigatorData.updateData.

Used when updating results via JDBC ResultSet methods.

public void
updateData(Object[] oldData, Object[] newData)

Overrides org.hsqldb.navigator.RowSetNavigatorData.updateData.

Used while building grouped results.

public void
write(RowOutputInterface out, ResultMetaData meta)

Overrides org.hsqldb.navigator.RowSetNavigatorData.write.

Inherited from org.hsqldb.navigator.RowSetNavigatorData:
comparecopygetBlockgetGroupDataAndPositioninsertprojectDataremoveDataTableremoveRangeresetRowMapsetPositionunionAll

Field Detail

iteratorback to summary
pack-priv RowIterator iterator
iteratorPosback to summary
pack-priv int iteratorPos
storeback to summary
public PersistentStore store
tableback to summary
public TableBase table
tempRowDataback to summary
pack-priv Object[] tempRowData

Constructor Detail

RowSetNavigatorDataTableback to summary
public RowSetNavigatorDataTable(Session session, QuerySpecification select)
RowSetNavigatorDataTableback to summary
public RowSetNavigatorDataTable(Session session, QuerySpecification select, RowSetNavigatorData navigator)
RowSetNavigatorDataTableback to summary
public RowSetNavigatorDataTable(Session session, QueryExpression queryExpression)
RowSetNavigatorDataTableback to summary
public RowSetNavigatorDataTable(Session session, Table table)

Method Detail

absoluteback to summary
public boolean absolute(int position)

Overrides org.hsqldb.navigator.RowSetNavigatorData.absolute.

Doc from org.hsqldb.navigator.RowSetNavigator.absolute.

Uses similar semantics to java.sql.ResultSet except this is 0 based. When position is 0 or positive, it is from the start; when negative, it means beforeFirst()

addback to summary
public void add(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.add.

Doc from org.hsqldb.navigator.RowSetNavigator.add.

Add data to the end

addAdjustedback to summary
pack-priv void addAdjusted(Object[] data, int[] columnMap)

Overrides org.hsqldb.navigator.RowSetNavigatorData.addAdjusted.

clearback to summary
public void clear()

Overrides org.hsqldb.navigator.RowSetNavigatorData.clear.

Doc from org.hsqldb.navigator.RowSetNavigator.clear.

Clear the contents

containsRowback to summary
pack-priv boolean containsRow(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.containsRow.

copyback to summary
public void copy(RowSetNavigatorData other, int[] rightColumnIndexes)
exceptback to summary
public void except(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.except.

exceptAllback to summary
public void exceptAll(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.exceptAll.

exceptNoDedupback to summary
public void exceptNoDedup(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.exceptNoDedup.

findFirstRowback to summary
pack-priv RowIterator findFirstRow(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.findFirstRow.

getCurrentback to summary
public Object[] getCurrent()

Overrides org.hsqldb.navigator.RowSetNavigatorData.getCurrent.

Implements org.hsqldb.navigator.RowIterator.getCurrent.

Doc from org.hsqldb.navigator.RowSetNavigator.getCurrent.

Returns the current row object. Type of object is implementation defined.

getCurrentRowback to summary
public Row getCurrentRow()

Overrides org.hsqldb.navigator.RowSetNavigatorData.getCurrentRow.

Implements org.hsqldb.navigator.RowIterator.getCurrentRow.

getDataback to summary
public Object[] getData(long rowId)

Overrides org.hsqldb.navigator.RowSetNavigatorData.getData.

getGroupDataback to summary
public Object[] getGroupData(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.getGroupData.

Special case for isSimpleAggregate cannot use index lookup.

hasNullback to summary
pack-priv boolean hasNull(Object[] data)

Overrides org.hsqldb.navigator.RowSetNavigatorData.hasNull.

hasUniqueNotNullRowsback to summary
public boolean hasUniqueNotNullRows()

Overrides org.hsqldb.navigator.RowSetNavigatorData.hasUniqueNotNullRows.

intersectback to summary
public void intersect(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.intersect.

intersectAllback to summary
public void intersectAll(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.intersectAll.

isMemoryback to summary
public boolean isMemory()

Overrides org.hsqldb.navigator.RowSetNavigatorData.isMemory.

nextback to summary
public boolean next()

Overrides org.hsqldb.navigator.RowSetNavigatorData.next.

Implements org.hsqldb.navigator.RowIterator.next.

readback to summary
public void read(RowInputInterface in, ResultMetaData meta)

Overrides org.hsqldb.navigator.RowSetNavigatorData.read.

releaseback to summary
public void release()

Overrides org.hsqldb.navigator.RowSetNavigatorData.release.

Implements org.hsqldb.navigator.RowIterator.release.

Doc from org.hsqldb.navigator.RowSetNavigator.release.

Remove any resources and invalidate

removeCurrentback to summary
public void removeCurrent()

Overrides org.hsqldb.navigator.RowSetNavigatorData.removeCurrent.

Implements org.hsqldb.navigator.RowIterator.removeCurrent.

Doc from org.hsqldb.navigator.RowSetNavigator.removeCurrent.

Remove current row

removeDuplicatesback to summary
public void removeDuplicates()

Overrides org.hsqldb.navigator.RowSetNavigatorData.removeDuplicates.

resetback to summary
public void reset()

Overrides org.hsqldb.navigator.RowSetNavigatorData.reset.

Implements org.hsqldb.navigator.RangeIterator.reset.

Doc from org.hsqldb.navigator.RowSetNavigator.reset.

Reset to initial state

resetIteratorback to summary
pack-priv void resetIterator()
sortFullback to summary
public void sortFull()

Overrides org.hsqldb.navigator.RowSetNavigatorData.sortFull.

sortOrderback to summary
public void sortOrder()

Overrides org.hsqldb.navigator.RowSetNavigatorData.sortOrder.

sortOrderUnionback to summary
public void sortOrderUnion(SortAndSlice sortAndSlice)

Overrides org.hsqldb.navigator.RowSetNavigatorData.sortOrderUnion.

toCurrentRowback to summary
private boolean toCurrentRow()
trimback to summary
public void trim(int limitstart, int limitcount)

Overrides org.hsqldb.navigator.RowSetNavigatorData.trim.

unionback to summary
public void union(RowSetNavigatorData other)

Overrides org.hsqldb.navigator.RowSetNavigatorData.union.

updateDataback to summary
public void updateData(long oldRowId, Object[] newData)

Overrides org.hsqldb.navigator.RowSetNavigatorData.updateData.

Used when updating results via JDBC ResultSet methods. The instance iterator is reset as it may become invalid after a row is removed.

updateDataback to summary
public void updateData(Object[] oldData, Object[] newData)

Overrides org.hsqldb.navigator.RowSetNavigatorData.updateData.

Used while building grouped results.

writeback to summary
public void write(RowOutputInterface out, ResultMetaData meta)

Overrides org.hsqldb.navigator.RowSetNavigatorData.write.