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

public final Class TriggerNewTransitionRows

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 about a a set of new rows created by a trigger action.

You can only use this class if no JDBC 2.0 or later calls are made against it.

Field Summary

Modifier and TypeField and Description
private ResultSet
resultSet

Constructor Summary

AccessConstructor and Description
public
TriggerNewTransitionRows()

Construct a VTI on the trigger's new 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 ResultSetMetaData
getMetaData()

Overrides org.apache.derby.vti.UpdatableVTITemplate.getMetaData.

Implements java.sql.PreparedStatement.getMetaData.

Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.

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:
addBatchaddBatchcancelclearBatchclearParametersclearWarningscloseOnCompletionexecuteexecuteexecuteexecuteexecuteexecuteBatchexecuteQueryexecuteUpdateexecuteUpdateexecuteUpdateexecuteUpdateexecuteUpdategetConnectiongetFetchDirectiongetFetchSizegetGeneratedKeysgetMaxFieldSizegetMaxRowsgetMoreResultsgetMoreResultsgetParameterMetaDatagetQueryTimeoutgetResultSetgetResultSetHoldabilitygetResultSetTypegetUpdateCountgetWarningsisClosedisCloseOnCompletionisPoolableisWrapperForsetArraysetAsciiStreamsetAsciiStreamsetAsciiStreamsetBigDecimalsetBinaryStreamsetBinaryStreamsetBinaryStreamsetBlobsetBlobsetBlobsetBooleansetBytesetBytessetCharacterStreamsetCharacterStreamsetCharacterStreamsetClobsetClobsetClobsetCursorNamesetDatesetDatesetDoublesetEscapeProcessingsetFetchDirectionsetFetchSizesetFloatsetIntsetLongsetMaxFieldSizesetMaxRowssetNCharacterStreamsetNCharacterStreamsetNClobsetNClobsetNClobsetNStringsetNullsetNullsetObjectsetObjectsetObjectsetPoolablesetQueryTimeoutsetRefsetRowIdsetShortsetSQLXMLsetStringsetTimesetTimesetTimestampsetTimestampsetUnicodeStreamsetURLunwrap

Field Detail

resultSetback to summary
private ResultSet resultSet

Constructor Detail

TriggerNewTransitionRowsback to summary
public TriggerNewTransitionRows() throws SQLException

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

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

getMetaDataback to summary
public ResultSetMetaData getMetaData() throws SQLException

Overrides org.apache.derby.vti.UpdatableVTITemplate.getMetaData.

Implements java.sql.PreparedStatement.getMetaData.

Doc from java.sql.PreparedStatement.getMetaData.

Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.

Because a PreparedStatement object is precompiled, it is possible to know about the ResultSet object that it will return without having to execute it. Consequently, it is possible to invoke the method getMetaData on a PreparedStatement object rather than waiting to execute it and then invoking the ResultSet.getMetaData method on the ResultSet object that is returned.

Note

Using this method may be expensive for some drivers due to the lack of underlying DBMS support.

Returns:ResultSetMetaData

the description of a ResultSet object's columns or null if the driver cannot return a ResultSetMetaData object

Exceptions
SQLException:

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

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