java.lang.Object
- java.lang.Enum<SqlState>
- - org.apache.calcite.avatica.SqlState

All Implemented Interfaces:: java.io.Serializable, java.lang.Comparable<SqlState>

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

SQL error codes.

Based upon Table 33 — SQLSTATE class and subclass values in SQL:2014 section 24.1, which is as follows.

Table 33 — SQLSTATE class and subclass values
Category	Condition	Class	Subcondition	Subclass
X	ambiguous cursor name	3C	(no subclass)	000
X	attempt to assign to non-updatable column	0U	(no subclass)	000
X	attempt to assign to ordering column	0V	(no subclass)	000
X	cli specific condition	HY	(no subclass)	000
X	cardinality violation	21	(no subclass)	000
X	connection exception	08	(no subclass)	000
			connection does not exist	003
			connection failure	006
			connection name in use	002
			SQL-client unable to establish SQL-connection	001
			SQL-server rejected establishment of SQL-connection	004
			transaction resolution unknown	007
X	cursor sensitivity exception	36	(no subclass)	000
			request failed	002
			request rejected	001
X	data exception	22	(no subclass)	000
			array data, right truncation	02F
			array element error	02E
			attempt to replace a zero-length string	01U
			character not in repertoire	021
			datetime field overflow	008
			division by zero	012
			error in assignment	005
			escape character conflict	00B
			indicator overflow	022
			interval field overflow	015
			interval value out of range	00P
			invalid argument for natural logarithm	01E
			invalid argument for NTILE function	014
			invalid argument for NTH_VALUE function	016
			invalid argument for power function	01F
			invalid argument for row pattern navigation operation	02J
			invalid argument for width bucket function	01G
			invalid character value for cast	018
			invalid datetime format	007
			invalid escape character	019
			invalid escape octet	00D
			invalid escape sequence	025
			invalid indicator parameter value	010
			invalid interval format	006
			invalid parameter value	023
			invalid period value	020
			invalid preceding or following size in window function	013
			invalid regular expression	01B
			invalid repeat argument in a sample clause	02G
			invalid row count in fetch first clause	01W
			invalid row count in result offset clause	01X
			invalid row version	01H
			invalid sample size	02H
			invalid time zone displacement value	009
			invalid use of escape character	00C
			invalid XQuery option flag	01T
			invalid XQuery regular expression	01S
			invalid XQuery replacement string	01V
			most specific type mismatch	00G
			multiset value overflow	00Q
			noncharacter in UCS string	029
			null value substituted for mutator subject parameter	02D
			null row not permitted in table	01C
			null value in array target	00E
			null value, no indicator parameter	002
			null value not allowed	004
			numeric value out of range	003
			sequence generator limit exceeded	00H
			skip to non-existent row	02K
			skip to first row of match	02L
			string data, length mismatch	026
			string data, right truncation	001
			substring error	011
			trim error	027
			unterminated C string	024
			zero-length character string	00F
X	dependent privilege descriptors still exist	2B	(no subclass)	000
X	diagnostics exception	0Z	(no subclass)	000
			maximum number of stacked diagnostics areas exceeded	001
X	dynamic SQL error	07	(no subclass)	000
			cursor specification cannot be executed	003
			data type transform function violation	00B
			invalid DATA target	00D
			invalid DATETIME_INTERVAL_CODE	00F
			invalid descriptor count	008
			invalid descriptor index	009
			invalid LEVEL value	00E
			prepared statement not a cursor specification	005
			restricted data type attribute violation	006
			undefined DATA value	00C
			using clause does not match dynamic parameter specifications	001
			using clause does not match target specifications	002
			using clause required for dynamic parameters	004
			using clause required for result fields	007
X	external routine exception	38	(no subclass)	000
			containing SQL not permitted	001
			modifying SQL-data not permitted	002
			prohibited SQL-statement attempted	003
			reading SQL-data not permitted	004
X	external routine invocation exception	39	(no subclass)	000
			null value not allowed	004
X	feature not supported	0A	(no subclass)	000
			multiple server transactions	001
X	integrity constraint violation	23	(no subclass)	000
			restrict violation	001
X	invalid authorization specification	28	(no subclass)	000
X	invalid catalog name	3D	(no subclass)	000
X	invalid character set name	2C	(no subclass)	000
			cannot drop SQL-session default character set	001
X	invalid condition number	35	(no subclass)	000
X	invalid connection name	2E	(no subclass)	000
X	invalid cursor name	34	(no subclass)	000
X	invalid cursor state	24	(no subclass)	000
X	invalid grantor	0L	(no subclass)	000
X	invalid role specification	0P	(no subclass)	000
X	invalid schema name	3F	(no subclass)	000
X	invalid schema name list specification	0E	(no subclass)	000
X	invalid collation name	2H	(no subclass)	000
X	invalid SQL descriptor name	33	(no subclass)	000
X	invalid SQL-invoked procedure reference	0M	(no subclass)	000
X	invalid SQL statement name	26	(no subclass)	000
X	invalid SQL statement identifier	30	(no subclass)	000
X	invalid target type specification	0D	(no subclass)	000
X	invalid transaction state	25	(no subclass)	000
			active SQL-transaction	001
			branch transaction already active	002
			held cursor requires same isolation level	008
			inappropriate access mode for branch transaction	003
			inappropriate isolation level for branch transaction	004
			no active SQL-transaction for branch transaction	005
			read-only SQL-transaction	006
			schema and data statement mixing not supported	007
X	invalid transaction termination	2D	(no subclass)	000
X	invalid transform group name specification	0S	(no subclass)	000
X	locator exception	0F	(no subclass)	000
			invalid specification	001
N	no data	02	(no subclass)	000
			no additional result sets returned	001
X	prohibited statement encountered during trigger execution	0W	(no subclass)	000
			modify table modified by data change delta table	001
X	Remote Database Access	HZ	(no subclass)	000
X	savepoint exception	3B	(no subclass)	000
			invalid specification	001
			too many	002
X	SQL routine exception	2F	(no subclass)	000
			function executed no return statement	005
			modifying SQL-data not permitted	002
			prohibited SQL-statement attempted	003
			reading SQL-data not permitted	004
S	successful completion	00	(no subclass)	000
X	syntax error or access rule violation	42	(no subclass)	000
X	syntax error or access rule violation in direct statement	2A	(no subclass)	000
X	syntax error or access rule violation in dynamic statement	37	(no subclass)	000
X	target table disagrees with cursor specification	0T	(no subclass)	000
X	transaction rollback	40	(no subclass)	000
			integrity constraint violation	002
			serialization failure	001
			statement completion unknown	003
			triggered action exception	004
X	triggered action exception	09	(no subclass)	000
X	triggered data change violation	27	(no subclass)	000
			modify table modified by data change delta table	001
W	warning	01	(no subclass)	000
			additional result sets returned	00D
			array data, right truncation	02F
			attempt to return too many result sets	00E
			cursor operation conflict	001
			default value too long for information schema	00B
			disconnect error	002
			insufficient item descriptor areas	005
			invalid number of conditions	012
			null value eliminated in set function	003
			privilege not granted	007
			privilege not revoked	006
			query expression too long for information schema	00A
			result sets returned	00C
			search condition too long for information schema	009
			statement too long for information schema	00F
			string data, right truncation	004
X	with check option violation	44	(no subclass)	000

Nested Class Summary

Nested Classes
Modifier and Type Class Description

(package private) static class SqlState.Category
Severity types.

Enum Constant Summary

Enum Constants
Enum Constant	Description
`AMBIGUOUS_CURSOR_NAME_NO_SUBCLASS`	3C000: ambiguous cursor name
`ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN_NO_SUBCLASS`	0U000: attempt to assign to non-updatable column
`ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN_NO_SUBCLASS`	0V000: attempt to assign to ordering column
`CARDINALITY_VIOLATION_NO_SUBCLASS`	21000: cardinality violation
`CLI_SPECIFIC_CONDITION_NO_SUBCLASS`	HY000: cli specific condition
`CONNECTION_EXCEPTION_CONNECTION_DOES_NOT_EXIST`	08003: connection exception: connection does not exist
`CONNECTION_EXCEPTION_CONNECTION_FAILURE`	08006: connection exception: connection failure
`CONNECTION_EXCEPTION_CONNECTION_NAME_IN_USE`	08002: connection exception: connection name in use
`CONNECTION_EXCEPTION_NO_SUBCLASS`	08000: connection exception
`CONNECTION_EXCEPTION_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION`	08001: connection exception: SQL-client unable to establish SQL-connection
`CONNECTION_EXCEPTION_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION`	08004: connection exception: SQL-server rejected establishment of SQL-connection
`CONNECTION_EXCEPTION_TRANSACTION_RESOLUTION_UNKNOWN`	08007: connection exception: transaction resolution unknown
`CURSOR_SENSITIVITY_EXCEPTION_NO_SUBCLASS`	36000: cursor sensitivity exception
`CURSOR_SENSITIVITY_EXCEPTION_REQUEST_FAILED`	36002: cursor sensitivity exception: request failed
`CURSOR_SENSITIVITY_EXCEPTION_REQUEST_REJECTED`	36001: cursor sensitivity exception: request rejected
`DATA_EXCEPTION_ARRAY_DATA_RIGHT_TRUNCATION`	2202F: data exception: array data, right truncation
`DATA_EXCEPTION_ARRAY_ELEMENT_ERROR`	2202E: data exception: array element error
`DATA_EXCEPTION_ATTEMPT_TO_REPLACE_A_ZERO_LENGTH_STRING`	2201U: data exception: attempt to replace a zero-length string
`DATA_EXCEPTION_CHARACTER_NOT_IN_REPERTOIRE`	22021: data exception: character not in repertoire
`DATA_EXCEPTION_DATETIME_FIELD_OVERFLOW`	22008: data exception: datetime field overflow
`DATA_EXCEPTION_DIVISION_BY_ZERO`	22012: data exception: division by zero
`DATA_EXCEPTION_ERROR_IN_ASSIGNMENT`	22005: data exception: error in assignment
`DATA_EXCEPTION_ESCAPE_CHARACTER_CONFLICT`	2200B: data exception: escape character conflict
`DATA_EXCEPTION_INDICATOR_OVERFLOW`	22022: data exception: indicator overflow
`DATA_EXCEPTION_INTERVAL_FIELD_OVERFLOW`	22015: data exception: interval field overflow
`DATA_EXCEPTION_INTERVAL_VALUE_OUT_OF_RANGE`	2200P: data exception: interval value out of range
`DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NATURAL_LOGARITHM`	2201E: data exception: invalid argument for natural logarithm
`DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION`	22016: data exception: invalid argument for NTH_VALUE function
`DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NTILE_FUNCTION`	22014: data exception: invalid argument for NTILE function
`DATA_EXCEPTION_INVALID_ARGUMENT_FOR_POWER_FUNCTION`	2201F: data exception: invalid argument for power function
`DATA_EXCEPTION_INVALID_ARGUMENT_FOR_ROW_PATTERN_NAVIGATION_OPERATION`	2202J: data exception: invalid argument for row pattern navigation operation
`DATA_EXCEPTION_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION`	2201G: data exception: invalid argument for width bucket function
`DATA_EXCEPTION_INVALID_CHARACTER_VALUE_FOR_CAST`	22018: data exception: invalid character value for cast
`DATA_EXCEPTION_INVALID_DATETIME_FORMAT`	22007: data exception: invalid datetime format
`DATA_EXCEPTION_INVALID_ESCAPE_CHARACTER`	22019: data exception: invalid escape character
`DATA_EXCEPTION_INVALID_ESCAPE_OCTET`	2200D: data exception: invalid escape octet
`DATA_EXCEPTION_INVALID_ESCAPE_SEQUENCE`	22025: data exception: invalid escape sequence
`DATA_EXCEPTION_INVALID_INDICATOR_PARAMETER_VALUE`	22010: data exception: invalid indicator parameter value
`DATA_EXCEPTION_INVALID_INTERVAL_FORMAT`	22006: data exception: invalid interval format
`DATA_EXCEPTION_INVALID_PARAMETER_VALUE`	22023: data exception: invalid parameter value
`DATA_EXCEPTION_INVALID_PERIOD_VALUE`	22020: data exception: invalid period value
`DATA_EXCEPTION_INVALID_PRECEDING_OR_FOLLOWING_SIZE_IN_WINDOW_FUNCTION`	22013: data exception: invalid preceding or following size in window function
`DATA_EXCEPTION_INVALID_REGULAR_EXPRESSION`	2201B: data exception: invalid regular expression
`DATA_EXCEPTION_INVALID_REPEAT_ARGUMENT_IN_A_SAMPLE_CLAUSE`	2202G: data exception: invalid repeat argument in a sample clause
`DATA_EXCEPTION_INVALID_ROW_COUNT_IN_FETCH_FIRST_CLAUSE`	2201W: data exception: invalid row count in fetch first clause
`DATA_EXCEPTION_INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE`	2201X: data exception: invalid row count in result offset clause
`DATA_EXCEPTION_INVALID_ROW_VERSION`	2201H: data exception: invalid row version
`DATA_EXCEPTION_INVALID_SAMPLE_SIZE`	2202H: data exception: invalid sample size
`DATA_EXCEPTION_INVALID_TIME_ZONE_DISPLACEMENT_VALUE`	22009: data exception: invalid time zone displacement value
`DATA_EXCEPTION_INVALID_USE_OF_ESCAPE_CHARACTER`	2200C: data exception: invalid use of escape character
`DATA_EXCEPTION_INVALID_XQUERY_OPTION_FLAG`	2201T: data exception: invalid XQuery option flag
`DATA_EXCEPTION_INVALID_XQUERY_REGULAR_EXPRESSION`	2201S: data exception: invalid XQuery regular expression
`DATA_EXCEPTION_INVALID_XQUERY_REPLACEMENT_STRING`	2201V: data exception: invalid XQuery replacement string
`DATA_EXCEPTION_MOST_SPECIFIC_TYPE_MISMATCH`	2200G: data exception: most specific type mismatch
`DATA_EXCEPTION_MULTISET_VALUE_OVERFLOW`	2200Q: data exception: multiset value overflow
`DATA_EXCEPTION_NO_SUBCLASS`	22000: data exception
`DATA_EXCEPTION_NONCHARACTER_IN_UCS_STRING`	22029: data exception: noncharacter in UCS string
`DATA_EXCEPTION_NULL_ROW_NOT_PERMITTED_IN_TABLE`	2201C: data exception: null row not permitted in table
`DATA_EXCEPTION_NULL_VALUE_IN_ARRAY_TARGET`	2200E: data exception: null value in array target
`DATA_EXCEPTION_NULL_VALUE_NO_INDICATOR_PARAMETER`	22002: data exception: null value, no indicator parameter
`DATA_EXCEPTION_NULL_VALUE_NOT_ALLOWED`	22004: data exception: null value not allowed
`DATA_EXCEPTION_NULL_VALUE_SUBSTITUTED_FOR_MUTATOR_SUBJECT_PARAMETER`	2202D: data exception: null value substituted for mutator subject parameter
`DATA_EXCEPTION_NUMERIC_VALUE_OUT_OF_RANGE`	22003: data exception: numeric value out of range
`DATA_EXCEPTION_SEQUENCE_GENERATOR_LIMIT_EXCEEDED`	2200H: data exception: sequence generator limit exceeded
`DATA_EXCEPTION_SKIP_TO_FIRST_ROW_OF_MATCH`	2202L: data exception: skip to first row of match
`DATA_EXCEPTION_SKIP_TO_NON_EXISTENT_ROW`	2202K: data exception: skip to non-existent row
`DATA_EXCEPTION_STRING_DATA_LENGTH_MISMATCH`	22026: data exception: string data, length mismatch
`DATA_EXCEPTION_STRING_DATA_RIGHT_TRUNCATION`	22001: data exception: string data, right truncation
`DATA_EXCEPTION_SUBSTRING_ERROR`	22011: data exception: substring error
`DATA_EXCEPTION_TRIM_ERROR`	22027: data exception: trim error
`DATA_EXCEPTION_UNTERMINATED_C_STRING`	22024: data exception: unterminated C string
`DATA_EXCEPTION_ZERO_LENGTH_CHARACTER_STRING`	2200F: data exception: zero-length character string
`DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST_NO_SUBCLASS`	2B000: dependent privilege descriptors still exist
`DIAGNOSTICS_EXCEPTION_MAXIMUM_NUMBER_OF_DIAGNOSTICS_AREAS_EXCEEDED`	0Z001: diagnostics exception: maximum number of stacked diagnostics areas exceeded
`DIAGNOSTICS_EXCEPTION_NO_SUBCLASS`	0Z000: diagnostics exception
`DYNAMIC_SQL_ERROR_CURSOR_SPECIFICATION_CANNOT_BE_EXECUTED`	07003: dynamic SQL error: cursor specification cannot be executed
`DYNAMIC_SQL_ERROR_DATA_TYPE_TRANSFORM_FUNCTION_VIOLATION`	0700B: dynamic SQL error: data type transform function violation
`DYNAMIC_SQL_ERROR_INVALID_DATA_TARGET`	0700D: dynamic SQL error: invalid DATA target
`DYNAMIC_SQL_ERROR_INVALID_DATETIME_INTERVAL_CODE`	0700F: dynamic SQL error: invalid DATETIME_INTERVAL_CODE
`DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_COUNT`	07008: dynamic SQL error: invalid descriptor count
`DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_INDEX`	07009: dynamic SQL error: invalid descriptor index
`DYNAMIC_SQL_ERROR_INVALID_LEVEL_VALUE`	0700E: dynamic SQL error: invalid LEVEL value
`DYNAMIC_SQL_ERROR_NO_SUBCLASS`	07000: dynamic SQL error
`DYNAMIC_SQL_ERROR_PREPARED_STATEMENT_NOT_A_CURSOR_SPECIFICATION`	07005: dynamic SQL error: prepared statement not a cursor specification
`DYNAMIC_SQL_ERROR_RESTRICTED_DATA_TYPE_ATTRIBUTE_VIOLATION`	07006: dynamic SQL error: restricted data type attribute violation
`DYNAMIC_SQL_ERROR_UNDEFINED_DATA_VALUE`	0700C: dynamic SQL error: undefined DATA value
`DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_DYNAMIC_PARAMETER_SPEC`	07001: dynamic SQL error: using clause does not match dynamic parameter specifications
`DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_TARGET_SPEC`	07002: dynamic SQL error: using clause does not match target specifications
`DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_DYNAMIC_PARAMETERS`	07004: dynamic SQL error: using clause required for dynamic parameters
`DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_RESULT_FIELDS`	07007: dynamic SQL error: using clause required for result fields
`EXTERNAL_ROUTINE_EXCEPTION_CONTAINING_SQL_NOT_PERMITTED`	38001: external routine exception: containing SQL not permitted
`EXTERNAL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED`	38002: external routine exception: modifying SQL-data not permitted
`EXTERNAL_ROUTINE_EXCEPTION_NO_SUBCLASS`	38000: external routine exception
`EXTERNAL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED`	38003: external routine exception: prohibited SQL-statement attempted
`EXTERNAL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED`	38004: external routine exception: reading SQL-data not permitted
`EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NO_SUBCLASS`	39000: external routine invocation exception
`EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NULL_VALUE_NOT_ALLOWED`	39004: external routine invocation exception: null value not allowed
`FEATURE_NOT_SUPPORTED_MULTIPLE_ENVIRONMENT_TRANSACTIONS`	0A001: feature not supported: multiple server transactions
`FEATURE_NOT_SUPPORTED_NO_SUBCLASS`	0A000: feature not supported
`INTEGRITY_CONSTRAINT_VIOLATION_NO_SUBCLASS`	23000: integrity constraint violation
`INTEGRITY_CONSTRAINT_VIOLATION_RESTRICT_VIOLATION`	23001: integrity constraint violation: restrict violation
`INVALID_AUTHORIZATION_SPECIFICATION_NO_SUBCLASS`	28000: invalid authorization specification
`INVALID_CATALOG_NAME_NO_SUBCLASS`	3D000: invalid catalog name
`INVALID_CHARACTER_SET_NAME_CANNOT_DROP_SQLSESSION_DEFAULT_CHARACTER_SET`	2C001: invalid character set name: cannot drop SQL-session default character set
`INVALID_CHARACTER_SET_NAME_NO_SUBCLASS`	2C000: invalid character set name
`INVALID_COLLATION_NAME_NO_SUBCLASS`	2H000: invalid collation name
`INVALID_CONDITION_NUMBER_NO_SUBCLASS`	35000: invalid condition number
`INVALID_CONNECTION_NAME_NO_SUBCLASS`	2E000: invalid connection name
`INVALID_CURSOR_NAME_NO_SUBCLASS`	34000: invalid cursor name
`INVALID_CURSOR_STATE_NO_SUBCLASS`	24000: invalid cursor state
`INVALID_GRANTOR_STATE_NO_SUBCLASS`	0L000: invalid grantor
`INVALID_ROLE_SPECIFICATION`	0P000: invalid role specification
`INVALID_SCHEMA_NAME_LIST_SPECIFICATION_NO_SUBCLASS`	0E000: invalid schema name list specification
`INVALID_SCHEMA_NAME_NO_SUBCLASS`	3F000: invalid schema name
`INVALID_SQL_DESCRIPTOR_NAME_NO_SUBCLASS`	33000: invalid SQL descriptor name
`INVALID_SQL_INVOKED_PROCEDURE_REFERENCE_NO_SUBCLASS`	0M000: invalid SQL-invoked procedure reference
`INVALID_SQL_STATEMENT_IDENTIFIER_NO_SUBCLASS`	30000: invalid SQL statement identifier
`INVALID_SQL_STATEMENT_NAME_NO_SUBCLASS`	26000: invalid SQL statement name
`INVALID_TARGET_TYPE_SPECIFICATION_NO_SUBCLASS`	0D000: invalid target type specification
`INVALID_TRANSACTION_STATE_ACTIVE_SQL_TRANSACTION`	25001: invalid transaction state: active SQL-transaction
`INVALID_TRANSACTION_STATE_BRANCH_TRANSACTION_ALREADY_ACTIVE`	25002: invalid transaction state: branch transaction already active
`INVALID_TRANSACTION_STATE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL`	25008: invalid transaction state: held cursor requires same isolation level
`INVALID_TRANSACTION_STATE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION`	25003: invalid transaction state: inappropriate access mode for branch transaction
`INVALID_TRANSACTION_STATE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION`	25004: invalid transaction state: inappropriate isolation level for branch transaction
`INVALID_TRANSACTION_STATE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION`	25005: invalid transaction state: no active SQL-transaction for branch transaction
`INVALID_TRANSACTION_STATE_NO_SUBCLASS`	25000: invalid transaction state
`INVALID_TRANSACTION_STATE_READ_ONLY_SQL_TRANSACTION`	25006: invalid transaction state: read-only SQL-transaction
`INVALID_TRANSACTION_STATE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED`	25007: invalid transaction state: schema and data statement mixing not supported
`INVALID_TRANSACTION_TERMINATION_NO_SUBCLASS`	2D000: invalid transaction termination
`INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION_NO_SUBCLASS`	0S000: invalid transform group name specification
`LOCATOR_EXCEPTION_INVALID_SPECIFICATION`	0F001: locator exception: invalid specification
`LOCATOR_EXCEPTION_NO_SUBCLASS`	0F000: locator exception
`NO_DATA_NO_ADDITIONAL_RESULT_SETS_RETURNED`	02001: no data: no additional result sets returned
`NO_DATA_NO_SUBCLASS`	02000: no data
`PROHIBITED_STATEMENT_DURING_TRIGGER_EXECUTION_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE`	0W001: prohibited statement encountered during trigger execution: modify table modified by data change delta table
`PROHIBITED_STATEMENT_DURING_TRIGGER_EXECUTION_NO_SUBCLASS`	0W000: prohibited statement encountered during trigger execution
`REMOTE_DATABASE_ACCESS_NO_SUBCLASS`	HZ: Remote Database Access
`SAVEPOINT_EXCEPTION_INVALID_SPECIFICATION`	3B001: savepoint exception: invalid specification
`SAVEPOINT_EXCEPTION_NO_SUBCLASS`	3B000: savepoint exception
`SAVEPOINT_EXCEPTION_TOO_MANY`	3B002: savepoint exception: too many
`SQL_ROUTINE_EXCEPTION_FUNCTION_EXECUTED_NO_RETURN_STATEMENT`	2F005: SQL routine exception: function executed no return statement
`SQL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED`	2F002: SQL routine exception: modifying SQL-data not permitted
`SQL_ROUTINE_EXCEPTION_NO_SUBCLASS`	2F000: SQL routine exception
`SQL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED`	2F003: SQL routine exception: prohibited SQL-statement attempted
`SQL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED`	2F004: SQL routine exception: reading SQL-data not permitted
`SUCCESSFUL_COMPLETION_NO_SUBCLASS`	00000: successful completion
`SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DIRECT_STATEMENT_NO_SUBCLASS`	2A000: syntax error or access rule violation
`SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DYNAMIC_STATEMENT_NO_SUBCLASS`	37000: syntax error or access rule violation
`SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_NO_SUBCLASS`	42000: syntax error or access rule violation
`TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION_NO_SUBCLASS`	0T000: target table disagrees with cursor specification
`TRANSACTION_ROLLBACK_INTEGRITY_CONSTRAINT_VIOLATION`	40002: transaction rollback: integrity constraint violation
`TRANSACTION_ROLLBACK_NO_SUBCLASS`	40000: transaction rollback
`TRANSACTION_ROLLBACK_SERIALIZATION_FAILURE`	40001: transaction rollback: serialization failure
`TRANSACTION_ROLLBACK_STATEMENT_COMPLETION_UNKNOWN`	40003: transaction rollback: statement completion unknown
`TRANSACTION_ROLLBACK_TRIGGERED_ACTION_EXCEPTION`	40004: transaction rollback: triggered action exception
`TRIGGERED_ACTION_EXCEPTION_NO_SUBCLASS`	09000: triggered action exception
`TRIGGERED_DATA_CHANGE_VIOLATION_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE`	27001: triggered data change violation: modify table modified by data change delta table
`TRIGGERED_DATA_CHANGE_VIOLATION_NO_SUBCLASS`	27000: triggered data change violation
`WARNING_ADDITIONAL_RESULT_SETS_RETURNED`	0100D: warning: additional result sets returned
`WARNING_ARRAY_DATA_RIGHT_TRUNCATION`	0102F: warning: array data, right truncation
`WARNING_ATTEMPT_TO_RETURN_TOO_MANY_RESULT_SETS`	0100E: warning: attempt to return too many result sets
`WARNING_CURSOR_OPERATION_CONFLICT`	01001: warning: cursor operation conflict
`WARNING_DEFAULT_VALUE_TOO_LONG_FOR_INFORMATION_SCHEMA`	0100B: warning: default value too long for information schema
`WARNING_DISCONNECT_ERROR`	01002: warning: disconnect error
`WARNING_DYNAMIC_RESULT_SETS_RETURNED`	0100C: warning: result sets returned
`WARNING_INSUFFICIENT_ITEM_DESCRIPTOR_AREAS`	01005: warning: insufficient item descriptor areas
`WARNING_INVALID_NUMBER_OF_CONDITIONS`	01012: warning: invalid number of conditions
`WARNING_NO_SUBCLASS`	01000: warning
`WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION`	01003: warning: null value eliminated in set function
`WARNING_PRIVILEGE_NOT_GRANTED`	01007: warning: privilege not granted
`WARNING_PRIVILEGE_NOT_REVOKED`	01006: warning: privilege not revoked
`WARNING_QUERY_EXPRESSION_TOO_LONG_FOR_INFORMATION_SCHEMA`	0100A: warning: query expression too long for information schema
`WARNING_SEARCH_CONDITION_TOO_LONG_FOR_INFORMATION_SCHEMA`	01009: warning: search condition too long for information schema
`WARNING_STATEMENT_TOO_LONG_FOR_INFORMATION_SCHEMA`	0100F: warning: statement too long for information schema
`WARNING_STRING_DATA_RIGHT_TRUNCATION_WARNING`	01004: warning: string data, right truncation
`WITH_CHECK_OPTION_VIOLATION_NO_SUBCLASS`	44000: with check option violation

Field Summary

Fields
Modifier and Type	Field	Description
`static java.util.Map<java.lang.String,SqlState>`	`BY_CODE`
`SqlState.Category`	`category`
`java.lang.String`	`code`
`java.lang.String`	`condition`
`static SqlState`	`INVALID_SQL_STATEMENT`	Alias for backwards compatibility with previous versions of SQL spec.
`java.lang.String`	`klass`
`java.lang.String`	`subClass`
`java.lang.String`	`subCondition`

Constructor Summary

Constructors
Modifier	Constructor	Description
`private`	`SqlState(SqlState.Category category, java.lang.String condition, java.lang.String klass, java.lang.String subCondition, java.lang.String subClass)`

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method	Description
`private static void`	`main(java.lang.String[] args)`	Validates the data, and generates the HTML table.
`static SqlState`	`valueOf(java.lang.String name)`	Returns the enum constant of this type with the specified name.
`static SqlState[]`	`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
  - AMBIGUOUS_CURSOR_NAME_NO_SUBCLASS
```
public static final SqlState AMBIGUOUS_CURSOR_NAME_NO_SUBCLASS
```
    3C000: ambiguous cursor name
  - ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN_NO_SUBCLASS
```
public static final SqlState ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN_NO_SUBCLASS
```
    0U000: attempt to assign to non-updatable column
  - ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN_NO_SUBCLASS
```
public static final SqlState ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN_NO_SUBCLASS
```
    0V000: attempt to assign to ordering column
  - CLI_SPECIFIC_CONDITION_NO_SUBCLASS
```
public static final SqlState CLI_SPECIFIC_CONDITION_NO_SUBCLASS
```
    HY000: cli specific condition
  - CARDINALITY_VIOLATION_NO_SUBCLASS
```
public static final SqlState CARDINALITY_VIOLATION_NO_SUBCLASS
```
    21000: cardinality violation
  - CONNECTION_EXCEPTION_NO_SUBCLASS
```
public static final SqlState CONNECTION_EXCEPTION_NO_SUBCLASS
```
    08000: connection exception
  - CONNECTION_EXCEPTION_CONNECTION_DOES_NOT_EXIST
```
public static final SqlState CONNECTION_EXCEPTION_CONNECTION_DOES_NOT_EXIST
```
    08003: connection exception: connection does not exist
  - CONNECTION_EXCEPTION_CONNECTION_FAILURE
```
public static final SqlState CONNECTION_EXCEPTION_CONNECTION_FAILURE
```
    08006: connection exception: connection failure
  - CONNECTION_EXCEPTION_CONNECTION_NAME_IN_USE
```
public static final SqlState CONNECTION_EXCEPTION_CONNECTION_NAME_IN_USE
```
    08002: connection exception: connection name in use
  - CONNECTION_EXCEPTION_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION
```
public static final SqlState CONNECTION_EXCEPTION_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION
```
    08001: connection exception: SQL-client unable to establish SQL-connection
  - CONNECTION_EXCEPTION_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION
```
public static final SqlState CONNECTION_EXCEPTION_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION
```
    08004: connection exception: SQL-server rejected establishment of SQL-connection
  - CONNECTION_EXCEPTION_TRANSACTION_RESOLUTION_UNKNOWN
```
public static final SqlState CONNECTION_EXCEPTION_TRANSACTION_RESOLUTION_UNKNOWN
```
    08007: connection exception: transaction resolution unknown
  - CURSOR_SENSITIVITY_EXCEPTION_NO_SUBCLASS
```
public static final SqlState CURSOR_SENSITIVITY_EXCEPTION_NO_SUBCLASS
```
    36000: cursor sensitivity exception
  - CURSOR_SENSITIVITY_EXCEPTION_REQUEST_FAILED
```
public static final SqlState CURSOR_SENSITIVITY_EXCEPTION_REQUEST_FAILED
```
    36002: cursor sensitivity exception: request failed
  - CURSOR_SENSITIVITY_EXCEPTION_REQUEST_REJECTED
```
public static final SqlState CURSOR_SENSITIVITY_EXCEPTION_REQUEST_REJECTED
```
    36001: cursor sensitivity exception: request rejected
  - DATA_EXCEPTION_NO_SUBCLASS
```
public static final SqlState DATA_EXCEPTION_NO_SUBCLASS
```
    22000: data exception
  - DATA_EXCEPTION_ARRAY_DATA_RIGHT_TRUNCATION
```
public static final SqlState DATA_EXCEPTION_ARRAY_DATA_RIGHT_TRUNCATION
```
    2202F: data exception: array data, right truncation
  - DATA_EXCEPTION_ARRAY_ELEMENT_ERROR
```
public static final SqlState DATA_EXCEPTION_ARRAY_ELEMENT_ERROR
```
    2202E: data exception: array element error
  - DATA_EXCEPTION_ATTEMPT_TO_REPLACE_A_ZERO_LENGTH_STRING
```
public static final SqlState DATA_EXCEPTION_ATTEMPT_TO_REPLACE_A_ZERO_LENGTH_STRING
```
    2201U: data exception: attempt to replace a zero-length string
  - DATA_EXCEPTION_CHARACTER_NOT_IN_REPERTOIRE
```
public static final SqlState DATA_EXCEPTION_CHARACTER_NOT_IN_REPERTOIRE
```
    22021: data exception: character not in repertoire
  - DATA_EXCEPTION_DATETIME_FIELD_OVERFLOW
```
public static final SqlState DATA_EXCEPTION_DATETIME_FIELD_OVERFLOW
```
    22008: data exception: datetime field overflow
  - DATA_EXCEPTION_DIVISION_BY_ZERO
```
public static final SqlState DATA_EXCEPTION_DIVISION_BY_ZERO
```
    22012: data exception: division by zero
  - DATA_EXCEPTION_ERROR_IN_ASSIGNMENT
```
public static final SqlState DATA_EXCEPTION_ERROR_IN_ASSIGNMENT
```
    22005: data exception: error in assignment
  - DATA_EXCEPTION_ESCAPE_CHARACTER_CONFLICT
```
public static final SqlState DATA_EXCEPTION_ESCAPE_CHARACTER_CONFLICT
```
    2200B: data exception: escape character conflict
  - DATA_EXCEPTION_INDICATOR_OVERFLOW
```
public static final SqlState DATA_EXCEPTION_INDICATOR_OVERFLOW
```
    22022: data exception: indicator overflow
  - DATA_EXCEPTION_INTERVAL_FIELD_OVERFLOW
```
public static final SqlState DATA_EXCEPTION_INTERVAL_FIELD_OVERFLOW
```
    22015: data exception: interval field overflow
  - DATA_EXCEPTION_INTERVAL_VALUE_OUT_OF_RANGE
```
public static final SqlState DATA_EXCEPTION_INTERVAL_VALUE_OUT_OF_RANGE
```
    2200P: data exception: interval value out of range
  - DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NATURAL_LOGARITHM
```
public static final SqlState DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NATURAL_LOGARITHM
```
    2201E: data exception: invalid argument for natural logarithm
  - DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NTILE_FUNCTION
```
public static final SqlState DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NTILE_FUNCTION
```
    22014: data exception: invalid argument for NTILE function
  - DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION
```
public static final SqlState DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION
```
    22016: data exception: invalid argument for NTH_VALUE function
  - DATA_EXCEPTION_INVALID_ARGUMENT_FOR_POWER_FUNCTION
```
public static final SqlState DATA_EXCEPTION_INVALID_ARGUMENT_FOR_POWER_FUNCTION
```
    2201F: data exception: invalid argument for power function
  - DATA_EXCEPTION_INVALID_ARGUMENT_FOR_ROW_PATTERN_NAVIGATION_OPERATION
```
public static final SqlState DATA_EXCEPTION_INVALID_ARGUMENT_FOR_ROW_PATTERN_NAVIGATION_OPERATION
```
    2202J: data exception: invalid argument for row pattern navigation operation
  - DATA_EXCEPTION_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION
```
public static final SqlState DATA_EXCEPTION_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION
```
    2201G: data exception: invalid argument for width bucket function
  - DATA_EXCEPTION_INVALID_CHARACTER_VALUE_FOR_CAST
```
public static final SqlState DATA_EXCEPTION_INVALID_CHARACTER_VALUE_FOR_CAST
```
    22018: data exception: invalid character value for cast
  - DATA_EXCEPTION_INVALID_DATETIME_FORMAT
```
public static final SqlState DATA_EXCEPTION_INVALID_DATETIME_FORMAT
```
    22007: data exception: invalid datetime format
  - DATA_EXCEPTION_INVALID_ESCAPE_CHARACTER
```
public static final SqlState DATA_EXCEPTION_INVALID_ESCAPE_CHARACTER
```
    22019: data exception: invalid escape character
  - DATA_EXCEPTION_INVALID_ESCAPE_OCTET
```
public static final SqlState DATA_EXCEPTION_INVALID_ESCAPE_OCTET
```
    2200D: data exception: invalid escape octet
  - DATA_EXCEPTION_INVALID_ESCAPE_SEQUENCE
```
public static final SqlState DATA_EXCEPTION_INVALID_ESCAPE_SEQUENCE
```
    22025: data exception: invalid escape sequence
  - DATA_EXCEPTION_INVALID_INDICATOR_PARAMETER_VALUE
```
public static final SqlState DATA_EXCEPTION_INVALID_INDICATOR_PARAMETER_VALUE
```
    22010: data exception: invalid indicator parameter value
  - DATA_EXCEPTION_INVALID_INTERVAL_FORMAT
```
public static final SqlState DATA_EXCEPTION_INVALID_INTERVAL_FORMAT
```
    22006: data exception: invalid interval format
  - DATA_EXCEPTION_INVALID_PARAMETER_VALUE
```
public static final SqlState DATA_EXCEPTION_INVALID_PARAMETER_VALUE
```
    22023: data exception: invalid parameter value
  - DATA_EXCEPTION_INVALID_PERIOD_VALUE
```
public static final SqlState DATA_EXCEPTION_INVALID_PERIOD_VALUE
```
    22020: data exception: invalid period value
  - DATA_EXCEPTION_INVALID_PRECEDING_OR_FOLLOWING_SIZE_IN_WINDOW_FUNCTION
```
public static final SqlState DATA_EXCEPTION_INVALID_PRECEDING_OR_FOLLOWING_SIZE_IN_WINDOW_FUNCTION
```
    22013: data exception: invalid preceding or following size in window function
  - DATA_EXCEPTION_INVALID_REGULAR_EXPRESSION
```
public static final SqlState DATA_EXCEPTION_INVALID_REGULAR_EXPRESSION
```
    2201B: data exception: invalid regular expression
  - DATA_EXCEPTION_INVALID_REPEAT_ARGUMENT_IN_A_SAMPLE_CLAUSE
```
public static final SqlState DATA_EXCEPTION_INVALID_REPEAT_ARGUMENT_IN_A_SAMPLE_CLAUSE
```
    2202G: data exception: invalid repeat argument in a sample clause
  - DATA_EXCEPTION_INVALID_ROW_COUNT_IN_FETCH_FIRST_CLAUSE
```
public static final SqlState DATA_EXCEPTION_INVALID_ROW_COUNT_IN_FETCH_FIRST_CLAUSE
```
    2201W: data exception: invalid row count in fetch first clause
  - DATA_EXCEPTION_INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE
```
public static final SqlState DATA_EXCEPTION_INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE
```
    2201X: data exception: invalid row count in result offset clause
  - DATA_EXCEPTION_INVALID_ROW_VERSION
```
public static final SqlState DATA_EXCEPTION_INVALID_ROW_VERSION
```
    2201H: data exception: invalid row version
  - DATA_EXCEPTION_INVALID_SAMPLE_SIZE
```
public static final SqlState DATA_EXCEPTION_INVALID_SAMPLE_SIZE
```
    2202H: data exception: invalid sample size
  - DATA_EXCEPTION_INVALID_TIME_ZONE_DISPLACEMENT_VALUE
```
public static final SqlState DATA_EXCEPTION_INVALID_TIME_ZONE_DISPLACEMENT_VALUE
```
    22009: data exception: invalid time zone displacement value
  - DATA_EXCEPTION_INVALID_USE_OF_ESCAPE_CHARACTER
```
public static final SqlState DATA_EXCEPTION_INVALID_USE_OF_ESCAPE_CHARACTER
```
    2200C: data exception: invalid use of escape character
  - DATA_EXCEPTION_INVALID_XQUERY_OPTION_FLAG
```
public static final SqlState DATA_EXCEPTION_INVALID_XQUERY_OPTION_FLAG
```
    2201T: data exception: invalid XQuery option flag
  - DATA_EXCEPTION_INVALID_XQUERY_REGULAR_EXPRESSION
```
public static final SqlState DATA_EXCEPTION_INVALID_XQUERY_REGULAR_EXPRESSION
```
    2201S: data exception: invalid XQuery regular expression
  - DATA_EXCEPTION_INVALID_XQUERY_REPLACEMENT_STRING
```
public static final SqlState DATA_EXCEPTION_INVALID_XQUERY_REPLACEMENT_STRING
```
    2201V: data exception: invalid XQuery replacement string
  - DATA_EXCEPTION_MOST_SPECIFIC_TYPE_MISMATCH
```
public static final SqlState DATA_EXCEPTION_MOST_SPECIFIC_TYPE_MISMATCH
```
    2200G: data exception: most specific type mismatch
  - DATA_EXCEPTION_MULTISET_VALUE_OVERFLOW
```
public static final SqlState DATA_EXCEPTION_MULTISET_VALUE_OVERFLOW
```
    2200Q: data exception: multiset value overflow
  - DATA_EXCEPTION_NONCHARACTER_IN_UCS_STRING
```
public static final SqlState DATA_EXCEPTION_NONCHARACTER_IN_UCS_STRING
```
    22029: data exception: noncharacter in UCS string
  - DATA_EXCEPTION_NULL_VALUE_SUBSTITUTED_FOR_MUTATOR_SUBJECT_PARAMETER
```
public static final SqlState DATA_EXCEPTION_NULL_VALUE_SUBSTITUTED_FOR_MUTATOR_SUBJECT_PARAMETER
```
    2202D: data exception: null value substituted for mutator subject parameter
  - DATA_EXCEPTION_NULL_ROW_NOT_PERMITTED_IN_TABLE
```
public static final SqlState DATA_EXCEPTION_NULL_ROW_NOT_PERMITTED_IN_TABLE
```
    2201C: data exception: null row not permitted in table
  - DATA_EXCEPTION_NULL_VALUE_IN_ARRAY_TARGET
```
public static final SqlState DATA_EXCEPTION_NULL_VALUE_IN_ARRAY_TARGET
```
    2200E: data exception: null value in array target
  - DATA_EXCEPTION_NULL_VALUE_NO_INDICATOR_PARAMETER
```
public static final SqlState DATA_EXCEPTION_NULL_VALUE_NO_INDICATOR_PARAMETER
```
    22002: data exception: null value, no indicator parameter
  - DATA_EXCEPTION_NULL_VALUE_NOT_ALLOWED
```
public static final SqlState DATA_EXCEPTION_NULL_VALUE_NOT_ALLOWED
```
    22004: data exception: null value not allowed
  - DATA_EXCEPTION_NUMERIC_VALUE_OUT_OF_RANGE
```
public static final SqlState DATA_EXCEPTION_NUMERIC_VALUE_OUT_OF_RANGE
```
    22003: data exception: numeric value out of range
  - DATA_EXCEPTION_SEQUENCE_GENERATOR_LIMIT_EXCEEDED
```
public static final SqlState DATA_EXCEPTION_SEQUENCE_GENERATOR_LIMIT_EXCEEDED
```
    2200H: data exception: sequence generator limit exceeded
  - DATA_EXCEPTION_SKIP_TO_NON_EXISTENT_ROW
```
public static final SqlState DATA_EXCEPTION_SKIP_TO_NON_EXISTENT_ROW
```
    2202K: data exception: skip to non-existent row
  - DATA_EXCEPTION_SKIP_TO_FIRST_ROW_OF_MATCH
```
public static final SqlState DATA_EXCEPTION_SKIP_TO_FIRST_ROW_OF_MATCH
```
    2202L: data exception: skip to first row of match
  - DATA_EXCEPTION_STRING_DATA_LENGTH_MISMATCH
```
public static final SqlState DATA_EXCEPTION_STRING_DATA_LENGTH_MISMATCH
```
    22026: data exception: string data, length mismatch
  - DATA_EXCEPTION_STRING_DATA_RIGHT_TRUNCATION
```
public static final SqlState DATA_EXCEPTION_STRING_DATA_RIGHT_TRUNCATION
```
    22001: data exception: string data, right truncation
  - DATA_EXCEPTION_SUBSTRING_ERROR
```
public static final SqlState DATA_EXCEPTION_SUBSTRING_ERROR
```
    22011: data exception: substring error
  - DATA_EXCEPTION_TRIM_ERROR
```
public static final SqlState DATA_EXCEPTION_TRIM_ERROR
```
    22027: data exception: trim error
  - DATA_EXCEPTION_UNTERMINATED_C_STRING
```
public static final SqlState DATA_EXCEPTION_UNTERMINATED_C_STRING
```
    22024: data exception: unterminated C string
  - DATA_EXCEPTION_ZERO_LENGTH_CHARACTER_STRING
```
public static final SqlState DATA_EXCEPTION_ZERO_LENGTH_CHARACTER_STRING
```
    2200F: data exception: zero-length character string
  - DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST_NO_SUBCLASS
```
public static final SqlState DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST_NO_SUBCLASS
```
    2B000: dependent privilege descriptors still exist
  - DIAGNOSTICS_EXCEPTION_NO_SUBCLASS
```
public static final SqlState DIAGNOSTICS_EXCEPTION_NO_SUBCLASS
```
    0Z000: diagnostics exception
  - DIAGNOSTICS_EXCEPTION_MAXIMUM_NUMBER_OF_DIAGNOSTICS_AREAS_EXCEEDED
```
public static final SqlState DIAGNOSTICS_EXCEPTION_MAXIMUM_NUMBER_OF_DIAGNOSTICS_AREAS_EXCEEDED
```
    0Z001: diagnostics exception: maximum number of stacked diagnostics areas exceeded
  - DYNAMIC_SQL_ERROR_NO_SUBCLASS
```
public static final SqlState DYNAMIC_SQL_ERROR_NO_SUBCLASS
```
    07000: dynamic SQL error
  - DYNAMIC_SQL_ERROR_CURSOR_SPECIFICATION_CANNOT_BE_EXECUTED
```
public static final SqlState DYNAMIC_SQL_ERROR_CURSOR_SPECIFICATION_CANNOT_BE_EXECUTED
```
    07003: dynamic SQL error: cursor specification cannot be executed
  - DYNAMIC_SQL_ERROR_DATA_TYPE_TRANSFORM_FUNCTION_VIOLATION
```
public static final SqlState DYNAMIC_SQL_ERROR_DATA_TYPE_TRANSFORM_FUNCTION_VIOLATION
```
    0700B: dynamic SQL error: data type transform function violation
  - DYNAMIC_SQL_ERROR_INVALID_DATA_TARGET
```
public static final SqlState DYNAMIC_SQL_ERROR_INVALID_DATA_TARGET
```
    0700D: dynamic SQL error: invalid DATA target
  - DYNAMIC_SQL_ERROR_INVALID_DATETIME_INTERVAL_CODE
```
public static final SqlState DYNAMIC_SQL_ERROR_INVALID_DATETIME_INTERVAL_CODE
```
    0700F: dynamic SQL error: invalid DATETIME_INTERVAL_CODE
  - DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_COUNT
```
public static final SqlState DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_COUNT
```
    07008: dynamic SQL error: invalid descriptor count
  - DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_INDEX
```
public static final SqlState DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_INDEX
```
    07009: dynamic SQL error: invalid descriptor index
  - DYNAMIC_SQL_ERROR_INVALID_LEVEL_VALUE
```
public static final SqlState DYNAMIC_SQL_ERROR_INVALID_LEVEL_VALUE
```
    0700E: dynamic SQL error: invalid LEVEL value
  - DYNAMIC_SQL_ERROR_PREPARED_STATEMENT_NOT_A_CURSOR_SPECIFICATION
```
public static final SqlState DYNAMIC_SQL_ERROR_PREPARED_STATEMENT_NOT_A_CURSOR_SPECIFICATION
```
    07005: dynamic SQL error: prepared statement not a cursor specification
  - DYNAMIC_SQL_ERROR_RESTRICTED_DATA_TYPE_ATTRIBUTE_VIOLATION
```
public static final SqlState DYNAMIC_SQL_ERROR_RESTRICTED_DATA_TYPE_ATTRIBUTE_VIOLATION
```
    07006: dynamic SQL error: restricted data type attribute violation
  - DYNAMIC_SQL_ERROR_UNDEFINED_DATA_VALUE
```
public static final SqlState DYNAMIC_SQL_ERROR_UNDEFINED_DATA_VALUE
```
    0700C: dynamic SQL error: undefined DATA value
  - DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_DYNAMIC_PARAMETER_SPEC
```
public static final SqlState DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_DYNAMIC_PARAMETER_SPEC
```
    07001: dynamic SQL error: using clause does not match dynamic parameter specifications
  - DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_TARGET_SPEC
```
public static final SqlState DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_TARGET_SPEC
```
    07002: dynamic SQL error: using clause does not match target specifications
  - DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_DYNAMIC_PARAMETERS
```
public static final SqlState DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_DYNAMIC_PARAMETERS
```
    07004: dynamic SQL error: using clause required for dynamic parameters
  - DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_RESULT_FIELDS
```
public static final SqlState DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_RESULT_FIELDS
```
    07007: dynamic SQL error: using clause required for result fields
  - EXTERNAL_ROUTINE_EXCEPTION_NO_SUBCLASS
```
public static final SqlState EXTERNAL_ROUTINE_EXCEPTION_NO_SUBCLASS
```
    38000: external routine exception
  - EXTERNAL_ROUTINE_EXCEPTION_CONTAINING_SQL_NOT_PERMITTED
```
public static final SqlState EXTERNAL_ROUTINE_EXCEPTION_CONTAINING_SQL_NOT_PERMITTED
```
    38001: external routine exception: containing SQL not permitted
  - EXTERNAL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED
```
public static final SqlState EXTERNAL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED
```
    38002: external routine exception: modifying SQL-data not permitted
  - EXTERNAL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED
```
public static final SqlState EXTERNAL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED
```
    38003: external routine exception: prohibited SQL-statement attempted
  - EXTERNAL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED
```
public static final SqlState EXTERNAL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED
```
    38004: external routine exception: reading SQL-data not permitted
  - EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NO_SUBCLASS
```
public static final SqlState EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NO_SUBCLASS
```
    39000: external routine invocation exception
  - EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NULL_VALUE_NOT_ALLOWED
```
public static final SqlState EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NULL_VALUE_NOT_ALLOWED
```
    39004: external routine invocation exception: null value not allowed
  - FEATURE_NOT_SUPPORTED_NO_SUBCLASS
```
public static final SqlState FEATURE_NOT_SUPPORTED_NO_SUBCLASS
```
    0A000: feature not supported
  - FEATURE_NOT_SUPPORTED_MULTIPLE_ENVIRONMENT_TRANSACTIONS
```
public static final SqlState FEATURE_NOT_SUPPORTED_MULTIPLE_ENVIRONMENT_TRANSACTIONS
```
    0A001: feature not supported: multiple server transactions
  - INTEGRITY_CONSTRAINT_VIOLATION_NO_SUBCLASS
```
public static final SqlState INTEGRITY_CONSTRAINT_VIOLATION_NO_SUBCLASS
```
    23000: integrity constraint violation
  - INTEGRITY_CONSTRAINT_VIOLATION_RESTRICT_VIOLATION
```
public static final SqlState INTEGRITY_CONSTRAINT_VIOLATION_RESTRICT_VIOLATION
```
    23001: integrity constraint violation: restrict violation
  - INVALID_AUTHORIZATION_SPECIFICATION_NO_SUBCLASS
```
public static final SqlState INVALID_AUTHORIZATION_SPECIFICATION_NO_SUBCLASS
```
    28000: invalid authorization specification
  - INVALID_CATALOG_NAME_NO_SUBCLASS
```
public static final SqlState INVALID_CATALOG_NAME_NO_SUBCLASS
```
    3D000: invalid catalog name
  - INVALID_CHARACTER_SET_NAME_NO_SUBCLASS
```
public static final SqlState INVALID_CHARACTER_SET_NAME_NO_SUBCLASS
```
    2C000: invalid character set name
  - INVALID_CHARACTER_SET_NAME_CANNOT_DROP_SQLSESSION_DEFAULT_CHARACTER_SET
```
public static final SqlState INVALID_CHARACTER_SET_NAME_CANNOT_DROP_SQLSESSION_DEFAULT_CHARACTER_SET
```
    2C001: invalid character set name: cannot drop SQL-session default character set
  - INVALID_CONDITION_NUMBER_NO_SUBCLASS
```
public static final SqlState INVALID_CONDITION_NUMBER_NO_SUBCLASS
```
    35000: invalid condition number
  - INVALID_CONNECTION_NAME_NO_SUBCLASS
```
public static final SqlState INVALID_CONNECTION_NAME_NO_SUBCLASS
```
    2E000: invalid connection name
  - INVALID_CURSOR_NAME_NO_SUBCLASS
```
public static final SqlState INVALID_CURSOR_NAME_NO_SUBCLASS
```
    34000: invalid cursor name
  - INVALID_CURSOR_STATE_NO_SUBCLASS
```
public static final SqlState INVALID_CURSOR_STATE_NO_SUBCLASS
```
    24000: invalid cursor state
  - INVALID_GRANTOR_STATE_NO_SUBCLASS
```
public static final SqlState INVALID_GRANTOR_STATE_NO_SUBCLASS
```
    0L000: invalid grantor
  - INVALID_ROLE_SPECIFICATION
```
public static final SqlState INVALID_ROLE_SPECIFICATION
```
    0P000: invalid role specification
  - INVALID_SCHEMA_NAME_NO_SUBCLASS
```
public static final SqlState INVALID_SCHEMA_NAME_NO_SUBCLASS
```
    3F000: invalid schema name
  - INVALID_SCHEMA_NAME_LIST_SPECIFICATION_NO_SUBCLASS
```
public static final SqlState INVALID_SCHEMA_NAME_LIST_SPECIFICATION_NO_SUBCLASS
```
    0E000: invalid schema name list specification
  - INVALID_COLLATION_NAME_NO_SUBCLASS
```
public static final SqlState INVALID_COLLATION_NAME_NO_SUBCLASS
```
    2H000: invalid collation name
  - INVALID_SQL_DESCRIPTOR_NAME_NO_SUBCLASS
```
public static final SqlState INVALID_SQL_DESCRIPTOR_NAME_NO_SUBCLASS
```
    33000: invalid SQL descriptor name
  - INVALID_SQL_INVOKED_PROCEDURE_REFERENCE_NO_SUBCLASS
```
public static final SqlState INVALID_SQL_INVOKED_PROCEDURE_REFERENCE_NO_SUBCLASS
```
    0M000: invalid SQL-invoked procedure reference
  - INVALID_SQL_STATEMENT_NAME_NO_SUBCLASS
```
public static final SqlState INVALID_SQL_STATEMENT_NAME_NO_SUBCLASS
```
    26000: invalid SQL statement name
  - INVALID_SQL_STATEMENT_IDENTIFIER_NO_SUBCLASS
```
public static final SqlState INVALID_SQL_STATEMENT_IDENTIFIER_NO_SUBCLASS
```
    30000: invalid SQL statement identifier
  - INVALID_TARGET_TYPE_SPECIFICATION_NO_SUBCLASS
```
public static final SqlState INVALID_TARGET_TYPE_SPECIFICATION_NO_SUBCLASS
```
    0D000: invalid target type specification
  - INVALID_TRANSACTION_STATE_NO_SUBCLASS
```
public static final SqlState INVALID_TRANSACTION_STATE_NO_SUBCLASS
```
    25000: invalid transaction state
  - INVALID_TRANSACTION_STATE_ACTIVE_SQL_TRANSACTION
```
public static final SqlState INVALID_TRANSACTION_STATE_ACTIVE_SQL_TRANSACTION
```
    25001: invalid transaction state: active SQL-transaction
  - INVALID_TRANSACTION_STATE_BRANCH_TRANSACTION_ALREADY_ACTIVE
```
public static final SqlState INVALID_TRANSACTION_STATE_BRANCH_TRANSACTION_ALREADY_ACTIVE
```
    25002: invalid transaction state: branch transaction already active
  - INVALID_TRANSACTION_STATE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL
```
public static final SqlState INVALID_TRANSACTION_STATE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL
```
    25008: invalid transaction state: held cursor requires same isolation level
  - INVALID_TRANSACTION_STATE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION
```
public static final SqlState INVALID_TRANSACTION_STATE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION
```
    25003: invalid transaction state: inappropriate access mode for branch transaction
  - INVALID_TRANSACTION_STATE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION
```
public static final SqlState INVALID_TRANSACTION_STATE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION
```
    25004: invalid transaction state: inappropriate isolation level for branch transaction
  - INVALID_TRANSACTION_STATE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION
```
public static final SqlState INVALID_TRANSACTION_STATE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION
```
    25005: invalid transaction state: no active SQL-transaction for branch transaction
  - INVALID_TRANSACTION_STATE_READ_ONLY_SQL_TRANSACTION
```
public static final SqlState INVALID_TRANSACTION_STATE_READ_ONLY_SQL_TRANSACTION
```
    25006: invalid transaction state: read-only SQL-transaction
  - INVALID_TRANSACTION_STATE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED
```
public static final SqlState INVALID_TRANSACTION_STATE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED
```
    25007: invalid transaction state: schema and data statement mixing not supported
  - INVALID_TRANSACTION_TERMINATION_NO_SUBCLASS
```
public static final SqlState INVALID_TRANSACTION_TERMINATION_NO_SUBCLASS
```
    2D000: invalid transaction termination
  - INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION_NO_SUBCLASS
```
public static final SqlState INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION_NO_SUBCLASS
```
    0S000: invalid transform group name specification
  - LOCATOR_EXCEPTION_NO_SUBCLASS
```
public static final SqlState LOCATOR_EXCEPTION_NO_SUBCLASS
```
    0F000: locator exception
  - LOCATOR_EXCEPTION_INVALID_SPECIFICATION
```
public static final SqlState LOCATOR_EXCEPTION_INVALID_SPECIFICATION
```
    0F001: locator exception: invalid specification
  - NO_DATA_NO_SUBCLASS
```
public static final SqlState NO_DATA_NO_SUBCLASS
```
    02000: no data
  - NO_DATA_NO_ADDITIONAL_RESULT_SETS_RETURNED
```
public static final SqlState NO_DATA_NO_ADDITIONAL_RESULT_SETS_RETURNED
```
    02001: no data: no additional result sets returned
  - PROHIBITED_STATEMENT_DURING_TRIGGER_EXECUTION_NO_SUBCLASS
```
public static final SqlState PROHIBITED_STATEMENT_DURING_TRIGGER_EXECUTION_NO_SUBCLASS
```
    0W000: prohibited statement encountered during trigger execution
  - PROHIBITED_STATEMENT_DURING_TRIGGER_EXECUTION_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE
```
public static final SqlState PROHIBITED_STATEMENT_DURING_TRIGGER_EXECUTION_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE
```
    0W001: prohibited statement encountered during trigger execution: modify table modified by data change delta table
  - REMOTE_DATABASE_ACCESS_NO_SUBCLASS
```
public static final SqlState REMOTE_DATABASE_ACCESS_NO_SUBCLASS
```
    HZ: Remote Database Access
    (See Table 12, 'SQLSTATE class and subclass values for RDA-specific conditions' in [ISO9579], Subclause 8.1, 'Exception codes for RDA-specific Conditions', for the definition of protocol subconditions and subclass code values.)
  - SAVEPOINT_EXCEPTION_NO_SUBCLASS
```
public static final SqlState SAVEPOINT_EXCEPTION_NO_SUBCLASS
```
    3B000: savepoint exception
  - SAVEPOINT_EXCEPTION_INVALID_SPECIFICATION
```
public static final SqlState SAVEPOINT_EXCEPTION_INVALID_SPECIFICATION
```
    3B001: savepoint exception: invalid specification
  - SAVEPOINT_EXCEPTION_TOO_MANY
```
public static final SqlState SAVEPOINT_EXCEPTION_TOO_MANY
```
    3B002: savepoint exception: too many
  - SQL_ROUTINE_EXCEPTION_NO_SUBCLASS
```
public static final SqlState SQL_ROUTINE_EXCEPTION_NO_SUBCLASS
```
    2F000: SQL routine exception
  - SQL_ROUTINE_EXCEPTION_FUNCTION_EXECUTED_NO_RETURN_STATEMENT
```
public static final SqlState SQL_ROUTINE_EXCEPTION_FUNCTION_EXECUTED_NO_RETURN_STATEMENT
```
    2F005: SQL routine exception: function executed no return statement
  - SQL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED
```
public static final SqlState SQL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED
```
    2F002: SQL routine exception: modifying SQL-data not permitted
  - SQL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED
```
public static final SqlState SQL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED
```
    2F003: SQL routine exception: prohibited SQL-statement attempted
  - SQL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED
```
public static final SqlState SQL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED
```
    2F004: SQL routine exception: reading SQL-data not permitted
  - SUCCESSFUL_COMPLETION_NO_SUBCLASS
```
public static final SqlState SUCCESSFUL_COMPLETION_NO_SUBCLASS
```
    00000: successful completion
  - SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_NO_SUBCLASS
```
public static final SqlState SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_NO_SUBCLASS
```
    42000: syntax error or access rule violation
  - SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DIRECT_STATEMENT_NO_SUBCLASS
```
public static final SqlState SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DIRECT_STATEMENT_NO_SUBCLASS
```
    2A000: syntax error or access rule violation
  - SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DYNAMIC_STATEMENT_NO_SUBCLASS
```
public static final SqlState SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DYNAMIC_STATEMENT_NO_SUBCLASS
```
    37000: syntax error or access rule violation
  - TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION_NO_SUBCLASS
```
public static final SqlState TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION_NO_SUBCLASS
```
    0T000: target table disagrees with cursor specification
  - TRANSACTION_ROLLBACK_NO_SUBCLASS
```
public static final SqlState TRANSACTION_ROLLBACK_NO_SUBCLASS
```
    40000: transaction rollback
  - TRANSACTION_ROLLBACK_INTEGRITY_CONSTRAINT_VIOLATION
```
public static final SqlState TRANSACTION_ROLLBACK_INTEGRITY_CONSTRAINT_VIOLATION
```
    40002: transaction rollback: integrity constraint violation
  - TRANSACTION_ROLLBACK_SERIALIZATION_FAILURE
```
public static final SqlState TRANSACTION_ROLLBACK_SERIALIZATION_FAILURE
```
    40001: transaction rollback: serialization failure
  - TRANSACTION_ROLLBACK_STATEMENT_COMPLETION_UNKNOWN
```
public static final SqlState TRANSACTION_ROLLBACK_STATEMENT_COMPLETION_UNKNOWN
```
    40003: transaction rollback: statement completion unknown
  - TRANSACTION_ROLLBACK_TRIGGERED_ACTION_EXCEPTION
```
public static final SqlState TRANSACTION_ROLLBACK_TRIGGERED_ACTION_EXCEPTION
```
    40004: transaction rollback: triggered action exception
  - TRIGGERED_ACTION_EXCEPTION_NO_SUBCLASS
```
public static final SqlState TRIGGERED_ACTION_EXCEPTION_NO_SUBCLASS
```
    09000: triggered action exception
  - TRIGGERED_DATA_CHANGE_VIOLATION_NO_SUBCLASS
```
public static final SqlState TRIGGERED_DATA_CHANGE_VIOLATION_NO_SUBCLASS
```
    27000: triggered data change violation
  - TRIGGERED_DATA_CHANGE_VIOLATION_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE
```
public static final SqlState TRIGGERED_DATA_CHANGE_VIOLATION_MODIFY_TABLE_MODIFIED_BY_DATA_CHANGE_DELTA_TABLE
```
    27001: triggered data change violation: modify table modified by data change delta table
  - WARNING_NO_SUBCLASS
```
public static final SqlState WARNING_NO_SUBCLASS
```
    01000: warning
  - WARNING_ADDITIONAL_RESULT_SETS_RETURNED
```
public static final SqlState WARNING_ADDITIONAL_RESULT_SETS_RETURNED
```
    0100D: warning: additional result sets returned
  - WARNING_ARRAY_DATA_RIGHT_TRUNCATION
```
public static final SqlState WARNING_ARRAY_DATA_RIGHT_TRUNCATION
```
    0102F: warning: array data, right truncation
  - WARNING_ATTEMPT_TO_RETURN_TOO_MANY_RESULT_SETS
```
public static final SqlState WARNING_ATTEMPT_TO_RETURN_TOO_MANY_RESULT_SETS
```
    0100E: warning: attempt to return too many result sets
  - WARNING_CURSOR_OPERATION_CONFLICT
```
public static final SqlState WARNING_CURSOR_OPERATION_CONFLICT
```
    01001: warning: cursor operation conflict
  - WARNING_DEFAULT_VALUE_TOO_LONG_FOR_INFORMATION_SCHEMA
```
public static final SqlState WARNING_DEFAULT_VALUE_TOO_LONG_FOR_INFORMATION_SCHEMA
```
    0100B: warning: default value too long for information schema
  - WARNING_DISCONNECT_ERROR
```
public static final SqlState WARNING_DISCONNECT_ERROR
```
    01002: warning: disconnect error
  - WARNING_INSUFFICIENT_ITEM_DESCRIPTOR_AREAS
```
public static final SqlState WARNING_INSUFFICIENT_ITEM_DESCRIPTOR_AREAS
```
    01005: warning: insufficient item descriptor areas
  - WARNING_INVALID_NUMBER_OF_CONDITIONS
```
public static final SqlState WARNING_INVALID_NUMBER_OF_CONDITIONS
```
    01012: warning: invalid number of conditions
  - WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION
```
public static final SqlState WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION
```
    01003: warning: null value eliminated in set function
  - WARNING_PRIVILEGE_NOT_GRANTED
```
public static final SqlState WARNING_PRIVILEGE_NOT_GRANTED
```
    01007: warning: privilege not granted
  - WARNING_PRIVILEGE_NOT_REVOKED
```
public static final SqlState WARNING_PRIVILEGE_NOT_REVOKED
```
    01006: warning: privilege not revoked
  - WARNING_QUERY_EXPRESSION_TOO_LONG_FOR_INFORMATION_SCHEMA
```
public static final SqlState WARNING_QUERY_EXPRESSION_TOO_LONG_FOR_INFORMATION_SCHEMA
```
    0100A: warning: query expression too long for information schema
  - WARNING_DYNAMIC_RESULT_SETS_RETURNED
```
public static final SqlState WARNING_DYNAMIC_RESULT_SETS_RETURNED
```
    0100C: warning: result sets returned
  - WARNING_SEARCH_CONDITION_TOO_LONG_FOR_INFORMATION_SCHEMA
```
public static final SqlState WARNING_SEARCH_CONDITION_TOO_LONG_FOR_INFORMATION_SCHEMA
```
    01009: warning: search condition too long for information schema
  - WARNING_STATEMENT_TOO_LONG_FOR_INFORMATION_SCHEMA
```
public static final SqlState WARNING_STATEMENT_TOO_LONG_FOR_INFORMATION_SCHEMA
```
    0100F: warning: statement too long for information schema
  - WARNING_STRING_DATA_RIGHT_TRUNCATION_WARNING
```
public static final SqlState WARNING_STRING_DATA_RIGHT_TRUNCATION_WARNING
```
    01004: warning: string data, right truncation
  - WITH_CHECK_OPTION_VIOLATION_NO_SUBCLASS
```
public static final SqlState WITH_CHECK_OPTION_VIOLATION_NO_SUBCLASS
```
    44000: with check option violation
- Field Detail
  - category
```
public final SqlState.Category category
```
  - condition
```
public final java.lang.String condition
```
  - klass
```
public final java.lang.String klass
```
  - subCondition
```
public final java.lang.String subCondition
```
  - subClass
```
public final java.lang.String subClass
```
  - code
```
public final java.lang.String code
```
  - INVALID_SQL_STATEMENT
```
public static final SqlState INVALID_SQL_STATEMENT
```
    Alias for backwards compatibility with previous versions of SQL spec.
  - BY_CODE
```
public static final java.util.Map<java.lang.String,SqlState> BY_CODE
```
- Constructor Detail
  - SqlState
```
private SqlState(SqlState.Category category,
                 java.lang.String condition,
                 java.lang.String klass,
                 java.lang.String subCondition,
                 java.lang.String subClass)
```
- Method Detail
  - values
```
public static SqlState[] 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 (SqlState c : SqlState.values()) System.out.println(c);
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static SqlState 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
  - main
```
private static void main(java.lang.String[] args)
```
    Validates the data, and generates the HTML table.

Enum SqlState

Nested Class Summary

Enum Constant Summary

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

AMBIGUOUS_CURSOR_NAME_NO_SUBCLASS

ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN_NO_SUBCLASS

ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN_NO_SUBCLASS

CLI_SPECIFIC_CONDITION_NO_SUBCLASS

CARDINALITY_VIOLATION_NO_SUBCLASS

CONNECTION_EXCEPTION_NO_SUBCLASS

CONNECTION_EXCEPTION_CONNECTION_DOES_NOT_EXIST

CONNECTION_EXCEPTION_CONNECTION_FAILURE

CONNECTION_EXCEPTION_CONNECTION_NAME_IN_USE

CONNECTION_EXCEPTION_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION

CONNECTION_EXCEPTION_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION

CONNECTION_EXCEPTION_TRANSACTION_RESOLUTION_UNKNOWN

CURSOR_SENSITIVITY_EXCEPTION_NO_SUBCLASS

CURSOR_SENSITIVITY_EXCEPTION_REQUEST_FAILED

CURSOR_SENSITIVITY_EXCEPTION_REQUEST_REJECTED

DATA_EXCEPTION_NO_SUBCLASS

DATA_EXCEPTION_ARRAY_DATA_RIGHT_TRUNCATION

DATA_EXCEPTION_ARRAY_ELEMENT_ERROR

DATA_EXCEPTION_ATTEMPT_TO_REPLACE_A_ZERO_LENGTH_STRING

DATA_EXCEPTION_CHARACTER_NOT_IN_REPERTOIRE

DATA_EXCEPTION_DATETIME_FIELD_OVERFLOW

DATA_EXCEPTION_DIVISION_BY_ZERO

DATA_EXCEPTION_ERROR_IN_ASSIGNMENT

DATA_EXCEPTION_ESCAPE_CHARACTER_CONFLICT

DATA_EXCEPTION_INDICATOR_OVERFLOW

DATA_EXCEPTION_INTERVAL_FIELD_OVERFLOW

DATA_EXCEPTION_INTERVAL_VALUE_OUT_OF_RANGE

DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NATURAL_LOGARITHM

DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NTILE_FUNCTION

DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION

DATA_EXCEPTION_INVALID_ARGUMENT_FOR_POWER_FUNCTION

DATA_EXCEPTION_INVALID_ARGUMENT_FOR_ROW_PATTERN_NAVIGATION_OPERATION

DATA_EXCEPTION_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION

DATA_EXCEPTION_INVALID_CHARACTER_VALUE_FOR_CAST

DATA_EXCEPTION_INVALID_DATETIME_FORMAT

DATA_EXCEPTION_INVALID_ESCAPE_CHARACTER

DATA_EXCEPTION_INVALID_ESCAPE_OCTET

DATA_EXCEPTION_INVALID_ESCAPE_SEQUENCE

DATA_EXCEPTION_INVALID_INDICATOR_PARAMETER_VALUE

DATA_EXCEPTION_INVALID_INTERVAL_FORMAT

DATA_EXCEPTION_INVALID_PARAMETER_VALUE

DATA_EXCEPTION_INVALID_PERIOD_VALUE

DATA_EXCEPTION_INVALID_PRECEDING_OR_FOLLOWING_SIZE_IN_WINDOW_FUNCTION

DATA_EXCEPTION_INVALID_REGULAR_EXPRESSION

DATA_EXCEPTION_INVALID_REPEAT_ARGUMENT_IN_A_SAMPLE_CLAUSE

DATA_EXCEPTION_INVALID_ROW_COUNT_IN_FETCH_FIRST_CLAUSE

DATA_EXCEPTION_INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE

DATA_EXCEPTION_INVALID_ROW_VERSION

DATA_EXCEPTION_INVALID_SAMPLE_SIZE

DATA_EXCEPTION_INVALID_TIME_ZONE_DISPLACEMENT_VALUE

DATA_EXCEPTION_INVALID_USE_OF_ESCAPE_CHARACTER

DATA_EXCEPTION_INVALID_XQUERY_OPTION_FLAG

DATA_EXCEPTION_INVALID_XQUERY_REGULAR_EXPRESSION

DATA_EXCEPTION_INVALID_XQUERY_REPLACEMENT_STRING

DATA_EXCEPTION_MOST_SPECIFIC_TYPE_MISMATCH

DATA_EXCEPTION_MULTISET_VALUE_OVERFLOW

DATA_EXCEPTION_NONCHARACTER_IN_UCS_STRING

DATA_EXCEPTION_NULL_VALUE_SUBSTITUTED_FOR_MUTATOR_SUBJECT_PARAMETER

DATA_EXCEPTION_NULL_ROW_NOT_PERMITTED_IN_TABLE

DATA_EXCEPTION_NULL_VALUE_IN_ARRAY_TARGET

DATA_EXCEPTION_NULL_VALUE_NO_INDICATOR_PARAMETER

DATA_EXCEPTION_NULL_VALUE_NOT_ALLOWED

DATA_EXCEPTION_NUMERIC_VALUE_OUT_OF_RANGE

DATA_EXCEPTION_SEQUENCE_GENERATOR_LIMIT_EXCEEDED

DATA_EXCEPTION_SKIP_TO_NON_EXISTENT_ROW

DATA_EXCEPTION_SKIP_TO_FIRST_ROW_OF_MATCH

DATA_EXCEPTION_STRING_DATA_LENGTH_MISMATCH

DATA_EXCEPTION_STRING_DATA_RIGHT_TRUNCATION

DATA_EXCEPTION_SUBSTRING_ERROR

DATA_EXCEPTION_TRIM_ERROR

DATA_EXCEPTION_UNTERMINATED_C_STRING