org.jooq.exception

Enum SQLStateSubclass

java.lang.Object

java.lang.Enum<SQLStateSubclass>

org.jooq.exception.SQLStateSubclass

All Implemented Interfaces:

Serializable, Comparable<SQLStateSubclass>

public enum SQLStateSubclass
extends Enum<SQLStateSubclass>

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

Class	Description	Subclass	Description
00	Successful completion	000	No subclass
01	Warning	000	No subclass
01	Warning	001	Cursor operation conflict
01	Warning	002	Disconnect error
01	Warning	003	Null value eliminated in set function
01	Warning	004	String data, right truncation
01	Warning	005	Insufficient item descriptor areas
01	Warning	006	Privilege not revoked
01	Warning	007	Privilege not granted
01	Warning	009	Search condition too long for information schema
01	Warning	00A	Query expression too long for information schema
01	Warning	00B	Default value too long for information schema
01	Warning	00C	Result sets returned
01	Warning	00D	Additional result sets returned
01	Warning	00E	Attempt to return too many result sets
01	Warning	00F	Statement too long for information schema
01	Warning	012	Invalid number of conditions
01	Warning	02F	Array data, right truncation
02	No data	000	No subclass
02	No data	001	No additional result sets returned
07	Dynamic SQL Error	000	No subclass
07	Dynamic SQL Error	001	Using clause does not match dynamic parameter specifications
07	Dynamic SQL Error	002	Using clause does not match target specifications
07	Dynamic SQL Error	003	Cursor specification cannot be executed
07	Dynamic SQL Error	004	Using clause required for dynamic parameters
07	Dynamic SQL Error	005	Prepared statement not a cursor specification
07	Dynamic SQL Error	006	Restricted data type attribute violation
07	Dynamic SQL Error	007	Using clause required for result fields
07	Dynamic SQL Error	008	Invalid descriptor count
07	Dynamic SQL Error	009	Invalid descriptor index
07	Dynamic SQL Error	00B	Data type transform function violation
07	Dynamic SQL Error	00C	Undefined DATA value
07	Dynamic SQL Error	00D	Invalid DATA target
07	Dynamic SQL Error	00E	Invalid LEVEL value
07	Dynamic SQL Error	00F	Invalid DATETIME_INTERVAL_CODE
08	Connection exception	000	No subclass
08	Connection exception	001	SQL-client unable to establish SQL-connection
08	Connection exception	002	Connection name in use
08	Connection exception	003	Connection does not exist
08	Connection exception	004	SQL-server rejected establishment of SQL-connection
08	Connection exception	006	Connection failure
08	Connection exception	007	Transaction resolution unknown
09	Triggered action exception	000	No subclass
0A	Feature not supported	000	No subclass
0A	Feature not supported	001	Multiple server transactions
0D	Invalid target type specification	000	No subclass
0E	Invalid schema name list specification	000	No subclass
0F	Locator exception	000	No subclass
0F	Locator exception	001	Invalid specification
0L	Invalid grantor	000	No subclass
0M	Invalid SQL-invoked procedure reference	000	No subclass
0P	Invalid role specification	000	No subclass
0S	Invalid transform group name specification	000	No subclass
0T	Target table disagrees with cursor specification	000	No subclass
0U	Attempt to assign to non-updatable column	000	No subclass
0V	Attempt to assign to ordering column	000	No subclass
0W	Prohibited statement encountered during trigger execution	000	No subclass
0W	Prohibited statement encountered during trigger execution	001	Modify table modified by data change delta table
0Z	Diagnostics exception	000	No subclass
0Z	Diagnostics exception	001	Maximum number of stacked diagnostics areas exceeded
21	Cardinality violation	000	No subclass
22	Data exception	000	No subclass
22	Data exception	001	String data, right truncation
22	Data exception	002	Null value, no indicator parameter
22	Data exception	003	Numeric value out of range
22	Data exception	004	Null value not allowed
22	Data exception	005	Error in assignment
22	Data exception	006	Invalid interval format
22	Data exception	007	Invalid datetime format
22	Data exception	008	Datetime field overflow
22	Data exception	009	Invalid time zone displacement value
22	Data exception	00B	Escape character conflict
22	Data exception	00C	Invalid use of escape character
22	Data exception	00D	Invalid escape octet
22	Data exception	00E	Null value in array target
22	Data exception	00F	Zero-length character string
22	Data exception	00G	Most specific type mismatch
22	Data exception	00H	Sequence generator limit exceeded
22	Data exception	00P	Interval value out of range
22	Data exception	00Q	Multiset value overflow
22	Data exception	010	Invalid indicator parameter value
22	Data exception	011	Substring error
22	Data exception	012	Division by zero
22	Data exception	013	Invalid preceding or following size in window function
22	Data exception	014	Invalid argument for NTILE function
22	Data exception	015	Interval field overflow
22	Data exception	016	Invalid argument for NTH_VALUE function
22	Data exception	018	Invalid character value for cast
22	Data exception	019	Invalid escape character
22	Data exception	01B	Invalid regular expression
22	Data exception	01C	Null row not permitted in table
22	Data exception	01E	Invalid argument for natural logarithm
22	Data exception	01F	Invalid argument for power function
22	Data exception	01G	Invalid argument for width bucket function
22	Data exception	01H	Invalid row version
22	Data exception	01S	Invalid XQuery regular expression
22	Data exception	01T	Invalid XQuery option flag
22	Data exception	01U	Attempt to replace a zero-length string
22	Data exception	01V	Invalid XQuery replacement string
22	Data exception	01W	Invalid row count in fetch first clause
22	Data exception	01X	Invalid row count in result offset clause
22	Data exception	020	Invalid period value
22	Data exception	021	Character not in repertoire
22	Data exception	022	Indicator overflow
22	Data exception	023	Invalid parameter value
22	Data exception	024	Unterminated C string
22	Data exception	025	Invalid escape sequence
22	Data exception	026	String data, length mismatch
22	Data exception	027	Trim error
22	Data exception	029	Noncharacter in UCS string
22	Data exception	02D	Null value substituted for mutator subject parameter
22	Data exception	02E	Array element error
22	Data exception	02F	Array data, right truncation
22	Data exception	02G	Invalid repeat argument in sample clause
22	Data exception	02H	Invalid sample size
23	Integrity constraint violation	000	No subclass
23	Integrity constraint violation	001	Restrict violation
24	Invalid cursor state	000	No subclass
25	Invalid transaction state	000	No subclass
25	Invalid transaction state	001	Active SQL-transaction
25	Invalid transaction state	002	Branch transaction already active
25	Invalid transaction state	003	Inappropriate access mode for branch transaction
25	Invalid transaction state	004	Inappropriate isolation level for branch transaction
25	Invalid transaction state	005	No active SQL-transaction for branch transaction
25	Invalid transaction state	006	Read-only SQL-transaction
25	Invalid transaction state	007	Schema and data statement mixing not supported
25	Invalid transaction state	008	Held cursor requires same isolation level
26	Invalid SQL statement name	000	No subclass
27	Triggered data change violation	000	No subclass
27	Triggered data change violation	001	Modify table modified by data change delta table
28	Invalid authorization specification	000	No subclass
2B	Dependent privilege descriptors still exist	000	No subclass
2C	Invalid character set name	000	No subclass
2C	Invalid character set name	001	Cannot drop SQL-session default character set
2D	Invalid transaction termination	000	No subclass
2E	Invalid connection name	000	No subclass
2F	SQL routine exception	000	No subclass
2F	SQL routine exception	002	Modifying SQL-data not permitted
2F	SQL routine exception	003	Prohibited SQL-statement attempted
2F	SQL routine exception	004	Reading SQL-data not permitted
2F	SQL routine exception	005	Function executed no return statement
2H	Invalid collation name	000	No subclass
30	Invalid SQL statement identifier	000	No subclass
33	Invalid SQL descriptor name	000	No subclass
34	Invalid cursor name	000	No subclass
35	Invalid condition number	000	No subclass
36	Cursor sensitivity exception	000	No subclass
36	Cursor sensitivity exception	001	request rejected
36	Cursor sensitivity exception	002	request failed
38	External routine exception	000	No subclass
38	External routine exception	001	Containing SQL not permitted
38	External routine exception	002	Modifying SQL-data not permitted
38	External routine exception	003	Prohibited SQL-statement attempted
38	External routine exception	004	Reading SQL-data not permitted
39	External routine invocation exception	000	No subclass
39	External routine invocation exception	004	Null value not allowed
3B	Savepoint exception	000	No subclass
3B	Savepoint exception	001	Invalid specification
3B	Savepoint exception	002	Too many
3C	Ambiguous cursor name	000	No subclass
3D	Invalid catalog name	000	No subclass
3F	Invalid schema name	000	No subclass
40	Transaction rollback	000	No subclass
40	Transaction rollback	001	Serialization failure
40	Transaction rollback	002	Integrity constraint violation
40	Transaction rollback	003	Statement completion unknown
40	Transaction rollback	004	Triggered action exception
42	Syntax error or access rule violation	000	No subclass
44	With check option violation	000	No subclass
HZ	Remote database access	000	No subclass

Author:

Lukas Eder

Enum Constant Summary

Enum Constants

Enum Constant and Description
C00000_NO_SUBCLASS
C01000_NO_SUBCLASS
C01001_CURSOR_OPERATION_CONFLICT
C01002_DISCONNECT_ERROR
C01003_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION
C01004_STRING_DATA_RIGHT_TRUNCATION
C01005_INSUFFICIENT_ITEM_DESCRIPTOR_AREAS
C01006_PRIVILEGE_NOT_REVOKED
C01007_PRIVILEGE_NOT_GRANTED
C01009_SEARCH_CONDITION_TOO_LONG_FOR_INFORMATION_SCHEMA
C0100A_QUERY_EXPRESSION_TOO_LONG_FOR_INFORMATION_SCHEMA
C0100B_DEFAULT_VALUE_TOO_LONG_FOR_INFORMATION_SCHEMA
C0100C_RESULT_SETS_RETURNED
C0100D_ADDITIONAL_RESULT_SETS_RETURNED
C0100E_ATTEMPT_TO_RETURN_TOO_MANY_RESULT_SETS
C0100F_STATEMENT_TOO_LONG_FOR_INFORMATION_SCHEMA
C01012_INVALID_NUMBER_OF_CONDITIONS
C0102F_ARRAY_DATA_RIGHT_TRUNCATION
C02000_NO_SUBCLASS
C02001_NO_ADDITIONAL_RESULT_SETS_RETURNED
C07000_NO_SUBCLASS
C07001_USING_CLAUSE_DOES_NOT_MATCH_DYNAMIC_PARAMETER_SPECIFICATIONS
C07002_USING_CLAUSE_DOES_NOT_MATCH_TARGET_SPECIFICATIONS
C07003_CURSOR_SPECIFICATION_CANNOT_BE_EXECUTED
C07004_USING_CLAUSE_REQUIRED_FOR_DYNAMIC_PARAMETERS
C07005_PREPARED_STATEMENT_NOT_A_CURSOR_SPECIFICATION
C07006_RESTRICTED_DATA_TYPE_ATTRIBUTE_VIOLATION
C07007_USING_CLAUSE_REQUIRED_FOR_RESULT_FIELDS
C07008_INVALID_DESCRIPTOR_COUNT
C07009_INVALID_DESCRIPTOR_INDEX
C0700B_DATA_TYPE_TRANSFORM_FUNCTION_VIOLATION
C0700C_UNDEFINED_DATA_VALUE
C0700D_INVALID_DATA_TARGET
C0700E_INVALID_LEVEL_VALUE
C0700F_INVALID_DATETIME_INTERVAL_CODE
C08000_NO_SUBCLASS
C08001_SQL_CLIENT_UNABLE_TO_ESTABLISH_SQL_CONNECTION
C08002_CONNECTION_NAME_IN_USE
C08003_CONNECTION_DOES_NOT_EXIST
C08004_SQL_SERVER_REJECTED_ESTABLISHMENT_OF_SQL_CONNECTION
C08006_CONNECTION_FAILURE
C08007_TRANSACTION_RESOLUTION_UNKNOWN
C09000_NO_SUBCLASS
C0A000_NO_SUBCLASS
C0A001_MULTIPLE_SERVER_TRANSACTIONS
C0D000_NO_SUBCLASS
C0E000_NO_SUBCLASS
C0F000_NO_SUBCLASS
C0F001_INVALID_SPECIFICATION
C0L000_NO_SUBCLASS
C0M000_NO_SUBCLASS
C0P000_NO_SUBCLASS
C0S000_NO_SUBCLASS
C0T000_NO_SUBCLASS
C0U000_NO_SUBCLASS
C0V000_NO_SUBCLASS
C0W000_NO_SUBCLASS
C0W001_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE
C0Z000_NO_SUBCLASS
C0Z001_MAXIMUM_NUMBER_OF_STACKED_DIAGNOSTICS_AREAS_EXCEEDED
C21000_NO_SUBCLASS
C22000_NO_SUBCLASS
C22001_STRING_DATA_RIGHT_TRUNCATION
C22002_NULL_VALUE_NO_INDICATOR_PARAMETER
C22003_NUMERIC_VALUE_OUT_OF_RANGE
C22004_NULL_VALUE_NOT_ALLOWED
C22005_ERROR_IN_ASSIGNMENT
C22006_INVALID_INTERVAL_FORMAT
C22007_INVALID_DATETIME_FORMAT
C22008_DATETIME_FIELD_OVERFLOW
C22009_INVALID_TIME_ZONE_DISPLACEMENT_VALUE
C2200B_ESCAPE_CHARACTER_CONFLICT
C2200C_INVALID_USE_OF_ESCAPE_CHARACTER
C2200D_INVALID_ESCAPE_OCTET
C2200E_NULL_VALUE_IN_ARRAY_TARGET
C2200F_ZERO_LENGTH_CHARACTER_STRING
C2200G_MOST_SPECIFIC_TYPE_MISMATCH
C2200H_SEQUENCE_GENERATOR_LIMIT_EXCEEDED
C2200P_INTERVAL_VALUE_OUT_OF_RANGE
C2200Q_MULTISET_VALUE_OVERFLOW
C22010_INVALID_INDICATOR_PARAMETER_VALUE
C22011_SUBSTRING_ERROR
C22012_DIVISION_BY_ZERO
C22013_INVALID_PRECEDING_OR_FOLLOWING_SIZE_IN_WINDOW_FUNCTION
C22014_INVALID_ARGUMENT_FOR_NTILE_FUNCTION
C22015_INTERVAL_FIELD_OVERFLOW
C22016_INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION
C22018_INVALID_CHARACTER_VALUE_FOR_CAST
C22019_INVALID_ESCAPE_CHARACTER
C2201B_INVALID_REGULAR_EXPRESSION
C2201C_NULL_ROW_NOT_PERMITTED_IN_TABLE
C2201E_INVALID_ARGUMENT_FOR_NATURAL_LOGARITHM
C2201F_INVALID_ARGUMENT_FOR_POWER_FUNCTION
C2201G_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION
C2201H_INVALID_ROW_VERSION
C2201S_INVALID_XQUERY_REGULAR_EXPRESSION
C2201T_INVALID_XQUERY_OPTION_FLAG
C2201U_ATTEMPT_TO_REPLACE_A_ZERO_LENGTH_STRING
C2201V_INVALID_XQUERY_REPLACEMENT_STRING
C2201W_INVALID_ROW_COUNT_IN_FETCH_FIRST_CLAUSE
C2201X_INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE
C22020_INVALID_PERIOD_VALUE
C22021_CHARACTER_NOT_IN_REPERTOIRE
C22022_INDICATOR_OVERFLOW
C22023_INVALID_PARAMETER_VALUE
C22024_UNTERMINATED_C_STRING
C22025_INVALID_ESCAPE_SEQUENCE
C22026_STRING_DATA_LENGTH_MISMATCH
C22027_TRIM_ERROR
C22029_NONCHARACTER_IN_UCS_STRING
C2202D_NULL_VALUE_SUBSTITUTED_FOR_MUTATOR_SUBJECT_PARAMETER
C2202E_ARRAY_ELEMENT_ERROR
C2202F_ARRAY_DATA_RIGHT_TRUNCATION
C2202G_INVALID_REPEAT_ARGUMENT_IN_SAMPLE_CLAUSE
C2202H_INVALID_SAMPLE_SIZE
C23000_NO_SUBCLASS
C23001_RESTRICT_VIOLATION
C24000_NO_SUBCLASS
C25000_NO_SUBCLASS
C25001_ACTIVE_SQL_TRANSACTION
C25002_BRANCH_TRANSACTION_ALREADY_ACTIVE
C25003_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION
C25004_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION
C25005_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION
C25006_READ_ONLY_SQL_TRANSACTION
C25007_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED
C25008_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL
C26000_NO_SUBCLASS
C27000_NO_SUBCLASS
C27001_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE
C28000_NO_SUBCLASS
C2B000_NO_SUBCLASS
C2C000_NO_SUBCLASS
C2C001_CANNOT_DROP_SQL_SESSION_DEFAULT_CHARACTER_SET
C2D000_NO_SUBCLASS
C2E000_NO_SUBCLASS
C2F000_NO_SUBCLASS
C2F002_MODIFYING_SQL_DATA_NOT_PERMITTED
C2F003_PROHIBITED_SQL_STATEMENT_ATTEMPTED
C2F004_READING_SQL_DATA_NOT_PERMITTED
C2F005_FUNCTION_EXECUTED_NO_RETURN_STATEMENT
C2H000_NO_SUBCLASS
C30000_NO_SUBCLASS
C33000_NO_SUBCLASS
C34000_NO_SUBCLASS
C35000_NO_SUBCLASS
C36000_NO_SUBCLASS
C36001_REQUEST_REJECTED
C36002_REQUEST_FAILED
C38000_NO_SUBCLASS
C38001_CONTAINING_SQL_NOT_PERMITTED
C38002_MODIFYING_SQL_DATA_NOT_PERMITTED
C38003_PROHIBITED_SQL_STATEMENT_ATTEMPTED
C38004_READING_SQL_DATA_NOT_PERMITTED
C39000_NO_SUBCLASS
C39004_NULL_VALUE_NOT_ALLOWED
C3B000_NO_SUBCLASS
C3B001_INVALID_SPECIFICATION
C3B002_TOO_MANY
C3C000_NO_SUBCLASS
C3D000_NO_SUBCLASS
C3F000_NO_SUBCLASS
C40000_NO_SUBCLASS
C40001_SERIALIZATION_FAILURE
C40002_INTEGRITY_CONSTRAINT_VIOLATION
C40003_STATEMENT_COMPLETION_UNKNOWN
C40004_TRIGGERED_ACTION_EXCEPTION
C42000_NO_SUBCLASS
CHZ000_NO_SUBCLASS
NONE
OTHER

Method Summary

Modifier and Type	Method and Description
static SQLStateSubclass	fromCode(String code)
SQLStateClass	sqlStateClass()
String	sqlStateClassName()
String	sqlStateSubclassName()
static SQLStateSubclass	valueOf(String name) Returns the enum constant of this type with the specified name.
static SQLStateSubclass[]	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

C00000_NO_SUBCLASS

public static final SQLStateSubclass C00000_NO_SUBCLASS

C01000_NO_SUBCLASS

public static final SQLStateSubclass C01000_NO_SUBCLASS

C01001_CURSOR_OPERATION_CONFLICT

public static final SQLStateSubclass C01001_CURSOR_OPERATION_CONFLICT

C01002_DISCONNECT_ERROR

public static final SQLStateSubclass C01002_DISCONNECT_ERROR

C01003_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION

public static final SQLStateSubclass C01003_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION

C01004_STRING_DATA_RIGHT_TRUNCATION

public static final SQLStateSubclass C01004_STRING_DATA_RIGHT_TRUNCATION

C01005_INSUFFICIENT_ITEM_DESCRIPTOR_AREAS

public static final SQLStateSubclass C01005_INSUFFICIENT_ITEM_DESCRIPTOR_AREAS

C01006_PRIVILEGE_NOT_REVOKED

public static final SQLStateSubclass C01006_PRIVILEGE_NOT_REVOKED

C01007_PRIVILEGE_NOT_GRANTED

public static final SQLStateSubclass C01007_PRIVILEGE_NOT_GRANTED

C01009_SEARCH_CONDITION_TOO_LONG_FOR_INFORMATION_SCHEMA

public static final SQLStateSubclass C01009_SEARCH_CONDITION_TOO_LONG_FOR_INFORMATION_SCHEMA

C0100A_QUERY_EXPRESSION_TOO_LONG_FOR_INFORMATION_SCHEMA

public static final SQLStateSubclass C0100A_QUERY_EXPRESSION_TOO_LONG_FOR_INFORMATION_SCHEMA

C0100B_DEFAULT_VALUE_TOO_LONG_FOR_INFORMATION_SCHEMA

public static final SQLStateSubclass C0100B_DEFAULT_VALUE_TOO_LONG_FOR_INFORMATION_SCHEMA

C0100C_RESULT_SETS_RETURNED

public static final SQLStateSubclass C0100C_RESULT_SETS_RETURNED

C0100D_ADDITIONAL_RESULT_SETS_RETURNED

public static final SQLStateSubclass C0100D_ADDITIONAL_RESULT_SETS_RETURNED

C0100E_ATTEMPT_TO_RETURN_TOO_MANY_RESULT_SETS

public static final SQLStateSubclass C0100E_ATTEMPT_TO_RETURN_TOO_MANY_RESULT_SETS

C0100F_STATEMENT_TOO_LONG_FOR_INFORMATION_SCHEMA

public static final SQLStateSubclass C0100F_STATEMENT_TOO_LONG_FOR_INFORMATION_SCHEMA

C01012_INVALID_NUMBER_OF_CONDITIONS

public static final SQLStateSubclass C01012_INVALID_NUMBER_OF_CONDITIONS

C0102F_ARRAY_DATA_RIGHT_TRUNCATION

public static final SQLStateSubclass C0102F_ARRAY_DATA_RIGHT_TRUNCATION

C02000_NO_SUBCLASS

public static final SQLStateSubclass C02000_NO_SUBCLASS

C02001_NO_ADDITIONAL_RESULT_SETS_RETURNED

public static final SQLStateSubclass C02001_NO_ADDITIONAL_RESULT_SETS_RETURNED

C07000_NO_SUBCLASS

public static final SQLStateSubclass C07000_NO_SUBCLASS

C07001_USING_CLAUSE_DOES_NOT_MATCH_DYNAMIC_PARAMETER_SPECIFICATIONS

public static final SQLStateSubclass C07001_USING_CLAUSE_DOES_NOT_MATCH_DYNAMIC_PARAMETER_SPECIFICATIONS

C07002_USING_CLAUSE_DOES_NOT_MATCH_TARGET_SPECIFICATIONS

public static final SQLStateSubclass C07002_USING_CLAUSE_DOES_NOT_MATCH_TARGET_SPECIFICATIONS

C07003_CURSOR_SPECIFICATION_CANNOT_BE_EXECUTED

public static final SQLStateSubclass C07003_CURSOR_SPECIFICATION_CANNOT_BE_EXECUTED

C07004_USING_CLAUSE_REQUIRED_FOR_DYNAMIC_PARAMETERS

public static final SQLStateSubclass C07004_USING_CLAUSE_REQUIRED_FOR_DYNAMIC_PARAMETERS

C07005_PREPARED_STATEMENT_NOT_A_CURSOR_SPECIFICATION

public static final SQLStateSubclass C07005_PREPARED_STATEMENT_NOT_A_CURSOR_SPECIFICATION

C07006_RESTRICTED_DATA_TYPE_ATTRIBUTE_VIOLATION

public static final SQLStateSubclass C07006_RESTRICTED_DATA_TYPE_ATTRIBUTE_VIOLATION

C07007_USING_CLAUSE_REQUIRED_FOR_RESULT_FIELDS

public static final SQLStateSubclass C07007_USING_CLAUSE_REQUIRED_FOR_RESULT_FIELDS

C07008_INVALID_DESCRIPTOR_COUNT

public static final SQLStateSubclass C07008_INVALID_DESCRIPTOR_COUNT

C07009_INVALID_DESCRIPTOR_INDEX

public static final SQLStateSubclass C07009_INVALID_DESCRIPTOR_INDEX

C0700B_DATA_TYPE_TRANSFORM_FUNCTION_VIOLATION

public static final SQLStateSubclass C0700B_DATA_TYPE_TRANSFORM_FUNCTION_VIOLATION

C0700C_UNDEFINED_DATA_VALUE

public static final SQLStateSubclass C0700C_UNDEFINED_DATA_VALUE

C0700D_INVALID_DATA_TARGET

public static final SQLStateSubclass C0700D_INVALID_DATA_TARGET

C0700E_INVALID_LEVEL_VALUE

public static final SQLStateSubclass C0700E_INVALID_LEVEL_VALUE

C0700F_INVALID_DATETIME_INTERVAL_CODE

public static final SQLStateSubclass C0700F_INVALID_DATETIME_INTERVAL_CODE

C08000_NO_SUBCLASS

public static final SQLStateSubclass C08000_NO_SUBCLASS

C08001_SQL_CLIENT_UNABLE_TO_ESTABLISH_SQL_CONNECTION

public static final SQLStateSubclass C08001_SQL_CLIENT_UNABLE_TO_ESTABLISH_SQL_CONNECTION

C08002_CONNECTION_NAME_IN_USE

public static final SQLStateSubclass C08002_CONNECTION_NAME_IN_USE

C08003_CONNECTION_DOES_NOT_EXIST

public static final SQLStateSubclass C08003_CONNECTION_DOES_NOT_EXIST

C08004_SQL_SERVER_REJECTED_ESTABLISHMENT_OF_SQL_CONNECTION

public static final SQLStateSubclass C08004_SQL_SERVER_REJECTED_ESTABLISHMENT_OF_SQL_CONNECTION

C08006_CONNECTION_FAILURE

public static final SQLStateSubclass C08006_CONNECTION_FAILURE

C08007_TRANSACTION_RESOLUTION_UNKNOWN

public static final SQLStateSubclass C08007_TRANSACTION_RESOLUTION_UNKNOWN

C09000_NO_SUBCLASS

public static final SQLStateSubclass C09000_NO_SUBCLASS

C0A000_NO_SUBCLASS

public static final SQLStateSubclass C0A000_NO_SUBCLASS

C0A001_MULTIPLE_SERVER_TRANSACTIONS

public static final SQLStateSubclass C0A001_MULTIPLE_SERVER_TRANSACTIONS

C0D000_NO_SUBCLASS

public static final SQLStateSubclass C0D000_NO_SUBCLASS

C0E000_NO_SUBCLASS

public static final SQLStateSubclass C0E000_NO_SUBCLASS

C0F000_NO_SUBCLASS

public static final SQLStateSubclass C0F000_NO_SUBCLASS

C0F001_INVALID_SPECIFICATION

public static final SQLStateSubclass C0F001_INVALID_SPECIFICATION

C0L000_NO_SUBCLASS

public static final SQLStateSubclass C0L000_NO_SUBCLASS

C0M000_NO_SUBCLASS

public static final SQLStateSubclass C0M000_NO_SUBCLASS

C0P000_NO_SUBCLASS

public static final SQLStateSubclass C0P000_NO_SUBCLASS

C0S000_NO_SUBCLASS

public static final SQLStateSubclass C0S000_NO_SUBCLASS

C0T000_NO_SUBCLASS

public static final SQLStateSubclass C0T000_NO_SUBCLASS

C0U000_NO_SUBCLASS

public static final SQLStateSubclass C0U000_NO_SUBCLASS

C0V000_NO_SUBCLASS

public static final SQLStateSubclass C0V000_NO_SUBCLASS

C0W000_NO_SUBCLASS

public static final SQLStateSubclass C0W000_NO_SUBCLASS

C0W001_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE

public static final SQLStateSubclass C0W001_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE

C0Z000_NO_SUBCLASS

public static final SQLStateSubclass C0Z000_NO_SUBCLASS

C0Z001_MAXIMUM_NUMBER_OF_STACKED_DIAGNOSTICS_AREAS_EXCEEDED

public static final SQLStateSubclass C0Z001_MAXIMUM_NUMBER_OF_STACKED_DIAGNOSTICS_AREAS_EXCEEDED

C21000_NO_SUBCLASS

public static final SQLStateSubclass C21000_NO_SUBCLASS

C22000_NO_SUBCLASS

public static final SQLStateSubclass C22000_NO_SUBCLASS

C22001_STRING_DATA_RIGHT_TRUNCATION

public static final SQLStateSubclass C22001_STRING_DATA_RIGHT_TRUNCATION

C22002_NULL_VALUE_NO_INDICATOR_PARAMETER

public static final SQLStateSubclass C22002_NULL_VALUE_NO_INDICATOR_PARAMETER

C22003_NUMERIC_VALUE_OUT_OF_RANGE

public static final SQLStateSubclass C22003_NUMERIC_VALUE_OUT_OF_RANGE

C22004_NULL_VALUE_NOT_ALLOWED

public static final SQLStateSubclass C22004_NULL_VALUE_NOT_ALLOWED

C22005_ERROR_IN_ASSIGNMENT

public static final SQLStateSubclass C22005_ERROR_IN_ASSIGNMENT

C22006_INVALID_INTERVAL_FORMAT

public static final SQLStateSubclass C22006_INVALID_INTERVAL_FORMAT

C22007_INVALID_DATETIME_FORMAT

public static final SQLStateSubclass C22007_INVALID_DATETIME_FORMAT

C22008_DATETIME_FIELD_OVERFLOW

public static final SQLStateSubclass C22008_DATETIME_FIELD_OVERFLOW

C22009_INVALID_TIME_ZONE_DISPLACEMENT_VALUE

public static final SQLStateSubclass C22009_INVALID_TIME_ZONE_DISPLACEMENT_VALUE

C2200B_ESCAPE_CHARACTER_CONFLICT

public static final SQLStateSubclass C2200B_ESCAPE_CHARACTER_CONFLICT

C2200C_INVALID_USE_OF_ESCAPE_CHARACTER

public static final SQLStateSubclass C2200C_INVALID_USE_OF_ESCAPE_CHARACTER

C2200D_INVALID_ESCAPE_OCTET

public static final SQLStateSubclass C2200D_INVALID_ESCAPE_OCTET

C2200E_NULL_VALUE_IN_ARRAY_TARGET

public static final SQLStateSubclass C2200E_NULL_VALUE_IN_ARRAY_TARGET

C2200F_ZERO_LENGTH_CHARACTER_STRING

public static final SQLStateSubclass C2200F_ZERO_LENGTH_CHARACTER_STRING

C2200G_MOST_SPECIFIC_TYPE_MISMATCH

public static final SQLStateSubclass C2200G_MOST_SPECIFIC_TYPE_MISMATCH

C2200H_SEQUENCE_GENERATOR_LIMIT_EXCEEDED

public static final SQLStateSubclass C2200H_SEQUENCE_GENERATOR_LIMIT_EXCEEDED

C2200P_INTERVAL_VALUE_OUT_OF_RANGE

public static final SQLStateSubclass C2200P_INTERVAL_VALUE_OUT_OF_RANGE

C2200Q_MULTISET_VALUE_OVERFLOW

public static final SQLStateSubclass C2200Q_MULTISET_VALUE_OVERFLOW

C22010_INVALID_INDICATOR_PARAMETER_VALUE

public static final SQLStateSubclass C22010_INVALID_INDICATOR_PARAMETER_VALUE

C22011_SUBSTRING_ERROR

public static final SQLStateSubclass C22011_SUBSTRING_ERROR

C22012_DIVISION_BY_ZERO

public static final SQLStateSubclass C22012_DIVISION_BY_ZERO

C22013_INVALID_PRECEDING_OR_FOLLOWING_SIZE_IN_WINDOW_FUNCTION

public static final SQLStateSubclass C22013_INVALID_PRECEDING_OR_FOLLOWING_SIZE_IN_WINDOW_FUNCTION

C22014_INVALID_ARGUMENT_FOR_NTILE_FUNCTION

public static final SQLStateSubclass C22014_INVALID_ARGUMENT_FOR_NTILE_FUNCTION

C22015_INTERVAL_FIELD_OVERFLOW

public static final SQLStateSubclass C22015_INTERVAL_FIELD_OVERFLOW

C22016_INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION

public static final SQLStateSubclass C22016_INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION

C22018_INVALID_CHARACTER_VALUE_FOR_CAST

public static final SQLStateSubclass C22018_INVALID_CHARACTER_VALUE_FOR_CAST

C22019_INVALID_ESCAPE_CHARACTER

public static final SQLStateSubclass C22019_INVALID_ESCAPE_CHARACTER

C2201B_INVALID_REGULAR_EXPRESSION

public static final SQLStateSubclass C2201B_INVALID_REGULAR_EXPRESSION

C2201C_NULL_ROW_NOT_PERMITTED_IN_TABLE

public static final SQLStateSubclass C2201C_NULL_ROW_NOT_PERMITTED_IN_TABLE

C2201E_INVALID_ARGUMENT_FOR_NATURAL_LOGARITHM

public static final SQLStateSubclass C2201E_INVALID_ARGUMENT_FOR_NATURAL_LOGARITHM

C2201F_INVALID_ARGUMENT_FOR_POWER_FUNCTION

public static final SQLStateSubclass C2201F_INVALID_ARGUMENT_FOR_POWER_FUNCTION

C2201G_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION

public static final SQLStateSubclass C2201G_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION

C2201H_INVALID_ROW_VERSION

public static final SQLStateSubclass C2201H_INVALID_ROW_VERSION

C2201S_INVALID_XQUERY_REGULAR_EXPRESSION

public static final SQLStateSubclass C2201S_INVALID_XQUERY_REGULAR_EXPRESSION

C2201T_INVALID_XQUERY_OPTION_FLAG

public static final SQLStateSubclass C2201T_INVALID_XQUERY_OPTION_FLAG

C2201U_ATTEMPT_TO_REPLACE_A_ZERO_LENGTH_STRING

public static final SQLStateSubclass C2201U_ATTEMPT_TO_REPLACE_A_ZERO_LENGTH_STRING

C2201V_INVALID_XQUERY_REPLACEMENT_STRING

public static final SQLStateSubclass C2201V_INVALID_XQUERY_REPLACEMENT_STRING

C2201W_INVALID_ROW_COUNT_IN_FETCH_FIRST_CLAUSE

public static final SQLStateSubclass C2201W_INVALID_ROW_COUNT_IN_FETCH_FIRST_CLAUSE

C2201X_INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE

public static final SQLStateSubclass C2201X_INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE

C22020_INVALID_PERIOD_VALUE

public static final SQLStateSubclass C22020_INVALID_PERIOD_VALUE

C22021_CHARACTER_NOT_IN_REPERTOIRE

public static final SQLStateSubclass C22021_CHARACTER_NOT_IN_REPERTOIRE

C22022_INDICATOR_OVERFLOW

public static final SQLStateSubclass C22022_INDICATOR_OVERFLOW

C22023_INVALID_PARAMETER_VALUE

public static final SQLStateSubclass C22023_INVALID_PARAMETER_VALUE

C22024_UNTERMINATED_C_STRING

public static final SQLStateSubclass C22024_UNTERMINATED_C_STRING

C22025_INVALID_ESCAPE_SEQUENCE

public static final SQLStateSubclass C22025_INVALID_ESCAPE_SEQUENCE

C22026_STRING_DATA_LENGTH_MISMATCH

public static final SQLStateSubclass C22026_STRING_DATA_LENGTH_MISMATCH

C22027_TRIM_ERROR

public static final SQLStateSubclass C22027_TRIM_ERROR

C22029_NONCHARACTER_IN_UCS_STRING

public static final SQLStateSubclass C22029_NONCHARACTER_IN_UCS_STRING

C2202D_NULL_VALUE_SUBSTITUTED_FOR_MUTATOR_SUBJECT_PARAMETER

public static final SQLStateSubclass C2202D_NULL_VALUE_SUBSTITUTED_FOR_MUTATOR_SUBJECT_PARAMETER

C2202E_ARRAY_ELEMENT_ERROR

public static final SQLStateSubclass C2202E_ARRAY_ELEMENT_ERROR

C2202F_ARRAY_DATA_RIGHT_TRUNCATION

public static final SQLStateSubclass C2202F_ARRAY_DATA_RIGHT_TRUNCATION

C2202G_INVALID_REPEAT_ARGUMENT_IN_SAMPLE_CLAUSE

public static final SQLStateSubclass C2202G_INVALID_REPEAT_ARGUMENT_IN_SAMPLE_CLAUSE

C2202H_INVALID_SAMPLE_SIZE

public static final SQLStateSubclass C2202H_INVALID_SAMPLE_SIZE

C23000_NO_SUBCLASS

public static final SQLStateSubclass C23000_NO_SUBCLASS

C23001_RESTRICT_VIOLATION

public static final SQLStateSubclass C23001_RESTRICT_VIOLATION

C24000_NO_SUBCLASS

public static final SQLStateSubclass C24000_NO_SUBCLASS

C25000_NO_SUBCLASS

public static final SQLStateSubclass C25000_NO_SUBCLASS

C25001_ACTIVE_SQL_TRANSACTION

public static final SQLStateSubclass C25001_ACTIVE_SQL_TRANSACTION

C25002_BRANCH_TRANSACTION_ALREADY_ACTIVE

public static final SQLStateSubclass C25002_BRANCH_TRANSACTION_ALREADY_ACTIVE

C25003_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION

public static final SQLStateSubclass C25003_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION

C25004_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION

public static final SQLStateSubclass C25004_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION

C25005_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION

public static final SQLStateSubclass C25005_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION

C25006_READ_ONLY_SQL_TRANSACTION

public static final SQLStateSubclass C25006_READ_ONLY_SQL_TRANSACTION

C25007_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED

public static final SQLStateSubclass C25007_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED

C25008_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL

public static final SQLStateSubclass C25008_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL

C26000_NO_SUBCLASS

public static final SQLStateSubclass C26000_NO_SUBCLASS

C27000_NO_SUBCLASS

public static final SQLStateSubclass C27000_NO_SUBCLASS

C27001_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE

public static final SQLStateSubclass C27001_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE

C28000_NO_SUBCLASS

public static final SQLStateSubclass C28000_NO_SUBCLASS

C2B000_NO_SUBCLASS

public static final SQLStateSubclass C2B000_NO_SUBCLASS

C2C000_NO_SUBCLASS

public static final SQLStateSubclass C2C000_NO_SUBCLASS

C2C001_CANNOT_DROP_SQL_SESSION_DEFAULT_CHARACTER_SET

public static final SQLStateSubclass C2C001_CANNOT_DROP_SQL_SESSION_DEFAULT_CHARACTER_SET

C2D000_NO_SUBCLASS

public static final SQLStateSubclass C2D000_NO_SUBCLASS

C2E000_NO_SUBCLASS

public static final SQLStateSubclass C2E000_NO_SUBCLASS

C2F000_NO_SUBCLASS

public static final SQLStateSubclass C2F000_NO_SUBCLASS

C2F002_MODIFYING_SQL_DATA_NOT_PERMITTED

public static final SQLStateSubclass C2F002_MODIFYING_SQL_DATA_NOT_PERMITTED

C2F003_PROHIBITED_SQL_STATEMENT_ATTEMPTED

public static final SQLStateSubclass C2F003_PROHIBITED_SQL_STATEMENT_ATTEMPTED

C2F004_READING_SQL_DATA_NOT_PERMITTED

public static final SQLStateSubclass C2F004_READING_SQL_DATA_NOT_PERMITTED

C2F005_FUNCTION_EXECUTED_NO_RETURN_STATEMENT

public static final SQLStateSubclass C2F005_FUNCTION_EXECUTED_NO_RETURN_STATEMENT

C2H000_NO_SUBCLASS

public static final SQLStateSubclass C2H000_NO_SUBCLASS

C30000_NO_SUBCLASS

public static final SQLStateSubclass C30000_NO_SUBCLASS

C33000_NO_SUBCLASS

public static final SQLStateSubclass C33000_NO_SUBCLASS

C34000_NO_SUBCLASS

public static final SQLStateSubclass C34000_NO_SUBCLASS

C35000_NO_SUBCLASS

public static final SQLStateSubclass C35000_NO_SUBCLASS

C36000_NO_SUBCLASS

public static final SQLStateSubclass C36000_NO_SUBCLASS

C36001_REQUEST_REJECTED

public static final SQLStateSubclass C36001_REQUEST_REJECTED

C36002_REQUEST_FAILED

public static final SQLStateSubclass C36002_REQUEST_FAILED

C38000_NO_SUBCLASS

public static final SQLStateSubclass C38000_NO_SUBCLASS

C38001_CONTAINING_SQL_NOT_PERMITTED

public static final SQLStateSubclass C38001_CONTAINING_SQL_NOT_PERMITTED

C38002_MODIFYING_SQL_DATA_NOT_PERMITTED

public static final SQLStateSubclass C38002_MODIFYING_SQL_DATA_NOT_PERMITTED

C38003_PROHIBITED_SQL_STATEMENT_ATTEMPTED

public static final SQLStateSubclass C38003_PROHIBITED_SQL_STATEMENT_ATTEMPTED

C38004_READING_SQL_DATA_NOT_PERMITTED

public static final SQLStateSubclass C38004_READING_SQL_DATA_NOT_PERMITTED

C39000_NO_SUBCLASS

public static final SQLStateSubclass C39000_NO_SUBCLASS

C39004_NULL_VALUE_NOT_ALLOWED

public static final SQLStateSubclass C39004_NULL_VALUE_NOT_ALLOWED

C3B000_NO_SUBCLASS

public static final SQLStateSubclass C3B000_NO_SUBCLASS

C3B001_INVALID_SPECIFICATION

public static final SQLStateSubclass C3B001_INVALID_SPECIFICATION

C3B002_TOO_MANY

public static final SQLStateSubclass C3B002_TOO_MANY

C3C000_NO_SUBCLASS

public static final SQLStateSubclass C3C000_NO_SUBCLASS

C3D000_NO_SUBCLASS

public static final SQLStateSubclass C3D000_NO_SUBCLASS

C3F000_NO_SUBCLASS

public static final SQLStateSubclass C3F000_NO_SUBCLASS

C40000_NO_SUBCLASS

public static final SQLStateSubclass C40000_NO_SUBCLASS

C40001_SERIALIZATION_FAILURE

public static final SQLStateSubclass C40001_SERIALIZATION_FAILURE

C40002_INTEGRITY_CONSTRAINT_VIOLATION

public static final SQLStateSubclass C40002_INTEGRITY_CONSTRAINT_VIOLATION

C40003_STATEMENT_COMPLETION_UNKNOWN

public static final SQLStateSubclass C40003_STATEMENT_COMPLETION_UNKNOWN

C40004_TRIGGERED_ACTION_EXCEPTION

public static final SQLStateSubclass C40004_TRIGGERED_ACTION_EXCEPTION

C42000_NO_SUBCLASS

public static final SQLStateSubclass C42000_NO_SUBCLASS

CHZ000_NO_SUBCLASS

public static final SQLStateSubclass CHZ000_NO_SUBCLASS

OTHER

public static final SQLStateSubclass OTHER

NONE

public static final SQLStateSubclass NONE

Method Detail

values

public static SQLStateSubclass[] 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 (SQLStateSubclass c : SQLStateSubclass.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static SQLStateSubclass 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

sqlStateSubclassName

public String sqlStateSubclassName()

sqlStateClass

public SQLStateClass sqlStateClass()

sqlStateClassName

public String sqlStateClassName()

fromCode

public static SQLStateSubclass fromCode(String code)