Class ErrorMessages

java.lang.Object

org.apache.derby.vti.VTITemplate

org.apache.derby.diag.ErrorMessages

All Implemented Interfaces:

AutoCloseable, PrivilegedAction<InputStream>, ResultSet, Wrapper, AwareVTI, VTICosting

public final class ErrorMessages
extends VTITemplate
implements VTICosting, PrivilegedAction<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 VTITemplate

VTITemplate.ColumnDescriptor

Field Summary

Fields

Modifier and Type	Field	Description
private static final ResultColumnDescriptor[]	columnInfo
private String	k
private Enumeration	keys
private String	message
private static final ResultSetMetaData	metadata
private int	msgFile
private Properties	p
private int	severity
private String	SQLState

Fields inherited from interface 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

Fields inherited from interface VTICosting

defaultEstimatedCost, defaultEstimatedRowCount

Constructor Summary

Constructors

Constructor	Description
ErrorMessages()

Method Summary

Modifier and Type	Method	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)
ResultSetMetaData	getMetaData()
String	getString(int columnIndex)
private void	loadProperties()
boolean	next()
private boolean	notAnException()
final InputStream	run()
boolean	supportsMultipleInstantiations(VTIEnvironment vtiEnvironment)	Find out if the ResultSet of the Table Function can be instantiated multiple times.

Methods inherited from class 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, notImplemented, 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 Object

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

Methods inherited from interface ResultSet

updateObject, updateObject, updateObject, updateObject

Field Details

p

private Properties p

keys

private Enumeration keys

k

private String k

SQLState

private String SQLState

message

private String message

severity

private int severity

msgFile

private int msgFile

columnInfo

private static final ResultColumnDescriptor[] columnInfo

metadata

private static final ResultSetMetaData metadata

Constructor Details

ErrorMessages

public ErrorMessages()
              throws IOException

Throws:

IOException

Method Details

next

public boolean next()

Specified by:

next in interface ResultSet

See Also:

• ResultSet.next()

close

public void close()

Specified by:

close in interface AutoCloseable

Specified by:

close in interface ResultSet

See Also:

• ResultSet.close()

getMetaData

public ResultSetMetaData getMetaData()

Specified by:

getMetaData in interface ResultSet

Overrides:

getMetaData in class VTITemplate

See Also:

• ResultSet.getMetaData()

getString

public String getString(int columnIndex)
                 throws SQLException

Specified by:

getString in interface ResultSet

Overrides:

getString in class VTITemplate

Throws:

SQLException - column at index is not found

See Also:

• ResultSet.getString(int)

getInt

public int getInt(int columnIndex)
           throws SQLException

Specified by:

getInt in interface ResultSet

Overrides:

getInt in class VTITemplate

Throws:

SQLException - column at index is not found

See Also:

• ResultSet.getInt(int)

loadProperties

private void loadProperties()
                     throws IOException

Throws:

IOException

notAnException

private boolean notAnException()

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 InputStream run()

Specified by:

run in interface PrivilegedAction<InputStream>