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.)