org.apache.derby.diag
Class ErrorMessages
java.lang.Object
org.apache.derby.vti.VTITemplate
org.apache.derby.diag.ErrorMessages
- All Implemented Interfaces:
- java.security.PrivilegedAction, java.sql.ResultSet, VTICosting
- public class ErrorMessages
- extends VTITemplate
- implements VTICosting, java.security.PrivilegedAction
ErrorMessage is a VTI that shows all the SQLStates, locale-sensitive error
messages, and exception severities for a database.
To use it, query it as an external virtual table:
SELECT* FROM NEW ErrorMessages() AS EQ;
The ErrorMessages VTI has the following columns:
- 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 Cloudscape code for the severity.
(The code returned by getErrorCode() in SQLException.)
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 |
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, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getInt, getLong, getLong, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getShort, getStatement, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, 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, wasNull |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
p
private java.util.Properties p
keys
private java.util.Enumeration keys
k
private java.lang.String k
SQLState
private java.lang.String SQLState
message
private java.lang.String message
severity
private int severity
msgFile
private int msgFile
columnInfo
private static final ResultColumnDescriptor[] columnInfo
metadata
private static final java.sql.ResultSetMetaData metadata
ErrorMessages
public ErrorMessages()
throws java.io.IOException
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.sql.ResultSet
- See Also:
ResultSet.close()
getMetaData
public java.sql.ResultSetMetaData getMetaData()
- Specified by:
getMetaData
in interface java.sql.ResultSet
- 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)
loadProperties
private void loadProperties()
throws java.io.IOException
- Throws:
java.io.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 VTI.
- Specified by:
getEstimatedRowCount
in interface VTICosting
- Parameters:
vtiEnvironment
- The VTIEnvironment.
- Returns:
- The estimated row count for a single scan of a VTI.
getEstimatedCostPerInstantiation
public double getEstimatedCostPerInstantiation(VTIEnvironment vtiEnvironment)
- Description copied from interface:
VTICosting
- Get the estimated cost for a single instantiation of a VTI.
- Specified by:
getEstimatedCostPerInstantiation
in interface VTICosting
- Parameters:
vtiEnvironment
- The VTIEnvironment.
- Returns:
- The estimated cost for a single instantiation of a VTI.
supportsMultipleInstantiations
public boolean supportsMultipleInstantiations(VTIEnvironment vtiEnvironment)
- Description copied from interface:
VTICosting
- Find out if the ResultSet of the VTI can be instantiated multiple times.
- Specified by:
supportsMultipleInstantiations
in interface VTICosting
- Parameters:
vtiEnvironment
- The VTIEnvironment.
- Returns:
- True if the ResultSet can be instantiated multiple times, false if
can only be instantiated once.
run
public final java.lang.Object run()
- Specified by:
run
in interface java.security.PrivilegedAction
Apache Derby V10.0 Engine Documentation - Copyright © 1997,2004 The Apache Software Foundation or its licensors, as applicable.