Apache Derby Database Engine and Embedded JDBC Driver 10.17.1.0 · org.apache.derby.diag.StatementDuration

Field Summary

Modifier and Type	Field and Description
private static final String	BEGIN_EXECUTING_STRING
private static final String	BEGIN_THREAD_STRING
private static final String	BEGIN_XID_STRING
private BufferedReader	bufferedReader
private static final ResultColumnDescriptor[]	columnInfo
private String[]	currentRow
private static final String	END_EXECUTING_STRING
private static final String	END_THREAD_STRING
private static final String	END_TIMESTAMP
private static final String	END_XID_STRING
private int	endTimestampIndex
private boolean	gotFile
private Hashtable<String, String[]>	hashTable
private String	inputFileName
private InputStreamReader	inputFileStreamReader
private InputStream	inputStream
private int	lccidIndex
private String	line
private static final ResultSetMetaData	metadata
private int	threadIndex
private int	xidIndex

Constructor Summary

Access	Constructor and Description
public	StatementDuration() StatementDuration() accesses the error log in derby.system.home, if set, otherwise it looks in the current directory.
public	StatementDuration(String inputFileName)

Modifier and Type	Method and Description
public void	close() Implements java.sql.ResultSet.close. Releases this `ResultSet` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
public ResultSetMetaData	getMetaData() Overrides org.apache.derby.vti.VTITemplate.getMetaData. Implements java.sql.ResultSet.getMetaData. Retrieves the number, types and properties of this `ResultSet` object's columns.
public String	getString(int the first column is 1, the second is 2, ... columnNumber) Overrides org.apache.derby.vti.VTITemplate.getString. Implements java.sql.ResultSet.getString. All columns in StatementDuration VTI have String data types.
public boolean	next() Implements java.sql.ResultSet.next. Moves the cursor forward one row from its current position.
private String	setupColumn(int columnNumber)
private Timestamp	stringToTimestamp(String raw)
public boolean	wasNull() Overrides org.apache.derby.vti.VTITemplate.wasNull. Implements java.sql.ResultSet.wasNull. Reports whether the last column read had a value of SQL `NULL`.

Field Detail

BEGIN_EXECUTING_STRING	back to summary
private static final String BEGIN_EXECUTING_STRING

BEGIN_THREAD_STRING	back to summary
private static final String BEGIN_THREAD_STRING

BEGIN_XID_STRING	back to summary
private static final String BEGIN_XID_STRING

bufferedReader	back to summary
private BufferedReader bufferedReader

columnInfo	back to summary
private static final ResultColumnDescriptor[] columnInfo

currentRow	back to summary
private String[] currentRow

END_EXECUTING_STRING	back to summary
private static final String END_EXECUTING_STRING

END_THREAD_STRING	back to summary
private static final String END_THREAD_STRING

END_TIMESTAMP	back to summary
private static final String END_TIMESTAMP

END_XID_STRING	back to summary
private static final String END_XID_STRING

endTimestampIndex	back to summary
private int endTimestampIndex

gotFile	back to summary
private boolean gotFile

hashTable	back to summary
private Hashtable<String, String[]> hashTable

inputFileName	back to summary
private String inputFileName

inputFileStreamReader	back to summary
private InputStreamReader inputFileStreamReader

inputStream	back to summary
private InputStream inputStream

lccidIndex	back to summary
private int lccidIndex

line	back to summary
private String line

metadata	back to summary
private static final ResultSetMetaData metadata

threadIndex	back to summary
private int threadIndex

xidIndex	back to summary
private int xidIndex

Constructor Detail

StatementDuration	back to summary
public StatementDuration() throws StandardException StatementDuration() accesses the error log in derby.system.home, if set, otherwise it looks in the current directory. StatementDuration('filename') will access the specified file name.

StatementDuration	back to summary
public StatementDuration(String inputFileName) throws StandardException

Method Detail

close back to summary

close	back to summary
public void close() Implements java.sql.ResultSet.close. Doc from java.sql.ResultSet.close. Releases this `ResultSet` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. The closing of a `ResultSet` object does not close the `Blob`, `Clob` or `NClob` objects created by the `ResultSet`. `Blob`, `Clob` or `NClob` objects remain valid for at least the duration of the transaction in which they are created, unless their `free` method is invoked. When a `ResultSet` is closed, any `ResultSetMetaData` instances that were created by calling the `getMetaData` method remain accessible. Note A `ResultSet` object is automatically closed by the `Statement` object that generated it when that `Statement` object is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. Calling the method `close` on a `ResultSet` object that is already closed is a no-op. See Also `java.sql.ResultSet#close`

public void close()

Implements java.sql.ResultSet.close.

Doc from java.sql.ResultSet.close.

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

The closing of a ResultSet object does not close the Blob, Clob or NClob objects created by the ResultSet. Blob, Clob or NClob objects remain valid for at least the duration of the transaction in which they are created, unless their free method is invoked.

When a ResultSet is closed, any ResultSetMetaData instances that were created by calling the getMetaData method remain accessible.

Note

A ResultSet object is automatically closed by the Statement object that generated it when that Statement object is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results.

Calling the method close on a ResultSet object that is already closed is a no-op.

See Also: java.sql.ResultSet#close

getMetaData back to summary

public ResultSetMetaData getMetaData()

Overrides org.apache.derby.vti.VTITemplate.getMetaData.

Implements java.sql.ResultSet.getMetaData.

Doc from java.sql.ResultSet.getMetaData.

Retrieves the number, types and properties of this ResultSet object's columns.

Returns:ResultSetMetaData: the description of this ResultSet object's columns
See Also: java.sql.ResultSet#getMetaData

getString back to summary

getString	back to summary
public String getString(int columnNumber) throws SQLException Overrides org.apache.derby.vti.VTITemplate.getString. Implements java.sql.ResultSet.getString. All columns in StatementDuration VTI have String data types. Parameters columnNumber:int Doc from java.sql.ResultSet.getString. the first column is 1, the second is 2, ... Returns:String Doc from java.sql.ResultSet.getString. the column value; if the value is SQL `NULL`, the value returned is `null` Exceptions SQLException: If database access error occurs. See Also `java.sql.ResultSet#getString`

public String getString(int columnNumber) throws SQLException

Overrides org.apache.derby.vti.VTITemplate.getString.

Implements java.sql.ResultSet.getString.

All columns in StatementDuration VTI have String data types.

Parameters

columnNumber:int

Doc from java.sql.ResultSet.getString.

the first column is 1, the second is 2, ...

Returns:String

Doc from java.sql.ResultSet.getString.

the column value; if the value is SQL NULL, the value returned is null

Exceptions

SQLException:: If database access error occurs.

See Also

java.sql.ResultSet#getString

next back to summary

next	back to summary
public boolean next() throws SQLException Implements java.sql.ResultSet.next. Doc from java.sql.ResultSet.next. Moves the cursor forward one row from its current position. A `ResultSet` cursor is initially positioned before the first row; the first call to the method `next` makes the first row the current row; the second call makes the second row the current row, and so on. When a call to the `next` method returns `false`, the cursor is positioned after the last row. Any invocation of a `ResultSet` method which requires a current row will result in a `SQLException` being thrown. If the result set type is `TYPE_FORWARD_ONLY`, it is vendor specified whether their JDBC driver implementation will return `false` or throw an `SQLException` on a subsequent call to `next`. If an input stream is open for the current row, a call to the method `next` will implicitly close it. A `ResultSet` object's warning chain is cleared when a new row is read. Returns:boolean `true` if the new current row is valid; `false` if there are no more rows Exceptions SQLException: If database access error occurs. See Also `java.sql.ResultSet#next`

public boolean next() throws SQLException

Implements java.sql.ResultSet.next.

Doc from java.sql.ResultSet.next.

Moves the cursor forward one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.

When a call to the next method returns false, the cursor is positioned after the last row. Any invocation of a ResultSet method which requires a current row will result in a SQLException being thrown. If the result set type is TYPE_FORWARD_ONLY, it is vendor specified whether their JDBC driver implementation will return false or throw an SQLException on a subsequent call to next.

If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.

Returns:boolean

true if the new current row is valid; false if there are no more rows

Exceptions

SQLException:: If database access error occurs.

See Also

java.sql.ResultSet#next

setupColumn	back to summary
private String setupColumn(int columnNumber) throws SQLException

stringToTimestamp	back to summary
private Timestamp stringToTimestamp(String raw) throws SQLException

wasNull back to summary

wasNull	back to summary
public boolean wasNull() Overrides org.apache.derby.vti.VTITemplate.wasNull. Implements java.sql.ResultSet.wasNull. Doc from java.sql.ResultSet.wasNull. Reports whether the last column read had a value of SQL `NULL`. Note that you must first call one of the getter methods on a column to try to read its value and then call the method `wasNull` to see if the value read was SQL `NULL`. Returns:boolean `true` if the last column value read was SQL `NULL` and `false` otherwise See Also `java.sql.ResultSet#wasNull`

public boolean wasNull()

Overrides org.apache.derby.vti.VTITemplate.wasNull.

Implements java.sql.ResultSet.wasNull.

Doc from java.sql.ResultSet.wasNull.

Reports whether the last column read had a value of SQL NULL. Note that you must first call one of the getter methods on a column to try to read its value and then call the method wasNull to see if the value read was SQL NULL.

Returns:boolean: true if the last column value read was SQL NULL and false otherwise
See Also: java.sql.ResultSet#wasNull

public Class StatementDuration

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail