Module org.jooq
Package org.jooq.exception

Enum Class SQLStateClass

java.lang.Object
java.lang.Enum<SQLStateClass>
org.jooq.exception.SQLStateClass
All Implemented Interfaces:
Serializable, Comparable<SQLStateClass>, Constable
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 Details

    • C00_SUCCESSFUL_COMPLETION

      public static final SQLStateClass C00_SUCCESSFUL_COMPLETION

    • C01_WARNING

      public static final SQLStateClass C01_WARNING

    • C02_NO_DATA

      public static final SQLStateClass C02_NO_DATA

    • 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

    • OTHER

      public static final SQLStateClass OTHER

    • NONE

      public static final SQLStateClass NONE

  • Method Details

    • values

      public static SQLStateClass[] values()
      Returns an array containing the constants of this enum class, in the order they are declared.
      Returns:
      an array containing the constants of this enum class, in the order they are declared

    • valueOf

      public static SQLStateClass valueOf(String name)
      Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (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 class has no constant with the specified name
      NullPointerException - if the argument is null

    • className

      public String className()

    • fromCode

      public static SQLStateClass fromCode(String code)