CursorResultSet
, NoPutResultSet
, TargetResultSet
AnyResultSet
, BasicNoPutResultSetImpl
, BulkTableScanResultSet
, CallStatementResultSet
, CurrentOfResultSet
, DeleteCascadeResultSet
, DeleteResultSet
, DeleteVTIResultSet
, DependentResultSet
, DistinctGroupedAggregateResultSet
, DistinctScalarAggregateResultSet
, DistinctScanResultSet
, DMLVTIResultSet
, DMLWriteGeneratedColumnsResultSet
, DMLWriteResultSet
, GenericAggregateResultSet
, GroupedAggregateResultSet
, HashJoinResultSet
, HashLeftOuterJoinResultSet
, HashScanResultSet
, HashTableResultSet
, IndexRowToBaseRowResultSet
, InsertResultSet
, InsertVTIResultSet
, JoinResultSet
, LastIndexKeyResultSet
, MaterializedResultSet
, MergeJoinResultSet
, MergeResultSet
, MiscResultSet
, MultiProbeTableScanResultSet
, NestedLoopJoinResultSet
, NestedLoopLeftOuterJoinResultSet
, NoPutResultSetImpl
, NormalizeResultSet
, NoRowsResultSetImpl
, OnceResultSet
, ProjectRestrictResultSet
, RowCountResultSet
, RowResultSet
, ScalarAggregateResultSet
, ScanResultSet
, ScrollInsensitiveResultSet
, SetOpResultSet
, SetTransactionResultSet
, SortResultSet
, TableScanResultSet
, TemporaryRowHolderResultSet
, UnionResultSet
, UpdateResultSet
, UpdateVTIResultSet
, ValidateCheckConstraintResultSet
, VTIResultSet
, WindowResultSet
public interface ResultSet
There is no single implementation of the ResultSet interface. Instead, the various support operations involved in executing statements implement this interface.
Although ExecRow is used on the interface, it is not available to users of the API. They should use Row, the exposed super-interface of ExecRow. [I couldn't find another way to perform this mapping...]
Valid transitions:
Modifier and Type | Field | Description |
---|---|---|
static int |
CURRENT_RESULTSET_ONLY |
|
static int |
ENTIRE_RESULTSET_TREE |
|
static int |
ISAFTERLAST |
|
static int |
ISBEFOREFIRST |
|
static int |
ISFIRST |
|
static int |
ISLAST |
Modifier and Type | Method | Description |
---|---|---|
void |
addWarning(java.sql.SQLWarning w) |
Add a warning to this result set.
|
boolean |
checkRowPosition(int isType) |
Determine if the result set is at one of the positions
according to the constants above (ISBEFOREFIRST etc).
|
void |
cleanUp() |
Tells the system to clean up on an error.
|
void |
clearCurrentRow() |
Clear the current row.
|
void |
close() |
Tells the system that there will be no more calls to getNextRow()
(until the next open() call), so it can free up the resources
associated with the ResultSet.
|
void |
finish() |
Tells the system that there will be no more access
to any database information via this result set;
in particular, no more calls to open().
|
ExecRow |
getAbsoluteRow(int row) |
Returns the row at the absolute position from the query,
and returns NULL when there is no such position.
|
Activation |
getActivation() |
|
ResultSet |
getAutoGeneratedKeysResultset() |
ResultSet for rows inserted into the table (contains auto-generated keys columns only)
|
java.sql.Timestamp |
getBeginExecutionTimestamp() |
Get the Timestamp for the beginning of execution.
|
java.lang.String |
getCursorName() |
Returns the name of the cursor, if this is cursor statement of some
type (declare, open, fetch, positioned update, positioned delete,
close).
|
java.sql.Timestamp |
getEndExecutionTimestamp() |
Get the Timestamp for the end of execution.
|
long |
getExecuteTime() |
Get the execution time in milliseconds.
|
ExecRow |
getFirstRow() |
Returns the first row from the query, and returns NULL when there
are no rows.
|
ExecRow |
getLastRow() |
Returns the last row from the query, and returns NULL when there
are no rows.
|
ExecRow |
getNextRow() |
Returns the next row from the query, and returns NULL when there
are no more rows.
|
ExecRow |
getPreviousRow() |
Returns the previous row from the query, and returns NULL when there
are no more previous rows.
|
ExecRow |
getRelativeRow(int row) |
Returns the row at the relative position from the current
cursor position, and returns NULL when there is no such position.
|
ResultDescription |
getResultDescription() |
Returns a ResultDescription object, which describes the results
of the statement this ResultSet is in.
|
int |
getRowNumber() |
Returns the row number of the current row.
|
NoPutResultSet[] |
getSubqueryTrackingArray(int numSubqueries) |
Get the subquery ResultSet tracking array from the top ResultSet.
|
long |
getTimeSpent(int type) |
Return the total amount of time spent in this ResultSet
|
java.sql.SQLWarning |
getWarnings() |
Return the set of warnings generated during the execution of
this result set.
|
boolean |
isClosed() |
Find out if the ResultSet is closed or not.
|
long |
modifiedRowCount() |
Returns the number of rows affected by the statement.
|
void |
open() |
Needs to be called before the result set will do anything.
|
boolean |
returnsRows() |
Returns TRUE if the statement returns rows (i.e. is a SELECT
or FETCH statement), FALSE if it returns no rows.
|
ExecRow |
setAfterLastRow() |
Sets the current position to after the last row and returns NULL
because there is no current row.
|
ExecRow |
setBeforeFirstRow() |
Sets the current position to before the first row and returns NULL
because there is no current row.
|
org.w3c.dom.Element |
toXML(org.w3c.dom.Element parentNode,
java.lang.String tag) |
Produce an xml image of this ResultSet and its descendant ResultSets.
|
static final int CURRENT_RESULTSET_ONLY
static final int ENTIRE_RESULTSET_TREE
static final int ISBEFOREFIRST
static final int ISFIRST
static final int ISLAST
static final int ISAFTERLAST
boolean returnsRows()
long modifiedRowCount()
ResultDescription getResultDescription()
Activation getActivation()
void open() throws StandardException
StandardException
- Thrown on failureExecRow getAbsoluteRow(int row) throws StandardException
row
- The position.StandardException
- Thrown on failureRow
ExecRow getRelativeRow(int row) throws StandardException
row
- The position.StandardException
- Thrown on failureRow
ExecRow setBeforeFirstRow() throws StandardException
StandardException
- Thrown on failureRow
ExecRow getFirstRow() throws StandardException
StandardException
- Thrown on failureRow
ExecRow getNextRow() throws StandardException
StandardException
- Thrown on failureRow
ExecRow getPreviousRow() throws StandardException
StandardException
- Thrown on failureRow
ExecRow getLastRow() throws StandardException
StandardException
- Thrown on failureRow
ExecRow setAfterLastRow() throws StandardException
StandardException
- Thrown on failureRow
void clearCurrentRow()
boolean checkRowPosition(int isType) throws StandardException
StandardException
- Thrown on error.int getRowNumber()
void close() throws StandardException
StandardException
- Thrown on error.void cleanUp() throws StandardException
StandardException
- Thrown on error.boolean isClosed()
void finish() throws StandardException
StandardException
- on errorlong getExecuteTime()
java.sql.Timestamp getBeginExecutionTimestamp()
java.sql.Timestamp getEndExecutionTimestamp()
long getTimeSpent(int type)
type
- CURRENT_RESULTSET_ONLY - time spent only in this ResultSet
ENTIRE_RESULTSET_TREE - time spent in this ResultSet and below.NoPutResultSet[] getSubqueryTrackingArray(int numSubqueries)
numSubqueries
- The size of the array (For allocation on demand.)ResultSet getAutoGeneratedKeysResultset()
java.lang.String getCursorName()
void addWarning(java.sql.SQLWarning w)
w
- the warning to addjava.sql.SQLWarning getWarnings()
org.w3c.dom.Element toXML(org.w3c.dom.Element parentNode, java.lang.String tag) throws java.lang.Exception
Produce an xml image of this ResultSet and its descendant ResultSets. Appends an element to the parentNode and returns the appended element.
parentNode
- Node to put content into.tag
- Element tag for contentjava.lang.Exception
Apache Derby V10.14 Internals - Copyright © 2004,2018 The Apache Software Foundation. All Rights Reserved.