org.apache.derby.diag

Class ErrorMessages

java.lang.Object

org.apache.derby.vti.VTITemplate

org.apache.derby.diag.ErrorMessages

All Implemented Interfaces:

java.lang.AutoCloseable, java.security.PrivilegedAction<java.io.InputStream>, java.sql.ResultSet, java.sql.Wrapper, AwareVTI, VTICosting

public final class ErrorMessages
extends VTITemplate
implements VTICosting, java.security.PrivilegedAction<java.io.InputStream>

ErrorMessage shows all the SQLStates, locale-sensitive error messages, and exception severities for a database.

To use it, query it as follows:

 SELECT* FROM NEW org.apache.derby.diag.ErrorMessages() AS EQ; 

The following columns will be returned:

• SQL_STATE--VARCHAR(5) - nullable. The SQLState of the SQLException.
  (The code returned by getSQLState() in SQLException.)
• MESSAGE--VARCHAR(32672) - nullable. The error message
  (The code returned by getMessage() in SQLException.)
• SEVERITY--INTEGER - nullable. The Derby code for the severity.
  (The code returned by getErrorCode() in SQLException.)

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.derby.vti.VTITemplate

VTITemplate.ColumnDescriptor

Field Summary

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

Constructors

Constructor and Description
ErrorMessages()

Method Summary

Modifier and Type	Method and Description
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.
int	getInt(int columnIndex)
java.sql.ResultSetMetaData	getMetaData()
java.lang.String	getString(int columnIndex)
boolean	next()
java.io.InputStream	run()
boolean	supportsMultipleInstantiations(VTIEnvironment vtiEnvironment) Find out if the ResultSet of the Table Function can be instantiated multiple times.

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

absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getContext, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getReturnTableSignature, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, isWrapperFor, last, moveToCurrentRow, moveToInsertRow, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setContext, setFetchDirection, setFetchSize, unwrap, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.ResultSet

updateObject, updateObject, updateObject, updateObject

Constructor Detail

ErrorMessages

public ErrorMessages()
              throws java.io.IOException

Throws:

java.io.IOException

Method Detail

next

public boolean next()

Specified by:

next in interface java.sql.ResultSet

See Also:

ResultSet.next()

close

public void close()

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface java.sql.ResultSet

See Also:

ResultSet.close()

getMetaData

public java.sql.ResultSetMetaData getMetaData()

Specified by:

getMetaData in interface java.sql.ResultSet

Overrides:

getMetaData in class VTITemplate

See Also:

ResultSet.getMetaData()

getString

public java.lang.String getString(int columnIndex)
                           throws java.sql.SQLException

Specified by:

getString in interface java.sql.ResultSet

Overrides:

getString in class VTITemplate

Throws:

java.sql.SQLException - column at index is not found

See Also:

ResultSet.getString(int)

getInt

public int getInt(int columnIndex)
           throws java.sql.SQLException

Specified by:

getInt in interface java.sql.ResultSet

Overrides:

getInt in class VTITemplate

Throws:

java.sql.SQLException - column at index is not found

See Also:

ResultSet.getInt(int)

getEstimatedRowCount

public double getEstimatedRowCount(VTIEnvironment vtiEnvironment)

Description copied from interface: VTICosting

Get the estimated row count for a single scan of a Table Function.

Specified by:

getEstimatedRowCount in interface VTICosting

Parameters:

vtiEnvironment - The state variable for optimizing the Table Function.

Returns:

The estimated row count for a single scan of the Table Function.

getEstimatedCostPerInstantiation

public double getEstimatedCostPerInstantiation(VTIEnvironment vtiEnvironment)

Description copied from interface: VTICosting

Get the estimated cost for a single instantiation of a Table Function.

Specified by:

getEstimatedCostPerInstantiation in interface VTICosting

Parameters:

vtiEnvironment - The state variable for optimizing the Table Function.

Returns:

The estimated cost for a single instantiation of the Table Function.

supportsMultipleInstantiations

public boolean supportsMultipleInstantiations(VTIEnvironment vtiEnvironment)

Description copied from interface: VTICosting

Find out if the ResultSet of the Table Function can be instantiated multiple times.

Specified by:

supportsMultipleInstantiations in interface VTICosting

Parameters:

vtiEnvironment - The state variable for optimizing the Table Function.

Returns:

True if the ResultSet can be instantiated multiple times, false if can only be instantiated once.

run

public final java.io.InputStream run()

Specified by:

run in interface java.security.PrivilegedAction<java.io.InputStream>