Module org.jooq
Package org.jooq.exception

Enum SQLStateClass

  • All Implemented Interfaces:
    Serializable, Comparable<SQLStateClass>
    public enum SQLStateClass
extends Enum<SQLStateClass>
    The class of the SQL state as specified by the SQL:2011 standard, or by individual vendors.

    ClassDescription
    00Successful completion
    01Warning
    02No data
    07Dynamic SQL Error
    08Connection exception
    09Triggered action exception
    0AFeature not supported
    0DInvalid target type specification
    0EInvalid schema name list specification
    0FLocator exception
    0LInvalid grantor
    0MInvalid SQL-invoked procedure reference
    0PInvalid role specification
    0SInvalid transform group name specification
    0TTarget table disagrees with cursor specification
    0UAttempt to assign to non-updatable column
    0VAttempt to assign to ordering column
    0WProhibited statement encountered during trigger execution
    0ZDiagnostics exception
    21Cardinality violation
    22Data exception
    23Integrity constraint violation
    24Invalid cursor state
    25Invalid transaction state
    26Invalid SQL statement name
    27Triggered data change violation
    28Invalid authorization specification
    2BDependent privilege descriptors still exist
    2CInvalid character set name
    2DInvalid transaction termination
    2EInvalid connection name
    2FSQL routine exception
    2HInvalid collation name
    30Invalid SQL statement identifier
    33Invalid SQL descriptor name
    34Invalid cursor name
    35Invalid condition number
    36Cursor sensitivity exception
    38External routine exception
    39External routine invocation exception
    3BSavepoint exception
    3CAmbiguous cursor name
    3DInvalid catalog name
    3FInvalid schema name
    40Transaction rollback
    42Syntax error or access rule violation
    44With check option violation
    HZRemote database access
    Author:
    Lukas Eder

    • Enum Constant Detail

      • C00_SUCCESSFUL_COMPLETION

        public static final SQLStateClass C00_SUCCESSFUL_COMPLETION

      • C07_DYNAMIC_SQL_ERROR

        public static final SQLStateClass C07_DYNAMIC_SQL_ERROR

      • C08_CONNECTION_EXCEPTION

        public static final SQLStateClass C08_CONNECTION_EXCEPTION

      • C09_TRIGGERED_ACTION_EXCEPTION

        public static final SQLStateClass C09_TRIGGERED_ACTION_EXCEPTION

      • C0A_FEATURE_NOT_SUPPORTED

        public static final SQLStateClass C0A_FEATURE_NOT_SUPPORTED

      • C0D_INVALID_TARGET_TYPE_SPECIFICATION

        public static final SQLStateClass C0D_INVALID_TARGET_TYPE_SPECIFICATION

      • C0E_INVALID_SCHEMA_NAME_LIST_SPECIFICATION

        public static final SQLStateClass C0E_INVALID_SCHEMA_NAME_LIST_SPECIFICATION

      • C0F_LOCATOR_EXCEPTION

        public static final SQLStateClass C0F_LOCATOR_EXCEPTION

      • C0L_INVALID_GRANTOR

        public static final SQLStateClass C0L_INVALID_GRANTOR

      • C0M_INVALID_SQL_INVOKED_PROCEDURE_REFERENCE

        public static final SQLStateClass C0M_INVALID_SQL_INVOKED_PROCEDURE_REFERENCE

      • C0P_INVALID_ROLE_SPECIFICATION

        public static final SQLStateClass C0P_INVALID_ROLE_SPECIFICATION

      • C0S_INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION

        public static final SQLStateClass C0S_INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION

      • C0T_TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION

        public static final SQLStateClass C0T_TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION

      • C0U_ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN

        public static final SQLStateClass C0U_ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN

      • C0V_ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN

        public static final SQLStateClass C0V_ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN

      • C0W_PROHIBITED_STATEMENT_ENCOUNTERED_DURING_TRIGGER_EXECUTION

        public static final SQLStateClass C0W_PROHIBITED_STATEMENT_ENCOUNTERED_DURING_TRIGGER_EXECUTION

      • C0Z_DIAGNOSTICS_EXCEPTION

        public static final SQLStateClass C0Z_DIAGNOSTICS_EXCEPTION

      • C21_CARDINALITY_VIOLATION

        public static final SQLStateClass C21_CARDINALITY_VIOLATION

      • C22_DATA_EXCEPTION

        public static final SQLStateClass C22_DATA_EXCEPTION

      • C23_INTEGRITY_CONSTRAINT_VIOLATION

        public static final SQLStateClass C23_INTEGRITY_CONSTRAINT_VIOLATION

      • C24_INVALID_CURSOR_STATE

        public static final SQLStateClass C24_INVALID_CURSOR_STATE

      • C25_INVALID_TRANSACTION_STATE

        public static final SQLStateClass C25_INVALID_TRANSACTION_STATE

      • C26_INVALID_SQL_STATEMENT_NAME

        public static final SQLStateClass C26_INVALID_SQL_STATEMENT_NAME

      • C27_TRIGGERED_DATA_CHANGE_VIOLATION

        public static final SQLStateClass C27_TRIGGERED_DATA_CHANGE_VIOLATION

      • C28_INVALID_AUTHORIZATION_SPECIFICATION

        public static final SQLStateClass C28_INVALID_AUTHORIZATION_SPECIFICATION

      • C2B_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST

        public static final SQLStateClass C2B_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST

      • C2C_INVALID_CHARACTER_SET_NAME

        public static final SQLStateClass C2C_INVALID_CHARACTER_SET_NAME

      • C2D_INVALID_TRANSACTION_TERMINATION

        public static final SQLStateClass C2D_INVALID_TRANSACTION_TERMINATION

      • C2E_INVALID_CONNECTION_NAME

        public static final SQLStateClass C2E_INVALID_CONNECTION_NAME

      • C2F_SQL_ROUTINE_EXCEPTION

        public static final SQLStateClass C2F_SQL_ROUTINE_EXCEPTION

      • C2H_INVALID_COLLATION_NAME

        public static final SQLStateClass C2H_INVALID_COLLATION_NAME

      • C30_INVALID_SQL_STATEMENT_IDENTIFIER

        public static final SQLStateClass C30_INVALID_SQL_STATEMENT_IDENTIFIER

      • C33_INVALID_SQL_DESCRIPTOR_NAME

        public static final SQLStateClass C33_INVALID_SQL_DESCRIPTOR_NAME

      • C34_INVALID_CURSOR_NAME

        public static final SQLStateClass C34_INVALID_CURSOR_NAME

      • C35_INVALID_CONDITION_NUMBER

        public static final SQLStateClass C35_INVALID_CONDITION_NUMBER

      • C36_CURSOR_SENSITIVITY_EXCEPTION

        public static final SQLStateClass C36_CURSOR_SENSITIVITY_EXCEPTION

      • C38_EXTERNAL_ROUTINE_EXCEPTION

        public static final SQLStateClass C38_EXTERNAL_ROUTINE_EXCEPTION

      • C39_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION

        public static final SQLStateClass C39_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION

      • C3B_SAVEPOINT_EXCEPTION

        public static final SQLStateClass C3B_SAVEPOINT_EXCEPTION

      • C3C_AMBIGUOUS_CURSOR_NAME

        public static final SQLStateClass C3C_AMBIGUOUS_CURSOR_NAME

      • C3D_INVALID_CATALOG_NAME

        public static final SQLStateClass C3D_INVALID_CATALOG_NAME

      • C3F_INVALID_SCHEMA_NAME

        public static final SQLStateClass C3F_INVALID_SCHEMA_NAME

      • C40_TRANSACTION_ROLLBACK

        public static final SQLStateClass C40_TRANSACTION_ROLLBACK

      • C42_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION

        public static final SQLStateClass C42_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION

      • CHZ_REMOTE_DATABASE_ACCESS

        public static final SQLStateClass CHZ_REMOTE_DATABASE_ACCESS

    • Method Detail

      • values

        public static SQLStateClass[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows: 
        for (SQLStateClass c : SQLStateClass.values())
    System.out.println(c);
        Returns:
        an array containing the constants of this enum type, in the order they are declared

      • valueOf

        public static SQLStateClass valueOf​(String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        IllegalArgumentException - if this enum type has no constant with the specified name
        NullPointerException - if the argument is null

      • className

        public String className()