Overview  Package   Class  Use  Deprecated  Index
Home >> All >> org >> apache >> derby >> impl >> sql >> [ execute overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---

org.apache.derby.impl.sql.execute
Class NoPutResultSetImpl  

java.lang.Object
  org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl
      org.apache.derby.impl.sql.execute.NoPutResultSetImpl

All Implemented Interfaces:

org.apache.derby.iapi.sql.execute.NoPutResultSet, org.apache.derby.iapi.sql.ResultSet, org.apache.derby.iapi.store.access.RowLocationRetRowSource, org.apache.derby.iapi.store.access.RowSource

Direct Known Subclasses:

AnyResultSet, CurrentOfResultSet, DependentResultSet, GenericAggregateResultSet, HashScanResultSet, HashTableResultSet, IndexRowToBaseRowResultSet, JoinResultSet, LastIndexKeyResultSet, MaterializedResultSet, NormalizeResultSet, OnceResultSet, ProjectRestrictResultSet, RowResultSet, ScrollInsensitiveResultSet, SetOpResultSet, SortResultSet, TableScanResultSet, UnionResultSet, VTIResultSet

---

abstract class NoPutResultSetImpl

extends BasicNoPutResultSetImpl

Abstract ResultSet with built in Activation support for operations that return rows but do not allow the caller to put data on output pipes. This implementation of ResultSet is meant to be overridden by subtypes in the execution engine. Its primary users will be DML operations that do not put data on output pipes, but simply return it due to being result sets themselves.

This abstract class does not define the entire ResultSet interface, but leaves the 'get' half of the interface for subtypes to implement. It is package-visible only, with its methods being public for exposure by its subtypes.

---

Field Summary
protected  org.apache.derby.iapi.sql.Activation	activation
long	beginTime
(package private)  org.apache.derby.iapi.services.loader.GeneratedMethod	checkGM
protected  int[]	checkNullCols
protected  org.apache.derby.iapi.sql.execute.ExecRow	clonedExecRow
long	closeTime
protected  int	cncLen
(package private)  org.apache.derby.iapi.sql.execute.ExecRow	compactRow
long	constructorTime
protected  org.apache.derby.iapi.sql.execute.ExecRow	currentRow
protected  long	endExecutionTime
protected  boolean	finished
(package private)  long	heapConglomerate
protected  java.lang.String	indent
protected  boolean	isOpen
protected  boolean	isTopResultSet
protected  org.apache.derby.iapi.sql.conn.LanguageConnectionContext	lcc
private  boolean	needsRowLocation
long	nextTime
int	numOpens
long	openTime
double	optimizerEstimatedCost
double	optimizerEstimatedRowCount
(package private)  org.apache.derby.iapi.sql.ResultDescription	resultDescription
int	resultSetNumber
int	rowsFiltered
int	rowsSeen
protected  int	sourceDepth
protected  long	startExecutionTime
protected  java.lang.String	subIndent
org.apache.derby.iapi.sql.execute.NoPutResultSet[]	subqueryTrackingArray
protected  org.apache.derby.iapi.sql.execute.TargetResultSet	targetResultSet

 

Fields inherited from interface org.apache.derby.iapi.sql.execute.NoPutResultSet

ABSOLUTE, FIRST, LAST, NEXT, PREVIOUS, RELATIVE

 

Fields inherited from interface org.apache.derby.iapi.sql.ResultSet

CURRENT_RESULTSET_ONLY, ENTIRE_RESULTSET_TREE, ISAFTERLAST, ISBEFOREFIRST, ISFIRST, ISLAST

 

Constructor Summary
(package private)	NoPutResultSetImpl(org.apache.derby.iapi.sql.Activation activation, int resultSetNumber, double optimizerEstimatedRowCount, double optimizerEstimatedCost)           Constructor

 

Method Summary
protected  void	addWarning(java.sql.SQLWarning w)
protected  void	attachStatementContext()           Attach this result set to the top statement context on the stack.
boolean	checkRowPosition(int isType)           Determine if the cursor is before the first row in the result set.
void	cleanUp()           Clean up on error
void	clearCurrentRow()           Clear the current row
protected  void	clearOrderableCache(org.apache.derby.iapi.store.access.Qualifier[][] qualifiers)           Clear the Orderable cache for each qualifier.
void	close()           Close needs to invalidate any dependent statements, if this is a cursor.
void	closeRowSource()           closeRowSource tells the RowSource that it will no longer need to return any rows and it can release any resource it may have.
protected  java.lang.String	dumpTimeStats(java.lang.String indent, java.lang.String subIndent)           Dump out the time information for run time stats.
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().
protected  void	finishAndRTS()
org.apache.derby.iapi.sql.execute.ExecRow	getAbsoluteRow(int row)           Returns the row at the absolute position from the query, and returns NULL when there is no such position.
org.apache.derby.iapi.sql.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.
protected  org.apache.derby.iapi.sql.execute.ExecRow	getCompactRow(org.apache.derby.iapi.sql.execute.ExecRow candidate, org.apache.derby.iapi.services.io.FormatableBitSet accessedCols, org.apache.derby.iapi.services.io.FormatableBitSet otherCols, boolean isKeyed)           Get a compacted version of the candidate row according to the columns specified in the bit map.
protected  long	getCurrentTimeMillis()           Return the current time in milliseconds, if DEBUG and RunTimeStats is on, else return 0.
java.lang.String	getCursorName()           Return my cursor name for JDBC.
protected  long	getElapsedMillis(long beginTime)           Return the elapsed time in milliseconds, between now and the beginTime, if DEBUG and RunTimeStats is on, else return 0.
java.sql.Timestamp	getEndExecutionTimestamp()           Get the Timestamp for the end of execution.
double	getEstimatedRowCount()           Get the estimated row count from this result set.
long	getExecuteTime()           Get the execution time in milliseconds.
(package private)  org.apache.derby.iapi.sql.execute.ExecutionFactory	getExecutionFactory()           Get a execution factory
org.apache.derby.iapi.sql.execute.ExecRow	getFirstRow()           Returns the first row from the query, and returns NULL when there are no rows.
protected  org.apache.derby.iapi.sql.conn.LanguageConnectionContext	getLanguageConnectionContext()           Cache the language connection context.
org.apache.derby.iapi.sql.execute.ExecRow	getLastRow()           Returns the last row from the query, and returns NULL when there are no rows.
org.apache.derby.iapi.sql.execute.ExecRow	getNextRow()           Return the requested values computed from the next row (if any) for which the restriction evaluates to true.
abstract  org.apache.derby.iapi.sql.execute.ExecRow	getNextRowCore()           Return the requested values computed from the next row (if any) for which the restriction evaluates to true.
org.apache.derby.iapi.types.DataValueDescriptor[]	getNextRowFromRowSource()           Get the next row as an array of column objects.
int	getPointOfAttachment()           Return the point of attachment for this subquery.
org.apache.derby.iapi.sql.execute.ExecRow	getPreviousRow()           Returns the previous row from the query, and returns NULL when there are no more previous rows.
org.apache.derby.iapi.sql.execute.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.
org.apache.derby.iapi.sql.ResultDescription	getResultDescription()           Returns the description of the table's rows
int	getRowNumber()           Returns the row number of the current row.
int	getScanIsolationLevel()           Return the isolation level of the scan in the result set.
org.apache.derby.iapi.sql.execute.NoPutResultSet[]	getSubqueryTrackingArray(int numSubqueries)           Get the subquery ResultSet tracking array from the top ResultSet.
(package private)  org.apache.derby.iapi.store.access.TransactionController	getTransactionController()           Get the current transaction controller.
org.apache.derby.iapi.services.io.FormatableBitSet	getValidColumns()           getValidColumns describes the DataValueDescriptor[] returned by all calls to the getNextRowFromRowSource() call.
java.sql.SQLWarning	getWarnings()           Return the set of warnings generated during the execution of this result set.
boolean	isClosed()           Report if closed.
boolean	isForUpdate()           Is this ResultSet or it's source result set for update This method will be overriden in the inherited Classes if it is true
void	markAsTopResultSet()           Mark the ResultSet as the topmost one in the ResultSet tree.
int	modifiedRowCount()           Returns the number of rows affected by the statement.
boolean	needsRowLocation()           needsRowLocation returns true iff this the row source expects the drainer of the row source to call rowLocation after getting a row from getNextRowFromRowSource.
boolean	needsToClone()           Does the caller of getNextRowFromRowSource() need to clone the row in order to keep a reference to the row past the getNextRowFromRowSource() call which returned the row.
void	open()           open a scan on the table.
abstract  void	openCore()           open a scan on the table.
static java.lang.String	printQualifiers(org.apache.derby.iapi.store.access.Qualifier[][] qualifiers)           Return a 2-d array of Qualifiers as a String
void	reopenCore()           This is the default implementation of reopenCore().
boolean	requiresRelocking()           Do we need to relock the row when going to the heap.
int	resultSetNumber()           Get the number of this ResultSet, which is guaranteed to be unique within a statement.
boolean	returnsRows()           Returns true.
void	rowLocation(org.apache.derby.iapi.types.RowLocation rl)           rowLocation is a callback for the drainer of the row source to return the rowLocation of the current row, i.e, the row that is being returned by getNextRowFromRowSource.
org.apache.derby.iapi.sql.execute.ExecRow	setAfterLastRow()           Sets the current position to after the last row and returns NULL because there is no current row.
org.apache.derby.iapi.sql.execute.ExecRow	setBeforeFirstRow()           Sets the current position to before the first row and returns NULL because there is no current row.
protected  void	setCheckConstraints(org.apache.derby.iapi.services.loader.GeneratedMethod checkGM)           Set the GeneratedMethod for enforcing check constraints
protected  org.apache.derby.iapi.sql.execute.ExecRow	setCompactRow(org.apache.derby.iapi.sql.execute.ExecRow candidateRow, org.apache.derby.iapi.sql.execute.ExecRow compactRow)           Copy columns from the candidate row from the store to the given compact row.
protected  void	setCompatRow(org.apache.derby.iapi.sql.execute.ExecRow compactRow, java.lang.Object[] sourceRow)
void	setCurrentRow(org.apache.derby.iapi.sql.execute.ExecRow row)           Set the current row to the row passed in.
protected  void	setHeapConglomerate(long heapConglomerate)           Set the heap conglomerate number (used in enforcing check constraints)
void	setNeedsRowLocation(boolean needsRowLocation)           Set whether or not the NPRS need the row location when acting as a row source.
void	setTargetResultSet(org.apache.derby.iapi.sql.execute.TargetResultSet trs)           Notify a NPRS that it is the source for the specified TargetResultSet.
protected  boolean	skipRow(org.apache.derby.iapi.sql.execute.ExecRow row)           Return true if we should skip the scan due to nulls in the row when the start or stop positioners on the columns containing null do not implement ordered null semantics.
protected  boolean	skipScan(org.apache.derby.iapi.sql.execute.ExecIndexRow startPosition, org.apache.derby.iapi.sql.execute.ExecIndexRow stopPosition)           Return true if we should skip the scan due to nulls in the start or stop position when the predicate on the column(s) in question do not implement ordered null semantics.

 

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

 

Methods inherited from interface org.apache.derby.iapi.sql.ResultSet

getTimeSpent

 

Field Detail

resultSetNumber

public final int resultSetNumber

---

indent

protected java.lang.String indent

---

subIndent

protected java.lang.String subIndent

---

sourceDepth

protected int sourceDepth

---

needsRowLocation

private boolean needsRowLocation

---

clonedExecRow

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

---

checkGM

org.apache.derby.iapi.services.loader.GeneratedMethod checkGM

---

heapConglomerate

long heapConglomerate

---

targetResultSet

protected org.apache.derby.iapi.sql.execute.TargetResultSet targetResultSet

---

checkNullCols

protected int[] checkNullCols

---

cncLen

protected int cncLen

---

isOpen

protected boolean isOpen

---

finished

protected boolean finished

---

currentRow

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

---

isTopResultSet

protected boolean isTopResultSet

---

lcc

protected org.apache.derby.iapi.sql.conn.LanguageConnectionContext lcc

---

numOpens

public int numOpens

---

rowsSeen

public int rowsSeen

---

rowsFiltered

public int rowsFiltered

---

startExecutionTime

protected long startExecutionTime

---

endExecutionTime

protected long endExecutionTime

---

beginTime

public long beginTime

---

constructorTime

public long constructorTime

---

openTime

public long openTime

---

nextTime

public long nextTime

---

closeTime

public long closeTime

---

optimizerEstimatedRowCount

public double optimizerEstimatedRowCount

---

optimizerEstimatedCost

public double optimizerEstimatedCost

---

subqueryTrackingArray

public org.apache.derby.iapi.sql.execute.NoPutResultSet[] subqueryTrackingArray

---

compactRow

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

---

activation

protected org.apache.derby.iapi.sql.Activation activation

---

resultDescription

org.apache.derby.iapi.sql.ResultDescription resultDescription

Constructor Detail

NoPutResultSetImpl

NoPutResultSetImpl(org.apache.derby.iapi.sql.Activation activation,
                   int resultSetNumber,
                   double optimizerEstimatedRowCount,
                   double optimizerEstimatedCost)

Constructor

Method Detail

getResultDescription

public org.apache.derby.iapi.sql.ResultDescription getResultDescription()

Returns the description of the table's rows

Specified by:

getResultDescription in interface org.apache.derby.iapi.sql.ResultSet

Overrides:

getResultDescription in class BasicNoPutResultSetImpl

---

getCursorName

public java.lang.String getCursorName()

Return my cursor name for JDBC. Can be null.

---

resultSetNumber

public int resultSetNumber()

Description copied from interface: org.apache.derby.iapi.sql.execute.NoPutResultSet

Get the number of this ResultSet, which is guaranteed to be unique within a statement.

Specified by:

resultSetNumber in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

Overrides:

resultSetNumber in class BasicNoPutResultSetImpl

---

close

public void close()
           throws org.apache.derby.iapi.error.StandardException

Close needs to invalidate any dependent statements, if this is a cursor. Must be called by any subclasses that override close().

---

setTargetResultSet

public void setTargetResultSet(org.apache.derby.iapi.sql.execute.TargetResultSet trs)

Description copied from interface: org.apache.derby.iapi.sql.execute.NoPutResultSet

Notify a NPRS that it is the source for the specified TargetResultSet. This is useful when doing bulk insert.

---

setNeedsRowLocation

public void setNeedsRowLocation(boolean needsRowLocation)

Description copied from interface: org.apache.derby.iapi.sql.execute.NoPutResultSet

Set whether or not the NPRS need the row location when acting as a row source. (The target result set determines this.)

---

getValidColumns

public org.apache.derby.iapi.services.io.FormatableBitSet getValidColumns()

Description copied from interface: org.apache.derby.iapi.store.access.RowSource

getValidColumns describes the DataValueDescriptor[] returned by all calls to the getNextRowFromRowSource() call. If getValidColumns returns null, the number of columns is given by the DataValueDescriptor.length where DataValueDescriptor[] is returned by the preceeding getNextRowFromRowSource() call. Column N maps to DataValueDescriptor[N], where column numbers start at zero. If getValidColumns return a non null validColumns FormatableBitSet the number of columns is given by the number of bits set in validColumns. Column N is not in the partial row if validColumns.get(N) returns false. Column N is in the partial row if validColumns.get(N) returns true. If column N is in the partial row then it maps to DataValueDescriptor[M] where M is the count of calls to validColumns.get(i) that return true where i < N. If DataValueDescriptor.length is greater than the number of columns indicated by validColumns the extra entries are ignored.

---

getNextRowFromRowSource

public org.apache.derby.iapi.types.DataValueDescriptor[] getNextRowFromRowSource()
                                                                          throws org.apache.derby.iapi.error.StandardException

Description copied from interface: org.apache.derby.iapi.store.access.RowSource

Get the next row as an array of column objects. The column objects can be a JBMS Storable or any Serializable/Externalizable/Formattable/Streaming type.
A return of null indicates that the complete set of rows has been read.

A null column can be specified by leaving the object null, or indicated by returning a non-null getValidColumns. On streaming columns, it can be indicated by returning a non-null get FieldStates.

If RowSource.needToClone() is true then the returned row (the DataValueDescriptor[]) is guaranteed not to be modified by drainer of the RowSource (except that the input stream will be read, of course) and drainer will keep no reference to it before making the subsequent nextRow call. So it is safe to return the same DataValueDescriptor[] in subsequent nextRow calls if that is desirable for performance reasons.

If RowSource.needToClone() is false then the returned row (the DataValueDescriptor[]) may be be modified by drainer of the RowSource, and the drainer may keep a reference to it after making the subsequent nextRow call. In this case the client should severe all references to the row after returning it from getNextRowFromRowSource().

---

needsToClone

public boolean needsToClone()

Description copied from interface: org.apache.derby.iapi.store.access.RowSource

Does the caller of getNextRowFromRowSource() need to clone the row in order to keep a reference to the row past the getNextRowFromRowSource() call which returned the row. This call must always return the same for all rows in a RowSource (ie. the caller will call this once per scan from a RowSource and assume the behavior is true for all rows in the RowSource).

---

closeRowSource

public void closeRowSource()

Description copied from interface: org.apache.derby.iapi.store.access.RowSource

closeRowSource tells the RowSource that it will no longer need to return any rows and it can release any resource it may have. Subsequent call to any method on the RowSource will result in undefined behavior. A closed rowSource can be closed again.

---

needsRowLocation

public boolean needsRowLocation()

Description copied from interface: org.apache.derby.iapi.store.access.RowLocationRetRowSource

needsRowLocation returns true iff this the row source expects the drainer of the row source to call rowLocation after getting a row from getNextRowFromRowSource.

---

rowLocation

public void rowLocation(org.apache.derby.iapi.types.RowLocation rl)
                 throws org.apache.derby.iapi.error.StandardException

Description copied from interface: org.apache.derby.iapi.store.access.RowLocationRetRowSource

rowLocation is a callback for the drainer of the row source to return the rowLocation of the current row, i.e, the row that is being returned by getNextRowFromRowSource. This interface is for the purpose of loading a base table with index. In that case, the indices can be built at the same time the base table is laid down once the row location of the base row is known. This is an example pseudo code on how this call is expected to be used:

                boolean needsRL = rowSource.needsRowLocation();
                DataValueDescriptor[] row;
                while((row = rowSource.getNextRowFromRowSource()) != null)
                {
                        RowLocation rl = heapConglomerate.insertRow(row);
                        if (needsRL)
                                rowSource.rowLocation(rl);
                }
                

NeedsRowLocation and rowLocation will ONLY be called by a drainer of the row source which CAN return a row location. Drainer of row source which cannot return rowLocation will guarentee to not call either callbacks. Conversely, if NeedsRowLocation is called and it returns true, then for every row return by getNextRowFromRowSource, a rowLocation callback must also be issued with the row location of the row. Implementor of both the source and the drain of the row source must be aware of this protocol.
The RowLocation object is own by the caller of rowLocation, in other words, the drainer of the RowSource. This is so that we don't need to new a row location for every row. If the Row Source wants to keep the row location, it needs to clone it (RowLocation is a ClonableObject).

---

clearOrderableCache

protected void clearOrderableCache(org.apache.derby.iapi.store.access.Qualifier[][] qualifiers)
                            throws org.apache.derby.iapi.error.StandardException

Clear the Orderable cache for each qualifier. (This should be done each time a scan/conglomerate with qualifiers is reopened.)

---

setCheckConstraints

protected void setCheckConstraints(org.apache.derby.iapi.services.loader.GeneratedMethod checkGM)

Set the GeneratedMethod for enforcing check constraints

---

setHeapConglomerate

protected void setHeapConglomerate(long heapConglomerate)

Set the heap conglomerate number (used in enforcing check constraints)

---

setCurrentRow

public final void setCurrentRow(org.apache.derby.iapi.sql.execute.ExecRow row)

Set the current row to the row passed in.

---

clearCurrentRow

public final void clearCurrentRow()

Clear the current row

---

isForUpdate

public boolean isForUpdate()

Is this ResultSet or it's source result set for update This method will be overriden in the inherited Classes if it is true

Specified by:

isForUpdate in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

Overrides:

isForUpdate in class BasicNoPutResultSetImpl

---

skipScan

protected boolean skipScan(org.apache.derby.iapi.sql.execute.ExecIndexRow startPosition,
                           org.apache.derby.iapi.sql.execute.ExecIndexRow stopPosition)
                    throws org.apache.derby.iapi.error.StandardException

Return true if we should skip the scan due to nulls in the start or stop position when the predicate on the column(s) in question do not implement ordered null semantics. beetle 4464, we also compact the areNullsOrdered flags into checkNullCols here.

---

skipRow

protected boolean skipRow(org.apache.derby.iapi.sql.execute.ExecRow row)
                   throws org.apache.derby.iapi.error.StandardException

Return true if we should skip the scan due to nulls in the row when the start or stop positioners on the columns containing null do not implement ordered null semantics.

---

printQualifiers

public static java.lang.String printQualifiers(org.apache.derby.iapi.store.access.Qualifier[][] qualifiers)

Return a 2-d array of Qualifiers as a String

---

openCore

public abstract void openCore()
                       throws org.apache.derby.iapi.error.StandardException

Description copied from interface: org.apache.derby.iapi.sql.execute.NoPutResultSet

open a scan on the table. scan parameters are evaluated at each open, so there is probably some way of altering their values...

openCore() can only be called on a closed result set. see reopenCore if you want to reuse an open result set.

Specified by:

openCore in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

---

reopenCore

public void reopenCore()
                throws org.apache.derby.iapi.error.StandardException

This is the default implementation of reopenCore(). It simply does a close() followed by an open(). If there are optimizations to be made (caching, etc), this is a good place to do it -- this will be overridden by a number of resultSet imlementations. and SHOULD be overridden by any node that can get between a base table and a join.

Specified by:

reopenCore in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

---

getNextRowCore

public abstract org.apache.derby.iapi.sql.execute.ExecRow getNextRowCore()
                                                                  throws org.apache.derby.iapi.error.StandardException

Description copied from interface: org.apache.derby.iapi.sql.execute.NoPutResultSet

Return the requested values computed from the next row (if any) for which the restriction evaluates to true.

restriction and projection parameters are evaluated for each row.

Specified by:

getNextRowCore in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

---

getPointOfAttachment

public int getPointOfAttachment()

Description copied from interface: org.apache.derby.iapi.sql.execute.NoPutResultSet

Return the point of attachment for this subquery. (Only meaningful for Any and Once ResultSets, which can and will only be at the top of a ResultSet for a subquery.)

Specified by:

getPointOfAttachment in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

---

markAsTopResultSet

public void markAsTopResultSet()

Mark the ResultSet as the topmost one in the ResultSet tree. Useful for closing down the ResultSet on an error.

Specified by:

markAsTopResultSet in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

---

getScanIsolationLevel

public int getScanIsolationLevel()

Description copied from interface: org.apache.derby.iapi.sql.execute.NoPutResultSet

Return the isolation level of the scan in the result set. Only expected to be called for those ResultSets that contain a scan.

Specified by:

getScanIsolationLevel in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

---

getEstimatedRowCount

public double getEstimatedRowCount()

Description copied from interface: org.apache.derby.iapi.sql.execute.NoPutResultSet

Get the estimated row count from this result set.

Specified by:

getEstimatedRowCount in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

---

requiresRelocking

public boolean requiresRelocking()

Description copied from interface: org.apache.derby.iapi.sql.execute.NoPutResultSet

Do we need to relock the row when going to the heap.

Specified by:

requiresRelocking in interface org.apache.derby.iapi.sql.execute.NoPutResultSet

---

open

public final void open()
                throws org.apache.derby.iapi.error.StandardException

open a scan on the table. scan parameters are evaluated at each open, so there is probably some way of altering their values... NOTE: This method should only be called on the top ResultSet of a ResultSet tree to ensure that the entire ResultSet tree gets closed down on an error. the openCore() method will be called for all other ResultSets in the tree.

Specified by:

open in interface org.apache.derby.iapi.sql.ResultSet

---

getAbsoluteRow

public org.apache.derby.iapi.sql.execute.ExecRow getAbsoluteRow(int row)
                                                         throws org.apache.derby.iapi.error.StandardException

Returns the row at the absolute position from the query, and returns NULL when there is no such position. (Negative position means from the end of the result set.) Moving the cursor to an invalid position leaves the cursor positioned either before the first row (negative position) or after the last row (positive position). NOTE: An exception will be thrown on 0.

Specified by:

getAbsoluteRow in interface org.apache.derby.iapi.sql.ResultSet

---

getRelativeRow

public org.apache.derby.iapi.sql.execute.ExecRow getRelativeRow(int row)
                                                         throws org.apache.derby.iapi.error.StandardException

Returns the row at the relative position from the current cursor position, and returns NULL when there is no such position. (Negative position means toward the beginning of the result set.) Moving the cursor to an invalid position leaves the cursor positioned either before the first row (negative position) or after the last row (positive position). NOTE: 0 is valid. NOTE: An exception is thrown if the cursor is not currently positioned on a row.

Specified by:

getRelativeRow in interface org.apache.derby.iapi.sql.ResultSet

---

setBeforeFirstRow

public org.apache.derby.iapi.sql.execute.ExecRow setBeforeFirstRow()
                                                            throws org.apache.derby.iapi.error.StandardException

Sets the current position to before the first row and returns NULL because there is no current row.

Specified by:

setBeforeFirstRow in interface org.apache.derby.iapi.sql.ResultSet

---

checkRowPosition

public boolean checkRowPosition(int isType)
                         throws org.apache.derby.iapi.error.StandardException

Determine if the cursor is before the first row in the result set.

Specified by:

checkRowPosition in interface org.apache.derby.iapi.sql.ResultSet

---

getRowNumber

public int getRowNumber()

Returns the row number of the current row. Row numbers start from 1 and go to 'n'. Corresponds to row numbering used to position current row in the result set (as per JDBC).

Specified by:

getRowNumber in interface org.apache.derby.iapi.sql.ResultSet

---

getFirstRow

public org.apache.derby.iapi.sql.execute.ExecRow getFirstRow()
                                                      throws org.apache.derby.iapi.error.StandardException

Returns the first row from the query, and returns NULL when there are no rows.

Specified by:

getFirstRow in interface org.apache.derby.iapi.sql.ResultSet

---

getNextRow

public final org.apache.derby.iapi.sql.execute.ExecRow getNextRow()
                                                           throws org.apache.derby.iapi.error.StandardException

Return the requested values computed from the next row (if any) for which the restriction evaluates to true.

restriction and projection parameters are evaluated for each row. NOTE: This method should only be called on the top ResultSet of a ResultSet tree to ensure that the entire ResultSet tree gets closed down on an error. the getNextRowCore() method will be called for all other ResultSets in the tree.

Specified by:

getNextRow in interface org.apache.derby.iapi.sql.ResultSet

---

getPreviousRow

public org.apache.derby.iapi.sql.execute.ExecRow getPreviousRow()
                                                         throws org.apache.derby.iapi.error.StandardException

Returns the previous row from the query, and returns NULL when there are no more previous rows.

Specified by:

getPreviousRow in interface org.apache.derby.iapi.sql.ResultSet

---

getLastRow

public org.apache.derby.iapi.sql.execute.ExecRow getLastRow()
                                                     throws org.apache.derby.iapi.error.StandardException

Returns the last row from the query, and returns NULL when there are no rows.

Specified by:

getLastRow in interface org.apache.derby.iapi.sql.ResultSet

---

setAfterLastRow

public org.apache.derby.iapi.sql.execute.ExecRow setAfterLastRow()
                                                          throws org.apache.derby.iapi.error.StandardException

Sets the current position to after the last row and returns NULL because there is no current row.

Specified by:

setAfterLastRow in interface org.apache.derby.iapi.sql.ResultSet

---

returnsRows

public boolean returnsRows()

Returns true.

Specified by:

returnsRows in interface org.apache.derby.iapi.sql.ResultSet

---

modifiedRowCount

public final int modifiedRowCount()

Description copied from interface: org.apache.derby.iapi.sql.ResultSet

Returns the number of rows affected by the statement. Only valid of returnsRows() returns false. For other DML statements, it returns the number of rows modified by the statement. For statements that do not affect rows (like DDL statements), it returns zero.

Specified by:

modifiedRowCount in interface org.apache.derby.iapi.sql.ResultSet

---

cleanUp

public void cleanUp()
             throws org.apache.derby.iapi.error.StandardException

Clean up on error

Specified by:

cleanUp in interface org.apache.derby.iapi.sql.ResultSet

---

isClosed

public boolean isClosed()

Report if closed.

Specified by:

isClosed in interface org.apache.derby.iapi.sql.ResultSet

---

finish

public void finish()
            throws org.apache.derby.iapi.error.StandardException

Description copied from interface: org.apache.derby.iapi.sql.ResultSet

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(). Will close the result set if it is not already closed.

Specified by:

finish in interface org.apache.derby.iapi.sql.ResultSet

---

finishAndRTS

protected final void finishAndRTS()
                           throws org.apache.derby.iapi.error.StandardException

---

getExecuteTime

public long getExecuteTime()

Get the execution time in milliseconds.

Specified by:

getExecuteTime in interface org.apache.derby.iapi.sql.ResultSet

---

getBeginExecutionTimestamp

public java.sql.Timestamp getBeginExecutionTimestamp()

Get the Timestamp for the beginning of execution.

Specified by:

getBeginExecutionTimestamp in interface org.apache.derby.iapi.sql.ResultSet

---

getEndExecutionTimestamp

public java.sql.Timestamp getEndExecutionTimestamp()

Get the Timestamp for the end of execution.

Specified by:

getEndExecutionTimestamp in interface org.apache.derby.iapi.sql.ResultSet

---

getSubqueryTrackingArray

public final org.apache.derby.iapi.sql.execute.NoPutResultSet[] getSubqueryTrackingArray(int numSubqueries)

Description copied from interface: org.apache.derby.iapi.sql.ResultSet

Get the subquery ResultSet tracking array from the top ResultSet. (Used for tracking open subqueries when closing down on an error.)

Specified by:

getSubqueryTrackingArray in interface org.apache.derby.iapi.sql.ResultSet

---

getCurrentTimeMillis

protected final long getCurrentTimeMillis()

Return the current time in milliseconds, if DEBUG and RunTimeStats is on, else return 0. (Only pay price of system call if need to.)

---

getAutoGeneratedKeysResultset

public org.apache.derby.iapi.sql.ResultSet getAutoGeneratedKeysResultset()

Description copied from interface: org.apache.derby.iapi.sql.ResultSet

ResultSet for rows inserted into the table (contains auto-generated keys columns only)

Specified by:

getAutoGeneratedKeysResultset in interface org.apache.derby.iapi.sql.ResultSet

---

getElapsedMillis

protected final long getElapsedMillis(long beginTime)

Return the elapsed time in milliseconds, between now and the beginTime, if DEBUG and RunTimeStats is on, else return 0. (Only pay price of system call if need to.)

---

dumpTimeStats

protected final java.lang.String dumpTimeStats(java.lang.String indent,
                                               java.lang.String subIndent)

Dump out the time information for run time stats.

---

attachStatementContext

protected void attachStatementContext()
                               throws org.apache.derby.iapi.error.StandardException

Attach this result set to the top statement context on the stack. Result sets can be directly read from the JDBC layer. The JDBC layer will push and pop a statement context around each ResultSet.getNext(). There's no guarantee that the statement context used for the last getNext() will be the context used for the current getNext(). The last statement context may have been popped off the stack and so will not be available for cleanup if an error occurs. To make sure that we will be cleaned up, we always attach ourselves to the top context. The fun and games occur in nested contexts: using JDBC result sets inside user code that is itself invoked from queries or CALL statements.

---

getLanguageConnectionContext

protected final org.apache.derby.iapi.sql.conn.LanguageConnectionContext getLanguageConnectionContext()

Cache the language connection context. Return it.

---

getExecutionFactory

final org.apache.derby.iapi.sql.execute.ExecutionFactory getExecutionFactory()

Get a execution factory

---

getTransactionController

final org.apache.derby.iapi.store.access.TransactionController getTransactionController()

Get the current transaction controller.

---

getCompactRow

protected org.apache.derby.iapi.sql.execute.ExecRow getCompactRow(org.apache.derby.iapi.sql.execute.ExecRow candidate,
                                                                  org.apache.derby.iapi.services.io.FormatableBitSet accessedCols,
                                                                  org.apache.derby.iapi.services.io.FormatableBitSet otherCols,
                                                                  boolean isKeyed)
                                                           throws org.apache.derby.iapi.error.StandardException

Get a compacted version of the candidate row according to the columns specified in the bit map. Share the holders between rows. If there is no bit map, use the candidate row as the compact row. Also, create an array of ints mapping base column positions to compact column positions, to make it cheaper to copy columns to the compact row, if we ever have to do it again.

---

setCompactRow

protected org.apache.derby.iapi.sql.execute.ExecRow setCompactRow(org.apache.derby.iapi.sql.execute.ExecRow candidateRow,
                                                                  org.apache.derby.iapi.sql.execute.ExecRow compactRow)

Copy columns from the candidate row from the store to the given compact row. If there is no column map, just use the candidate row. This method assumes the above method (getCompactRow()) was called first. getCompactRow() sets up the baseColumnMap.

---

setCompatRow

protected final void setCompatRow(org.apache.derby.iapi.sql.execute.ExecRow compactRow,
                                  java.lang.Object[] sourceRow)

---

addWarning

protected final void addWarning(java.sql.SQLWarning w)

---

getWarnings

public final java.sql.SQLWarning getWarnings()

Description copied from interface: org.apache.derby.iapi.sql.ResultSet

Return the set of warnings generated during the execution of this result set. The warnings are cleared once this call returns.

Specified by:

getWarnings in interface org.apache.derby.iapi.sql.ResultSet

---

Overview  Package   Class  Use  Deprecated  Index
Home >> All >> org >> apache >> derby >> impl >> sql >> [ execute overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---