org.apache.derby.diag

Class StatementCache

java.lang.Object

org.apache.derby.vti.VTITemplateBase

org.apache.derby.vti.VTITemplate

org.apache.derby.diag.StatementCache

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper

public final class StatementCache
extends VTITemplate

StatementCache is a virtual table that shows the contents of the SQL statement cache. This virtual table can be invoked by calling it directly.

 select * from new org.apache.derby.diag.StatementCache() t

The StatementCache virtual table has the following columns:

• ID CHAR(36) - not nullable. Internal identifier of the compiled statement.
• SCHEMANAME VARCHAR(128) - nullable. Schema the statement was compiled in.
• SQL_TEXT VARCHAR(32672) - not nullable. Text of the statement
• UNICODE BIT/BOOLEAN - not nullable. Always true.
• VALID BIT/BOOLEAN - not nullable. True if the statement is currently valid, false otherwise
• COMPILED_AT TIMESTAMP nullable - time statement was compiled, requires STATISTICS TIMING to be enabled.

The internal identifier of a cached statement matches the toString() method of a PreparedStatement object for a Derby database.

This class also provides a static method to empty the statement cache, StatementCache.emptyCache()

Field Summary

Fields

Modifier and Type	Field and Description
private static ResultColumnDescriptor[]	columnInfo
private GenericPreparedStatement	currentPs
private java.util.Vector	data
private static java.sql.ResultSetMetaData	metadata
private int	position
private boolean	wasNull

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

Constructors

Constructor and Description
StatementCache()

Method Summary

Modifier and Type	Method and Description
void	close()
boolean	getBoolean(int colId)
java.sql.ResultSetMetaData	getMetaData()
java.lang.String	getString(int colId)
java.sql.Timestamp	getTimestamp(int colId)
boolean	next()
boolean	wasNull()

Methods inherited from class org.apache.derby.vti.VTITemplate

getBigDecimal, getBigDecimal, getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getObject, getShort, getString, getTime, getTimestamp

Methods inherited from class org.apache.derby.vti.VTITemplateBase

absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getByte, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDouble, getFetchDirection, getFetchSize, getFloat, getInt, getLong, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getStatement, getTime, getTime, getTime, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, notImplemented, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp

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, getObject, getObject, 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, updateObject, updateObject, updateObject, updateObject, updateRowId, updateRowId, updateSQLXML, updateSQLXML

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Field Detail

position

private int position

data

private java.util.Vector data

currentPs

private GenericPreparedStatement currentPs

wasNull

private boolean wasNull

columnInfo

private static final ResultColumnDescriptor[] columnInfo

metadata

private static final java.sql.ResultSetMetaData metadata

Constructor Detail

StatementCache

public StatementCache()
               throws StandardException

Throws:

StandardException

Method Detail

next

public boolean next()

Specified by:

next in interface java.sql.ResultSet

Specified by:

next in class VTITemplate

close

public void close()

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface java.sql.ResultSet

Specified by:

close in class VTITemplate

getString

public java.lang.String getString(int colId)

Specified by:

getString in interface java.sql.ResultSet

Overrides:

getString in class VTITemplateBase

getBoolean

public boolean getBoolean(int colId)

Specified by:

getBoolean in interface java.sql.ResultSet

Overrides:

getBoolean in class VTITemplateBase

getTimestamp

public java.sql.Timestamp getTimestamp(int colId)

Specified by:

getTimestamp in interface java.sql.ResultSet

Overrides:

getTimestamp in class VTITemplateBase

wasNull

public boolean wasNull()

Specified by:

wasNull in interface java.sql.ResultSet

Overrides:

wasNull in class VTITemplateBase

getMetaData

public java.sql.ResultSetMetaData getMetaData()

Specified by:

getMetaData in interface java.sql.ResultSet

Overrides:

getMetaData in class VTITemplateBase