org.jooq.exception

Enum SQLStateClass

java.lang.Object

java.lang.Enum<SQLStateClass>

org.jooq.exception.SQLStateClass

All Implemented Interfaces:

java.io.Serializable, java.lang.Comparable<SQLStateClass>

public enum SQLStateClass
extends java.lang.Enum<SQLStateClass>

The class of the SQL state as specified by the SQL:2011 standard, or by individual vendors.

Class	Description
00	Successful completion
01	Warning
02	No data
07	Dynamic SQL Error
08	Connection exception
09	Triggered action exception
0A	Feature not supported
0D	Invalid target type specification
0E	Invalid schema name list specification
0F	Locator exception
0L	Invalid grantor
0M	Invalid SQL-invoked procedure reference
0P	Invalid role specification
0S	Invalid transform group name specification
0T	Target table disagrees with cursor specification
0U	Attempt to assign to non-updatable column
0V	Attempt to assign to ordering column
0W	Prohibited statement encountered during trigger execution
0Z	Diagnostics exception
21	Cardinality violation
22	Data exception
23	Integrity constraint violation
24	Invalid cursor state
25	Invalid transaction state
26	Invalid SQL statement name
27	Triggered data change violation
28	Invalid authorization specification
2B	Dependent privilege descriptors still exist
2C	Invalid character set name
2D	Invalid transaction termination
2E	Invalid connection name
2F	SQL routine exception
2H	Invalid collation name
30	Invalid SQL statement identifier
33	Invalid SQL descriptor name
34	Invalid cursor name
35	Invalid condition number
36	Cursor sensitivity exception
38	External routine exception
39	External routine invocation exception
3B	Savepoint exception
3C	Ambiguous cursor name
3D	Invalid catalog name
3F	Invalid schema name
40	Transaction rollback
42	Syntax error or access rule violation
44	With check option violation
HZ	Remote database access

Author:

Lukas Eder

Enum Constant Summary

Enum Constants

Enum Constant and Description
C00_SUCCESSFUL_COMPLETION
C01_WARNING
C02_NO_DATA
C07_DYNAMIC_SQL_ERROR
C08_CONNECTION_EXCEPTION
C09_TRIGGERED_ACTION_EXCEPTION
C0A_FEATURE_NOT_SUPPORTED
C0D_INVALID_TARGET_TYPE_SPECIFICATION
C0E_INVALID_SCHEMA_NAME_LIST_SPECIFICATION
C0F_LOCATOR_EXCEPTION
C0L_INVALID_GRANTOR
C0M_INVALID_SQL_INVOKED_PROCEDURE_REFERENCE
C0P_INVALID_ROLE_SPECIFICATION
C0S_INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION
C0T_TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION
C0U_ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN
C0V_ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN
C0W_PROHIBITED_STATEMENT_ENCOUNTERED_DURING_TRIGGER_EXECUTION
C0Z_DIAGNOSTICS_EXCEPTION
C21_CARDINALITY_VIOLATION
C22_DATA_EXCEPTION
C23_INTEGRITY_CONSTRAINT_VIOLATION
C24_INVALID_CURSOR_STATE
C25_INVALID_TRANSACTION_STATE
C26_INVALID_SQL_STATEMENT_NAME
C27_TRIGGERED_DATA_CHANGE_VIOLATION
C28_INVALID_AUTHORIZATION_SPECIFICATION
C2B_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST
C2C_INVALID_CHARACTER_SET_NAME
C2D_INVALID_TRANSACTION_TERMINATION
C2E_INVALID_CONNECTION_NAME
C2F_SQL_ROUTINE_EXCEPTION
C2H_INVALID_COLLATION_NAME
C30_INVALID_SQL_STATEMENT_IDENTIFIER
C33_INVALID_SQL_DESCRIPTOR_NAME
C34_INVALID_CURSOR_NAME
C35_INVALID_CONDITION_NUMBER
C36_CURSOR_SENSITIVITY_EXCEPTION
C38_EXTERNAL_ROUTINE_EXCEPTION
C39_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION
C3B_SAVEPOINT_EXCEPTION
C3C_AMBIGUOUS_CURSOR_NAME
C3D_INVALID_CATALOG_NAME
C3F_INVALID_SCHEMA_NAME
C40_TRANSACTION_ROLLBACK
C42_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION
CHZ_REMOTE_DATABASE_ACCESS
NONE
OTHER

Method Summary

Modifier and Type	Method and Description
java.lang.String	className()
static SQLStateClass	fromCode(java.lang.String code)
static SQLStateClass	valueOf(java.lang.String name) Returns the enum constant of this type with the specified name.
static SQLStateClass[]	values() Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

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 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(java.lang.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:

java.lang.IllegalArgumentException - if this enum type has no constant with the specified name

java.lang.NullPointerException - if the argument is null

className

public java.lang.String className()

fromCode

public static SQLStateClass fromCode(java.lang.String code)