{ error message (possibly translated; may include quoted data) }
{ error message in English if different }
{ SQL statement if applicable }
{ [ error code - build number ] }
Example:
Syntax error in SQL statement "SELECT * FORM[*] TEST "; SQL statement: select * form test [42000-125]The [*] marks the position of the syntax error (FORM instead of FROM in this case). The error code is 42000, and the build number is 125, meaning version 1.2.125.
| Modifier and Type | Field and Description |
|---|---|
| public static final int | ACCESS_DENIED_TO_CLASS_1
The error with code |
| public static final int | ADMIN_RIGHTS_REQUIRED
The error with code |
| public static final int | AGGREGATE_NOT_FOUND_1
The error with code |
| public static final int | AMBIGUOUS_COLUMN_NAME_1
The error with code |
| public static final int | ARRAY_ELEMENT_ERROR_2
The error with code |
| public static final int | AUTHENTICATOR_NOT_AVAILABLE
The error with code Authenticator experimental feature can be enabled by SET AUTHENTICATOR TRUE |
| public static final int | CAN_ONLY_ASSIGN_TO_VARIABLE_1
The error with code |
| public static final int | CANNOT_CHANGE_SETTING_WHEN_OPEN_1
The error with code |
| public static final int | CANNOT_DROP_2
The error with code |
| public static final int | CANNOT_DROP_CURRENT_USER
The error with code |
| public static final int | CANNOT_DROP_LAST_COLUMN
The error with code |
| public static final int | CANNOT_DROP_TABLE_1
The error with code |
| public static final int | CANNOT_MIX_INDEXED_AND_UNINDEXED_PARAMS
The error with code |
| public static final int | CANNOT_TRUNCATE_1
The error with code |
| public static final int | CHECK_CONSTRAINT_INVALID
The error with code |
| public static final int | CHECK_CONSTRAINT_VIOLATED_1
The error with code |
| public static final int | CLASS_NOT_FOUND_1
The error with code |
| public static final int | CLUSTER_ERROR_DATABASE_RUNS_ALONE
The error with code |
| public static final int | CLUSTER_ERROR_DATABASE_RUNS_CLUSTERED_1
The error with code |
| public static final int | COLLATION_CHANGE_WITH_DATA_TABLE_1
The error with code |
| public static final int | COLUMN_ALIAS_IS_NOT_SPECIFIED_1
The error with code |
| public static final int | COLUMN_CONTAINS_NULL_VALUES_1
The error with code |
| public static final int | COLUMN_COUNT_DOES_NOT_MATCH
The error with code |
| public static final int | COLUMN_IS_PART_OF_INDEX_1
The error with code |
| public static final int | COLUMN_IS_REFERENCED_1
The error with code |
| public static final int | COLUMN_MUST_NOT_BE_NULLABLE_1
The error with code |
| public static final int | COLUMN_NOT_FOUND_1
The error with code |
| public static final int | COMMIT_ROLLBACK_NOT_ALLOWED
The error with code |
| public static final int | COMPRESSION_ERROR
The error with code |
| public static final int | CONCURRENT_UPDATE_1
The error with code |
| public static final int | CONNECTION_BROKEN_1
The error with code |
| public static final int | CONSTANT_ALREADY_EXISTS_1
The error with code |
| public static final int | CONSTANT_NOT_FOUND_1
The error with code |
| public static final int | CONSTRAINT_ALREADY_EXISTS_1
The error with code |
| public static final int | CONSTRAINT_IS_USED_BY_CONSTRAINT_2
The error with code |
| public static final int | CONSTRAINT_NOT_FOUND_1
The error with code |
| public static final int | CURRENT_SEQUENCE_VALUE_IS_NOT_DEFINED_IN_SESSION_1
The error with code |
| public static final int | DATA_CONVERSION_ERROR_1
The error with code |
| public static final int | DATABASE_ALREADY_OPEN_1
The error with code |
| public static final int | DATABASE_CALLED_AT_SHUTDOWN
The error with code |
| public static final int | DATABASE_IS_CLOSED
The error with code |
| public static final int | DATABASE_IS_IN_EXCLUSIVE_MODE
The error with code |
| public static final int | DATABASE_IS_NOT_PERSISTENT
The error with code |
| public static final int | DATABASE_IS_READ_ONLY
The error with code |
| public static final int | DATABASE_NOT_FOUND_1
The error with code |
| public static final int | DATABASE_NOT_FOUND_WITH_IF_EXISTS_1
The error with code jdbc:h2:./database_that_does_not_exist |
| public static final int | DEADLOCK_1
The error with code |
| public static final int | DESERIALIZATION_FAILED_1
The error with code |
| public static final int | DIVISION_BY_ZERO_1
The error with code |
| public static final int | DOMAIN_ALREADY_EXISTS_1
The error with code |
| public static final int | DOMAIN_NOT_FOUND_1
The error with code |
| public static final int | DRIVER_VERSION_ERROR_2
The error with code |
| public static final int | DUPLICATE_COLUMN_NAME_1
The error with code |
| public static final int | DUPLICATE_KEY_1
The error with code |
| public static final int | DUPLICATE_PROPERTY_1
The error with code |
| public static final int | ENUM_DUPLICATE
The error with code |
| public static final int | ENUM_EMPTY
The error with code |
| public static final int | ENUM_VALUE_NOT_PERMITTED
The error with code |
| public static final int | ERROR_ACCESSING_LINKED_TABLE_2
The error with code |
| public static final int | ERROR_CREATING_TRIGGER_OBJECT_3
The error with code |
| public static final int | ERROR_EXECUTING_TRIGGER_3
The error with code |
| public static final int | ERROR_OPENING_DATABASE_1
The error with code |
| public static final int | ERROR_SETTING_DATABASE_EVENT_LISTENER_2
The error with code |
| public static final int | EXCEPTION_IN_FUNCTION_1
The error with code |
| public static final int | EXCEPTION_OPENING_PORT_2
The error with code |
| public static final int | FEATURE_NOT_SUPPORTED_1
The error with code |
| public static final int | FILE_CORRUPTED_1
The error with code |
| public static final int | FILE_CREATION_FAILED_1
The error with code |
| public static final int | FILE_DELETE_FAILED_1
The error with code |
| public static final int | FILE_ENCRYPTION_ERROR_1
The error with code |
| public static final int | FILE_NOT_FOUND_1
The error with code |
| public static final int | FILE_RENAME_FAILED_2
The error with code |
| public static final int | FILE_VERSION_ERROR_1
The error with code |
| public static final int | FOR_UPDATE_IS_NOT_ALLOWED_IN_DISTINCT_OR_GROUPED_SELECT
The error with code |
| public static final int | FUNCTION_ALIAS_ALREADY_EXISTS_1
The error with code |
| public static final int | FUNCTION_ALIAS_NOT_FOUND_1
The error with code |
| public static final int | FUNCTION_MUST_RETURN_RESULT_SET_1
The error with code |
| public static final int | FUNCTION_NOT_FOUND_1
The error with code |
| public static final int | GENERAL_ERROR_1
The error with code |
| public static final int | GENERATED_COLUMN_CANNOT_BE_ASSIGNED_1
The error with code |
| public static final int | GENERATED_COLUMN_CANNOT_BE_UPDATABLE_BY_CONSTRAINT_2
The error with code |
| public static final int | GROUP_BY_NOT_IN_THE_RESULT
The error with code |
| public static final int | HEX_STRING_ODD_1
The error with code |
| public static final int | HEX_STRING_WRONG_1
The error with code |
| public static final int | IDENTICAL_EXPRESSIONS_SHOULD_BE_USED
The error with code |
| public static final int | INDEX_ALREADY_EXISTS_1
The error with code |
| public static final int | INDEX_BELONGS_TO_CONSTRAINT_2
The error with code |
| public static final int | INDEX_NOT_FOUND_1
The error with code |
| public static final int | INVALID_CLASS_2
The error with code |
| public static final int | INVALID_DATABASE_NAME_1
The error with code |
| public static final int | INVALID_DATETIME_CONSTANT_2
The error with code |
| public static final int | INVALID_NAME_1
The error with code |
| public static final int | INVALID_PARAMETER_COUNT_2
The error with code |
| public static final int | INVALID_PRECEDING_OR_FOLLOWING_1
The error with code |
| public static final int | INVALID_TO_CHAR_FORMAT
The error with code |
| public static final int | INVALID_TO_DATE_FORMAT
The error with code |
| public static final int | INVALID_TRIGGER_FLAGS_1
The error with code |
| public static final int | INVALID_USE_OF_AGGREGATE_FUNCTION_1
The error with code |
| public static final int | INVALID_VALUE_2
The error with code |
| public static final int | INVALID_VALUE_PRECISION
The error with code |
| public static final int | INVALID_VALUE_SCALE
The error with code |
| public static final int | IO_EXCEPTION_1
The error with code |
| public static final int | IO_EXCEPTION_2
The error with code |
| public static final int | JAVA_OBJECT_SERIALIZER_CHANGE_WITH_DATA_TABLE
The error with code |
| public static final int | LIKE_ESCAPE_ERROR_1
The error with code |
| public static final int | LITERALS_ARE_NOT_ALLOWED
The error with code |
| public static final int | LOB_CLOSED_ON_TIMEOUT_1
The error with code |
| public static final int | LOCK_TIMEOUT_1
The error with code |
| public static final int | METHOD_DISABLED_ON_AUTOCOMMIT_TRUE
The error with code |
| public static final int | METHOD_NOT_ALLOWED_FOR_PREPARED_STATEMENT
The error with code |
| public static final int | METHOD_NOT_ALLOWED_FOR_QUERY
The error with code |
| public static final int | METHOD_NOT_FOUND_1
The error with code |
| public static final int | METHOD_ONLY_ALLOWED_FOR_QUERY
The error with code |
| public static final int | METHODS_MUST_HAVE_DIFFERENT_PARAMETER_COUNTS_2
The error with code |
| public static final int | MUST_GROUP_BY_COLUMN_1
The error with code |
| public static final int | NAME_TOO_LONG_2
The error with code |
| public static final int | NO_DATA_AVAILABLE
The error with code |
| public static final int | NO_DEFAULT_SET_1
The error with code |
| public static final int | NOT_ENOUGH_RIGHTS_FOR_1
The error with code |
| public static final int | NOT_ON_UPDATABLE_ROW
The error with code |
| public static final int | NULL_NOT_ALLOWED
The error with code |
| public static final int | NULL_VALUE_IN_ARRAY_TARGET
The error with code |
| public static final int | NUMERIC_VALUE_OUT_OF_RANGE_1
The error with code |
| public static final int | NUMERIC_VALUE_OUT_OF_RANGE_2
The error with code |
| public static final int | OBJECT_CLOSED
The error with code |
| public static final int | ORDER_BY_NOT_IN_RESULT
The error with code |
| public static final int | OUT_OF_MEMORY
The error with code |
| public static final int | PARAMETER_NOT_SET_1
The error with code |
| public static final int | PARSE_ERROR_1
The error with code |
| public static final int | PUBLIC_STATIC_JAVA_METHOD_NOT_FOUND_1
The error with code |
| public static final int | REFERENTIAL_INTEGRITY_VIOLATED_CHILD_EXISTS_1
The error with code |
| public static final int | REFERENTIAL_INTEGRITY_VIOLATED_PARENT_MISSING_1
The error with code |
| public static final int | REMOTE_CONNECTION_NOT_ALLOWED
The error with code |
| public static final int | REMOTE_DATABASE_NOT_FOUND_1
The error with code |
| public static final int | RESULT_SET_NOT_SCROLLABLE
The error with code |
| public static final int | RESULT_SET_NOT_UPDATABLE
The error with code |
| public static final int | RESULT_SET_READONLY
The error with code |
| public static final int | ROLE_ALREADY_EXISTS_1
The error with code |
| public static final int | ROLE_ALREADY_GRANTED_1
The error with code |
| public static final int | ROLE_CAN_NOT_BE_DROPPED_1
The error with code |
| public static final int | ROLE_NOT_FOUND_1
The error with code |
| public static final int | ROLES_AND_RIGHT_CANNOT_BE_MIXED
The error with code |
| public static final int | ROW_NOT_FOUND_IN_PRIMARY_INDEX
The error with code |
| public static final int | ROW_NOT_FOUND_WHEN_DELETING_1
The error with code |
| public static final int | SAVEPOINT_IS_INVALID_1
The error with code |
| public static final int | SAVEPOINT_IS_NAMED
The error with code |
| public static final int | SAVEPOINT_IS_UNNAMED
The error with code |
| public static final int | SCALAR_SUBQUERY_CONTAINS_MORE_THAN_ONE_ROW
The error with code |
| public static final int | SCHEMA_ALREADY_EXISTS_1
The error with code |
| public static final int | SCHEMA_CAN_NOT_BE_DROPPED_1
The error with code |
| public static final int | SCHEMA_NAME_MUST_MATCH
The error with code |
| public static final int | SCHEMA_NOT_FOUND_1
The error with code |
| public static final int | SECOND_PRIMARY_KEY
The error with code |
| public static final int | SEQUENCE_ALREADY_EXISTS_1
The error with code |
| public static final int | SEQUENCE_ATTRIBUTES_INVALID_7
The error with code |
| public static final int | SEQUENCE_BELONGS_TO_A_TABLE_1
The error with code |
| public static final int | SEQUENCE_EXHAUSTED
The error with code |
| public static final int | SEQUENCE_NOT_FOUND_1
The error with code |
| public static final int | SERIALIZATION_FAILED_1
The error with code |
| public static final int | STATEMENT_WAS_CANCELED
The error with code |
| public static final int | STEP_SIZE_MUST_NOT_BE_ZERO
The error with code |
| public static final int | STRING_FORMAT_ERROR_1
The error with code |
| public static final int | SUBQUERY_IS_NOT_SINGLE_COLUMN
The error with code |
| public static final int | SUM_OR_AVG_ON_WRONG_DATATYPE_1
The error with code |
| public static final int | SYNTAX_ERROR_1
The error with code |
| public static final int | SYNTAX_ERROR_2
The error with code |
| public static final int | TABLE_OR_VIEW_ALREADY_EXISTS_1
The error with code |
| public static final int | TABLE_OR_VIEW_NOT_FOUND_1
The error with code |
| public static final int | TABLE_OR_VIEW_NOT_FOUND_DATABASE_EMPTY_1
The error with code |
| public static final int | TABLE_OR_VIEW_NOT_FOUND_WITH_CANDIDATES_2
The error with code |
| public static final int | TOO_MANY_COLUMNS_1
The error with code |
| public static final int | TRACE_CONNECTION_NOT_CLOSED
The error with code |
| public static final int | TRACE_FILE_ERROR_2
The error with code |
| public static final int | TRANSACTION_NOT_FOUND_1
The error with code |
| public static final int | TRIGGER_ALREADY_EXISTS_1
The error with code |
| public static final int | TRIGGER_NOT_FOUND_1
The error with code |
| public static final int | TYPES_ARE_NOT_COMPARABLE_2
The error with code |
| public static final int | UNCOMPARABLE_REFERENCED_COLUMN_2
The error with code |
| public static final int | UNKNOWN_DATA_TYPE_1
The error with code |
| public static final int | UNKNOWN_MODE_1
The error with code |
| public static final int | UNSUPPORTED_CIPHER
The error with code |
| public static final int | UNSUPPORTED_COMPRESSION_ALGORITHM_1
The error with code |
| public static final int | UNSUPPORTED_COMPRESSION_OPTIONS_1
The error with code |
| public static final int | UNSUPPORTED_LOCK_METHOD_1
The error with code |
| public static final int | UNSUPPORTED_SETTING_1
The error with code |
| public static final int | UNSUPPORTED_SETTING_COMBINATION
The error with code |
| public static final int | URL_FORMAT_ERROR_2
The error with code |
| public static final int | URL_RELATIVE_TO_CWD
The error with code |
| public static final int | USER_ALREADY_EXISTS_1
The error with code |
| public static final int | USER_DATA_TYPE_ALREADY_EXISTS_1
Deprecated
Deprecated since 1.4.198.
|
| public static final int | USER_DATA_TYPE_NOT_FOUND_1
Deprecated
Deprecated since 1.4.198.
|
| public static final int | USER_NOT_FOUND_1
The error with code |
| public static final int | USER_OR_ROLE_NOT_FOUND_1
The error with code |
| public static final int | VALUE_TOO_LONG_2
The error with code |
| public static final int | VIEW_ALREADY_EXISTS_1
The error with code |
| public static final int | VIEW_IS_INVALID_2
The error with code |
| public static final int | VIEW_NOT_FOUND_1
The error with code |
| public static final int | WINDOW_NOT_FOUND_1
The error with code |
| public static final int | WITH_TIES_WITHOUT_ORDER_BY
The error with code |
| public static final int | WRONG_PASSWORD_FORMAT
The error with code |
| public static final int | WRONG_USER_OR_PASSWORD
The error with code |
| public static final int | WRONG_XID_FORMAT_1
The error with code |
| Access | Constructor and Description |
|---|---|
| private |
| Modifier and Type | Method and Description |
|---|---|
| public static String | |
| public static boolean |