|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.derby.vti.VTITemplate
org.apache.derby.diag.TransactionTable
public class TransactionTable
TransactionTable is a virtual table that shows all transactions currently in the database. This virtual table can be invoked by calling it directly
select * from SYSCS_DIAG.TRANSACTION_TABLE
The TransactionTable virtual table takes a snap shot of the transaction table while the system is in flux, so it is possible that some transactions may be in transition state while the snap shot is taken. We choose to do this rather then impose extraneous timing restrictions so that the use of this tool will not alter the normal timing and flow of execution in the application.
The TransactionTable virtual table has the following columns:
Field Summary | |
---|---|
private static ResultColumnDescriptor[] |
columnInfo
|
(package private) int |
currentRow
|
(package private) boolean |
initialized
|
private static java.sql.ResultSetMetaData |
metadata
|
private TransactionInfo[] |
transactionTable
|
private boolean |
wasNull
|
Fields inherited from interface org.apache.derby.vti.VTICosting |
---|
defaultEstimatedCost, defaultEstimatedRowCount |
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Constructor Summary | |
---|---|
TransactionTable()
|
Method Summary | |
---|---|
void |
close()
|
double |
getEstimatedCostPerInstantiation(VTIEnvironment vtiEnvironment)
Get the estimated cost for a single instantiation of a Table Function. |
double |
getEstimatedRowCount(VTIEnvironment vtiEnvironment)
Get the estimated row count for a single scan of a Table Function. |
java.sql.ResultSetMetaData |
getMetaData()
|
java.lang.String |
getString(int columnNumber)
All columns in TransactionTable VTI is of String type. |
boolean |
next()
|
boolean |
supportsMultipleInstantiations(VTIEnvironment vtiEnvironment)
Find out if the ResultSet of the Table Function can be instantiated multiple times. |
boolean |
wasNull()
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface java.sql.ResultSet |
---|
getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, isClosed, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXML |
Methods inherited from interface java.sql.Wrapper |
---|
isWrapperFor, unwrap |
Field Detail |
---|
private TransactionInfo[] transactionTable
boolean initialized
int currentRow
private boolean wasNull
private static final ResultColumnDescriptor[] columnInfo
private static final java.sql.ResultSetMetaData metadata
Constructor Detail |
---|
public TransactionTable()
Method Detail |
---|
public java.sql.ResultSetMetaData getMetaData()
getMetaData
in interface java.sql.ResultSet
ResultSet.getMetaData()
public boolean next() throws java.sql.SQLException
next
in interface java.sql.ResultSet
java.sql.SQLException
- if no transaction context can be foundResultSet.next()
public void close()
close
in interface java.sql.ResultSet
ResultSet.close()
public java.lang.String getString(int columnNumber)
getString
in interface java.sql.ResultSet
getString
in class VTITemplate
ResultSet.getString(int)
public boolean wasNull()
wasNull
in interface java.sql.ResultSet
wasNull
in class VTITemplate
ResultSet.wasNull()
public double getEstimatedRowCount(VTIEnvironment vtiEnvironment)
VTICosting
getEstimatedRowCount
in interface VTICosting
vtiEnvironment
- The state variable for optimizing the Table Function.
VTICosting.getEstimatedRowCount(org.apache.derby.vti.VTIEnvironment)
public double getEstimatedCostPerInstantiation(VTIEnvironment vtiEnvironment)
VTICosting
getEstimatedCostPerInstantiation
in interface VTICosting
vtiEnvironment
- The state variable for optimizing the Table Function.
VTICosting.getEstimatedCostPerInstantiation(org.apache.derby.vti.VTIEnvironment)
public boolean supportsMultipleInstantiations(VTIEnvironment vtiEnvironment)
VTICosting
supportsMultipleInstantiations
in interface VTICosting
vtiEnvironment
- The state variable for optimizing the Table Function.
VTICosting.supportsMultipleInstantiations(org.apache.derby.vti.VTIEnvironment)
|
Built on Thu 2012-03-29 21:53:33+0000, from revision ??? | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |