Top Description Fields Constructors Methods
org.apache.derby.catalog

public Class TriggerOldTransitionRows

extends UpdatableVTITemplate
Class Inheritance
Imports
org.apache.derby.iapi.db.Factory, .TriggerExecutionContext, java.sql.Connection, .Statement, .ResultSet, .ResultSetMetaData, .SQLException, .SQLWarning, java.math.BigDecimal
Provides information about a set of rows before a trigger action changed them.

This class implements only JDBC 1.2, not JDBC 2.0. You cannot compile this class with JDK1.2, since it implements only the JDBC 1.2 ResultSet interface and not the JDBC 2.0 ResultSet interface. You can only use this class in a JDK 1.2 runtime environment if no JDBC 2.0 calls are made against it.

Field Summary

Modifier and TypeField and Description
private ResultSet
resultSet

Constructor Summary

AccessConstructor and Description
public
TriggerOldTransitionRows()

Construct a VTI on the trigger's old row set.

Method Summary

Modifier and TypeMethod and Description
public void
close()

Overrides org.apache.derby.vti.UpdatableVTITemplate.close.

Implements java.sql.Statement.close.

Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

public ResultSet
executeQuery()

Overrides org.apache.derby.vti.UpdatableVTITemplate.executeQuery.

Implements java.sql.PreparedStatement.executeQuery.

Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.

public int
getResultSetConcurrency()

Overrides org.apache.derby.vti.UpdatableVTITemplate.getResultSetConcurrency.

Implements java.sql.Statement.getResultSetConcurrency.

Retrieves the result set concurrency for ResultSet objects generated by this Statement object.

private ResultSet
initializeResultSet()

Inherited from org.apache.derby.vti.UpdatableVTITemplate:
addBatchaddBatchcancelclearBatchclearParametersclearWarningscloseOnCompletionexecuteexecuteexecuteexecuteexecuteexecuteBatchexecuteQueryexecuteUpdateexecuteUpdateexecuteUpdateexecuteUpdateexecuteUpdategetConnectiongetFetchDirectiongetFetchSizegetGeneratedKeysgetMaxFieldSizegetMaxRowsgetMetaDatagetMoreResultsgetMoreResultsgetParameterMetaDatagetQueryTimeoutgetResultSetgetResultSetHoldabilitygetResultSetTypegetUpdateCountgetWarningsisClosedisCloseOnCompletionisPoolableisWrapperForsetArraysetAsciiStreamsetAsciiStreamsetAsciiStreamsetBigDecimalsetBinaryStreamsetBinaryStreamsetBinaryStreamsetBlobsetBlobsetBlobsetBooleansetBytesetBytessetCharacterStreamsetCharacterStreamsetCharacterStreamsetClobsetClobsetClobsetCursorNamesetDatesetDatesetDoublesetEscapeProcessingsetFetchDirectionsetFetchSizesetFloatsetIntsetLongsetMaxFieldSizesetMaxRowssetNCharacterStreamsetNCharacterStreamsetNClobsetNClobsetNClobsetNStringsetNullsetNullsetObjectsetObjectsetObjectsetPoolablesetQueryTimeoutsetRefsetRowIdsetShortsetSQLXMLsetStringsetTimesetTimesetTimestampsetTimestampsetUnicodeStreamsetURLunwrap

Field Detail

resultSetback to summary
private ResultSet resultSet

Constructor Detail

TriggerOldTransitionRowsback to summary
public TriggerOldTransitionRows() throws SQLException

Construct a VTI on the trigger's old row set. The old row set is the before image of the rows that are changed by the trigger. For a trigger on a delete, this is all the rows that are deleted. For a trigger on an update, this is the rows before they are updated. For an insert, this throws an exception.

Exceptions
SQLException:
thrown if no trigger active

Method Detail

closeback to summary
public void close() throws SQLException

Overrides org.apache.derby.vti.UpdatableVTITemplate.close.

Implements java.sql.Statement.close.

Doc from java.sql.Statement.close.

Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. It is generally good practice to release resources as soon as you are finished with them to avoid tying up database resources.

Calling the method close on a Statement object that is already closed has no effect.

Note

When a Statement object is closed, its current ResultSet object, if one exists, is also closed.

Exceptions
SQLException:

Doc from org.apache.derby.vti.UpdatableVTITemplate.close.

on unexpected JDBC error

executeQueryback to summary
public ResultSet executeQuery() throws SQLException

Overrides org.apache.derby.vti.UpdatableVTITemplate.executeQuery.

Implements java.sql.PreparedStatement.executeQuery.

Doc from java.sql.PreparedStatement.executeQuery.

Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.

Returns:ResultSet

a ResultSet object that contains the data produced by the query; never null

Exceptions
SQLException:

Doc from org.apache.derby.vti.UpdatableVTITemplate.executeQuery.

on unexpected JDBC error

getResultSetConcurrencyback to summary
public int getResultSetConcurrency()

Overrides org.apache.derby.vti.UpdatableVTITemplate.getResultSetConcurrency.

Implements java.sql.Statement.getResultSetConcurrency.

Doc from java.sql.Statement.getResultSetConcurrency.

Retrieves the result set concurrency for ResultSet objects generated by this Statement object.

Returns:int

either ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

initializeResultSetback to summary
private ResultSet initializeResultSet() throws SQLException