jOOQ 3.18.7 · org.jooq.exception.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

Modifier and Type	Field and Description
public static final SQLStateClass	C00_SUCCESSFUL_COMPLETION
public static final SQLStateClass	C01_WARNING
public static final SQLStateClass	C02_NO_DATA
public static final SQLStateClass	C07_DYNAMIC_SQL_ERROR
public static final SQLStateClass	C08_CONNECTION_EXCEPTION
public static final SQLStateClass	C09_TRIGGERED_ACTION_EXCEPTION
public static final SQLStateClass	C0A_FEATURE_NOT_SUPPORTED
public static final SQLStateClass	C0D_INVALID_TARGET_TYPE_SPECIFICATION
public static final SQLStateClass	C0E_INVALID_SCHEMA_NAME_LIST_SPECIFICATION
public static final SQLStateClass	C0F_LOCATOR_EXCEPTION
public static final SQLStateClass	C0L_INVALID_GRANTOR
public static final SQLStateClass	C0M_INVALID_SQL_INVOKED_PROCEDURE_REFERENCE
public static final SQLStateClass	C0P_INVALID_ROLE_SPECIFICATION
public static final SQLStateClass	C0S_INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION
public static final SQLStateClass	C0T_TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION
public static final SQLStateClass	C0U_ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN
public static final SQLStateClass	C0V_ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN
public static final SQLStateClass	C0W_PROHIBITED_STATEMENT_ENCOUNTERED_DURING_TRIGGER_EXECUTION
public static final SQLStateClass	C0Z_DIAGNOSTICS_EXCEPTION
public static final SQLStateClass	C21_CARDINALITY_VIOLATION
public static final SQLStateClass	C22_DATA_EXCEPTION
public static final SQLStateClass	C23_INTEGRITY_CONSTRAINT_VIOLATION
public static final SQLStateClass	C24_INVALID_CURSOR_STATE
public static final SQLStateClass	C25_INVALID_TRANSACTION_STATE
public static final SQLStateClass	C26_INVALID_SQL_STATEMENT_NAME
public static final SQLStateClass	C27_TRIGGERED_DATA_CHANGE_VIOLATION
public static final SQLStateClass	C28_INVALID_AUTHORIZATION_SPECIFICATION
public static final SQLStateClass	C2B_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST
public static final SQLStateClass	C2C_INVALID_CHARACTER_SET_NAME
public static final SQLStateClass	C2D_INVALID_TRANSACTION_TERMINATION
public static final SQLStateClass	C2E_INVALID_CONNECTION_NAME
public static final SQLStateClass	C2F_SQL_ROUTINE_EXCEPTION
public static final SQLStateClass	C2H_INVALID_COLLATION_NAME
public static final SQLStateClass	C30_INVALID_SQL_STATEMENT_IDENTIFIER
public static final SQLStateClass	C33_INVALID_SQL_DESCRIPTOR_NAME
public static final SQLStateClass	C34_INVALID_CURSOR_NAME
public static final SQLStateClass	C35_INVALID_CONDITION_NUMBER
public static final SQLStateClass	C36_CURSOR_SENSITIVITY_EXCEPTION
public static final SQLStateClass	C38_EXTERNAL_ROUTINE_EXCEPTION
public static final SQLStateClass	C39_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION
public static final SQLStateClass	C3B_SAVEPOINT_EXCEPTION
public static final SQLStateClass	C3C_AMBIGUOUS_CURSOR_NAME
public static final SQLStateClass	C3D_INVALID_CATALOG_NAME
public static final SQLStateClass	C3F_INVALID_SCHEMA_NAME
public static final SQLStateClass	C40_TRANSACTION_ROLLBACK
public static final SQLStateClass	C42_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION
public static final SQLStateClass	CHZ_REMOTE_DATABASE_ACCESS
private final String	className
private static final Map<String, SQLStateClass>	lookup
public static final SQLStateClass	NONE
public static final SQLStateClass	OTHER

Access	Constructor and Description
private	SQLStateClass(String className)

Modifier and Type	Method and Description
public @NotNull String	className()
public static @NotNull SQLStateClass	fromCode(String code)
pack-priv static @NotNull SQLStateClass	fromSQLiteVendorCode(int errorCode)
public static SQLStateClass	valueOf(String name)
public static SQLStateClass[]	values()

Field Detail

C00_SUCCESSFUL_COMPLETION	back to summary
public static final SQLStateClass C00_SUCCESSFUL_COMPLETION

C01_WARNING	back to summary
public static final SQLStateClass C01_WARNING

C02_NO_DATA	back to summary
public static final SQLStateClass C02_NO_DATA

C07_DYNAMIC_SQL_ERROR	back to summary
public static final SQLStateClass C07_DYNAMIC_SQL_ERROR

C08_CONNECTION_EXCEPTION	back to summary
public static final SQLStateClass C08_CONNECTION_EXCEPTION

C09_TRIGGERED_ACTION_EXCEPTION	back to summary
public static final SQLStateClass C09_TRIGGERED_ACTION_EXCEPTION

C0A_FEATURE_NOT_SUPPORTED	back to summary
public static final SQLStateClass C0A_FEATURE_NOT_SUPPORTED

C0D_INVALID_TARGET_TYPE_SPECIFICATION	back to summary
public static final SQLStateClass C0D_INVALID_TARGET_TYPE_SPECIFICATION

C0E_INVALID_SCHEMA_NAME_LIST_SPECIFICATION	back to summary
public static final SQLStateClass C0E_INVALID_SCHEMA_NAME_LIST_SPECIFICATION

C0F_LOCATOR_EXCEPTION	back to summary
public static final SQLStateClass C0F_LOCATOR_EXCEPTION

C0L_INVALID_GRANTOR	back to summary
public static final SQLStateClass C0L_INVALID_GRANTOR

C0M_INVALID_SQL_INVOKED_PROCEDURE_REFERENCE	back to summary
public static final SQLStateClass C0M_INVALID_SQL_INVOKED_PROCEDURE_REFERENCE

C0P_INVALID_ROLE_SPECIFICATION	back to summary
public static final SQLStateClass C0P_INVALID_ROLE_SPECIFICATION

C0S_INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION	back to summary
public static final SQLStateClass C0S_INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION

C0T_TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION	back to summary
public static final SQLStateClass C0T_TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION

C0U_ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN	back to summary
public static final SQLStateClass C0U_ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN

C0V_ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN	back to summary
public static final SQLStateClass C0V_ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN

C0W_PROHIBITED_STATEMENT_ENCOUNTERED_DURING_TRIGGER_EXECUTION	back to summary
public static final SQLStateClass C0W_PROHIBITED_STATEMENT_ENCOUNTERED_DURING_TRIGGER_EXECUTION

C0Z_DIAGNOSTICS_EXCEPTION	back to summary
public static final SQLStateClass C0Z_DIAGNOSTICS_EXCEPTION

C21_CARDINALITY_VIOLATION	back to summary
public static final SQLStateClass C21_CARDINALITY_VIOLATION

C22_DATA_EXCEPTION	back to summary
public static final SQLStateClass C22_DATA_EXCEPTION

C23_INTEGRITY_CONSTRAINT_VIOLATION	back to summary
public static final SQLStateClass C23_INTEGRITY_CONSTRAINT_VIOLATION

C24_INVALID_CURSOR_STATE	back to summary
public static final SQLStateClass C24_INVALID_CURSOR_STATE

C25_INVALID_TRANSACTION_STATE	back to summary
public static final SQLStateClass C25_INVALID_TRANSACTION_STATE

C26_INVALID_SQL_STATEMENT_NAME	back to summary
public static final SQLStateClass C26_INVALID_SQL_STATEMENT_NAME

C27_TRIGGERED_DATA_CHANGE_VIOLATION	back to summary
public static final SQLStateClass C27_TRIGGERED_DATA_CHANGE_VIOLATION

C28_INVALID_AUTHORIZATION_SPECIFICATION	back to summary
public static final SQLStateClass C28_INVALID_AUTHORIZATION_SPECIFICATION

C2B_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST	back to summary
public static final SQLStateClass C2B_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST

C2C_INVALID_CHARACTER_SET_NAME	back to summary
public static final SQLStateClass C2C_INVALID_CHARACTER_SET_NAME

C2D_INVALID_TRANSACTION_TERMINATION	back to summary
public static final SQLStateClass C2D_INVALID_TRANSACTION_TERMINATION

C2E_INVALID_CONNECTION_NAME	back to summary
public static final SQLStateClass C2E_INVALID_CONNECTION_NAME

C2F_SQL_ROUTINE_EXCEPTION	back to summary
public static final SQLStateClass C2F_SQL_ROUTINE_EXCEPTION

C2H_INVALID_COLLATION_NAME	back to summary
public static final SQLStateClass C2H_INVALID_COLLATION_NAME

C30_INVALID_SQL_STATEMENT_IDENTIFIER	back to summary
public static final SQLStateClass C30_INVALID_SQL_STATEMENT_IDENTIFIER

C33_INVALID_SQL_DESCRIPTOR_NAME	back to summary
public static final SQLStateClass C33_INVALID_SQL_DESCRIPTOR_NAME

C34_INVALID_CURSOR_NAME	back to summary
public static final SQLStateClass C34_INVALID_CURSOR_NAME

C35_INVALID_CONDITION_NUMBER	back to summary
public static final SQLStateClass C35_INVALID_CONDITION_NUMBER

C36_CURSOR_SENSITIVITY_EXCEPTION	back to summary
public static final SQLStateClass C36_CURSOR_SENSITIVITY_EXCEPTION

C38_EXTERNAL_ROUTINE_EXCEPTION	back to summary
public static final SQLStateClass C38_EXTERNAL_ROUTINE_EXCEPTION

C39_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION	back to summary
public static final SQLStateClass C39_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION

C3B_SAVEPOINT_EXCEPTION	back to summary
public static final SQLStateClass C3B_SAVEPOINT_EXCEPTION

C3C_AMBIGUOUS_CURSOR_NAME	back to summary
public static final SQLStateClass C3C_AMBIGUOUS_CURSOR_NAME

C3D_INVALID_CATALOG_NAME	back to summary
public static final SQLStateClass C3D_INVALID_CATALOG_NAME

C3F_INVALID_SCHEMA_NAME	back to summary
public static final SQLStateClass C3F_INVALID_SCHEMA_NAME

C40_TRANSACTION_ROLLBACK	back to summary
public static final SQLStateClass C40_TRANSACTION_ROLLBACK

C42_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION	back to summary
public static final SQLStateClass C42_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION

CHZ_REMOTE_DATABASE_ACCESS	back to summary
public static final SQLStateClass CHZ_REMOTE_DATABASE_ACCESS

className	back to summary
private final String className

lookup	back to summary
private static final Map<String, SQLStateClass> lookup

NONE	back to summary
public static final SQLStateClass NONE

OTHER	back to summary
public static final SQLStateClass OTHER

public final Enum SQLStateClass

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail