Top Description Fields Constructors Methods
org.h2.api

public Class ErrorCode

extends Object
Class Inheritance

This class defines the error codes used for SQL exceptions. Error messages are formatted as follows:
{ 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.

Field Summary

Modifier and TypeField and Description
public static final int
ACCESS_DENIED_TO_CLASS_1

The error with code 90134 is thrown when trying to load a Java class that is not part of the allowed classes.

public static final int
ADMIN_RIGHTS_REQUIRED

The error with code 90040 is thrown when a user that is not administrator tries to execute a statement that requires admin privileges.

public static final int
AGGREGATE_NOT_FOUND_1

The error with code 90132 is thrown when trying to drop a user-defined aggregate function that doesn't exist.

public static final int
AMBIGUOUS_COLUMN_NAME_1

The error with code 90059 is thrown when a query contains a column that could belong to multiple tables.

public static final int
ARRAY_ELEMENT_ERROR_2

The error with code 22034 is thrown when an attempt is made to read non-existing element of an array.

public static final int
AUTHENTICATOR_NOT_AVAILABLE

The error with code 90144 is thrown when user trying to login into a database with AUTHREALM set and the target database doesn't have an authenticator defined

Authenticator experimental feature can be enabled by

SET AUTHENTICATOR TRUE
public static final int
CAN_ONLY_ASSIGN_TO_VARIABLE_1

The error with code 90137 is thrown when trying to assign a value to something that is not a variable.

public static final int
CANNOT_CHANGE_SETTING_WHEN_OPEN_1

The error with code 90133 is thrown when trying to change a specific database property while the database is already open.

public static final int
CANNOT_DROP_2

The error with code 90107 is thrown when trying to drop an object because another object would become invalid.

public static final int
CANNOT_DROP_CURRENT_USER

The error with code 90019 is thrown when trying to drop the current user, if there are no other admin users.

public static final int
CANNOT_DROP_LAST_COLUMN

The error with code 90084 is thrown when trying to drop the last column of a table.

public static final int
CANNOT_DROP_TABLE_1

The error with code 90118 is thrown when trying to drop a table can not be dropped.

public static final int
CANNOT_MIX_INDEXED_AND_UNINDEXED_PARAMS

The error with code 90123 is thrown when trying mix regular parameters and indexed parameters in the same statement.

public static final int
CANNOT_TRUNCATE_1

The error with code 90106 is thrown when trying to truncate a table that can not be truncated.

public static final int
CHECK_CONSTRAINT_INVALID

The error with code 23514 is thrown when evaluation of a check constraint resulted in an error.

public static final int
CHECK_CONSTRAINT_VIOLATED_1

The error with code 23513 is thrown when a check constraint is violated.

public static final int
CLASS_NOT_FOUND_1

The error with code 90086 is thrown when a class can not be loaded because it is not in the classpath or because a related class is not in the classpath.

public static final int
CLUSTER_ERROR_DATABASE_RUNS_ALONE

The error with code 90093 is thrown when trying to connect to a clustered database that runs in standalone mode.

public static final int
CLUSTER_ERROR_DATABASE_RUNS_CLUSTERED_1

The error with code 90094 is thrown when trying to connect to a clustered database that runs together with a different cluster node setting than what is used when trying to connect.

public static final int
COLLATION_CHANGE_WITH_DATA_TABLE_1

The error with code 90089 is thrown when trying to change the collation while there was already data in the database.

public static final int
COLUMN_ALIAS_IS_NOT_SPECIFIED_1

The error with code 90156 is thrown when trying to create a view or a table from a select and some expression doesn't have a column name or alias when it is required by a compatibility mode.

public static final int
COLUMN_CONTAINS_NULL_VALUES_1

The error with code 90081 is thrown when trying to alter a column to not allow NULL, if there is already data in the table where this column is NULL.

public static final int
COLUMN_COUNT_DOES_NOT_MATCH

The error with code 21002 is thrown when the number of columns does not match.

public static final int
COLUMN_IS_PART_OF_INDEX_1

The error with code 90075 is thrown when trying to alter a table and allow null for a column that is part of a primary key or hash index.

public static final int
COLUMN_IS_REFERENCED_1

The error with code 90083 is thrown when trying to drop a column that is part of a constraint.

public static final int
COLUMN_MUST_NOT_BE_NULLABLE_1

The error with code 90023 is thrown when trying to set a primary key on a nullable column or when trying to drop NOT NULL constraint on primary key or identity column.

public static final int
COLUMN_NOT_FOUND_1

The error with code 42122 is thrown when referencing an non-existing column.

public static final int
COMMIT_ROLLBACK_NOT_ALLOWED

The error with code 90058 is thrown when trying to call commit or rollback inside a trigger, or when trying to call a method inside a trigger that implicitly commits the current transaction, if an object is locked.

public static final int
COMPRESSION_ERROR

The error with code 90104 is thrown when the data can not be de-compressed.

public static final int
CONCURRENT_UPDATE_1

The error with code 90131 is thrown when using multi version concurrency control, and trying to update the same row from within two connections at the same time, or trying to insert two rows with the same key from two connections.

public static final int
CONNECTION_BROKEN_1

The error with code 90067 is thrown when the client could not connect to the database, or if the connection was lost.

public static final int
CONSTANT_ALREADY_EXISTS_1

The error with code 90114 is thrown when trying to create a constant if a constant with this name already exists.

public static final int
CONSTANT_NOT_FOUND_1

The error with code 90115 is thrown when trying to drop a constant that does not exists.

public static final int
CONSTRAINT_ALREADY_EXISTS_1

The error with code 90045 is thrown when trying to create a constraint if an object with this name already exists.

public static final int
CONSTRAINT_IS_USED_BY_CONSTRAINT_2

The error with code 90152 is thrown when trying to manually drop a unique or primary key constraint that is referenced by a foreign key constraint without a CASCADE clause.

public static final int
CONSTRAINT_NOT_FOUND_1

The error with code 90057 is thrown when trying to drop a constraint that does not exist.

public static final int
CURRENT_SEQUENCE_VALUE_IS_NOT_DEFINED_IN_SESSION_1

The error with code 90148 is thrown when trying to access the current value of a sequence before execution of NEXT VALUE FOR sequenceName in the current session.

public static final int
DATA_CONVERSION_ERROR_1

The error with code 22018 is thrown when trying to convert a value to a data type where the conversion is undefined, or when an error occurred trying to convert.

public static final int
DATABASE_ALREADY_OPEN_1

The error with code 90020 is thrown when trying to open a database in embedded mode if this database is already in use in another process (or in a different class loader).

public static final int
DATABASE_CALLED_AT_SHUTDOWN

The error with code 90121 is thrown when a database operation is started while the virtual machine exits (for example in a shutdown hook), or when the session is closed.

public static final int
DATABASE_IS_CLOSED

The error with code 90098 is thrown when the database has been closed, for example because the system ran out of memory or because the self-destruction counter has reached zero.

public static final int
DATABASE_IS_IN_EXCLUSIVE_MODE

The error with code 90135 is thrown when trying to open a connection to a database that is currently open in exclusive mode.

public static final int
DATABASE_IS_NOT_PERSISTENT

The error with code 90126 is thrown when trying to call the BACKUP statement for an in-memory database.

public static final int
DATABASE_IS_READ_ONLY

The error with code 90097 is thrown when trying to delete or update a database if it is open in read-only mode.

public static final int
DATABASE_NOT_FOUND_1

The error with code 90013 is thrown when when trying to access a database object with a catalog name that does not match the database name.

public static final int
DATABASE_NOT_FOUND_WITH_IF_EXISTS_1

The error with code 90146 is thrown when trying to open a database that does not exist using the flag IFEXISTS=TRUE

jdbc:h2:./database_that_does_not_exist
public static final int
DEADLOCK_1

The error with code 40001 is thrown when the database engine has detected a deadlock.

public static final int
DESERIALIZATION_FAILED_1

The error with code 90027 is thrown when an object could not be de-serialized.

public static final int
DIVISION_BY_ZERO_1

The error with code 22012 is thrown when trying to divide a value by zero.

public static final int
DOMAIN_ALREADY_EXISTS_1

The error with code 90119 is thrown when trying to create a domain if an object with this name already exists, or when trying to overload a built-in data type.

public static final int
DOMAIN_NOT_FOUND_1

The error with code 90120 is thrown when trying to drop a domain that doesn't exist.

public static final int
DRIVER_VERSION_ERROR_2

The error with code 90047 is thrown when trying to connect to a TCP server with an incompatible client.

public static final int
DUPLICATE_COLUMN_NAME_1

The error with code 42121 is thrown when trying to create a table or insert into a table and use the same column name twice.

public static final int
DUPLICATE_KEY_1

The error with code 23505 is thrown when trying to insert a row that would violate a unique index or primary key.

public static final int
DUPLICATE_PROPERTY_1

The error with code 90066 is thrown when the same property appears twice in the database URL or in the connection properties.

public static final int
ENUM_DUPLICATE

The error with code 22033 is thrown when an attempt is made to add or modify an ENUM-typed column so that it would have duplicate values.

public static final int
ENUM_EMPTY

The error with code 22032 is thrown when an attempt is made to add or modify an ENUM-typed column so that one or more of its enumerators would be empty.

public static final int
ENUM_VALUE_NOT_PERMITTED

The error with code 22030 is thrown when an attempt is made to INSERT or UPDATE an ENUM-typed cell, but the value is not one of the values enumerated by the type.

public static final int
ERROR_ACCESSING_LINKED_TABLE_2

The error with code 90111 is thrown when an exception occurred while accessing a linked table.

public static final int
ERROR_CREATING_TRIGGER_OBJECT_3

The error with code 90043 is thrown when there is an error initializing the trigger, for example because the class does not implement the Trigger interface.

public static final int
ERROR_EXECUTING_TRIGGER_3

The error with code 90044 is thrown when an exception or error occurred while calling the triggers fire method.

public static final int
ERROR_OPENING_DATABASE_1

The error with code 8000 is thrown when there was a problem trying to create a database lock.

public static final int
ERROR_SETTING_DATABASE_EVENT_LISTENER_2

The error with code 90099 is thrown when an error occurred trying to initialize the database event listener.

public static final int
EXCEPTION_IN_FUNCTION_1

The error with code 90105 is thrown when an exception occurred in a user-defined method.

public static final int
EXCEPTION_OPENING_PORT_2

The error with code 90061 is thrown when trying to start a server if a server is already running at the same port.

public static final int
FEATURE_NOT_SUPPORTED_1

The error with code 50100 is thrown when calling an unsupported JDBC method or database feature.

public static final int
FILE_CORRUPTED_1

The error with code 90030 is thrown when the database engine has detected a checksum mismatch in the data or index.

public static final int
FILE_CREATION_FAILED_1

The error with code 90062 is thrown when a directory or file could not be created.

public static final int
FILE_DELETE_FAILED_1

The error with code 90025 is thrown when a file could not be deleted, because it is still in use (only in Windows), or because an error occurred when deleting.

public static final int
FILE_ENCRYPTION_ERROR_1

The error with code 90049 is thrown when trying to open an encrypted database with the wrong file encryption password or algorithm.

public static final int
FILE_NOT_FOUND_1

The error with code 90124 is thrown when trying to access a file that doesn't exist.

public static final int
FILE_RENAME_FAILED_2

The error with code 90024 is thrown when a file could not be renamed.

public static final int
FILE_VERSION_ERROR_1

The error with code 90048 is thrown when the file header of a database files (*.db) does not match the expected version, or if it is corrupted.

public static final int
FOR_UPDATE_IS_NOT_ALLOWED_IN_DISTINCT_OR_GROUPED_SELECT

The error with code 90145 is thrown when trying to execute a SELECT statement with non-window aggregates, DISTINCT, GROUP BY, or HAVING clauses together with FOR UPDATE clause.

public static final int
FUNCTION_ALIAS_ALREADY_EXISTS_1

The error with code 90076 is thrown when trying to create a function alias for a system function or for a function that is already defined.

public static final int
FUNCTION_ALIAS_NOT_FOUND_1

The error with code 90077 is thrown when trying to drop a system function or a function alias that does not exist.

public static final int
FUNCTION_MUST_RETURN_RESULT_SET_1

The error with code 90000 is thrown when a function that does not return a result set was used in the FROM clause.

public static final int
FUNCTION_NOT_FOUND_1

The error with code 90022 is thrown when trying to call a unknown function.

public static final int
GENERAL_ERROR_1

The error with code 50000 is thrown when something unexpected occurs, for example an internal stack overflow.

public static final int
GENERATED_COLUMN_CANNOT_BE_ASSIGNED_1

The error with code 90154 is thrown when trying to assign a value to a generated column.

public static final int
GENERATED_COLUMN_CANNOT_BE_UPDATABLE_BY_CONSTRAINT_2

The error with code 90155 is thrown when trying to create a referential constraint that can update a referenced generated column.

public static final int
GROUP_BY_NOT_IN_THE_RESULT

The error with code 90157 is thrown when the integer index that is used in the GROUP BY is not in the SELECT list

public static final int
HEX_STRING_ODD_1

The error with code 90003 is thrown when trying to convert a String to a binary value.

public static final int
HEX_STRING_WRONG_1

The error with code 90004 is thrown when trying to convert a text to binary, but the expression contains a non-hexadecimal character.

public static final int
IDENTICAL_EXPRESSIONS_SHOULD_BE_USED

The error with code 42131 is thrown when identical expressions should be used, but different expressions were found.

public static final int
INDEX_ALREADY_EXISTS_1

The error with code 42111 is thrown when trying to create an index if an index with the same name already exists.

public static final int
INDEX_BELONGS_TO_CONSTRAINT_2

The error with code 90085 is thrown when trying to manually drop an index that was generated by the system because of a unique or referential constraint.

public static final int
INDEX_NOT_FOUND_1

The error with code 42112 is thrown when trying to drop or reference an index that does not exist.

public static final int
INVALID_CLASS_2

The error with code 90125 is thrown when PreparedStatement.setBigDecimal is called with object that extends the class BigDecimal.

public static final int
INVALID_DATABASE_NAME_1

The error with code 90138 is thrown when trying to open a persistent database using an incorrect database name.

public static final int
INVALID_DATETIME_CONSTANT_2

The error with code 22007 is thrown when a text can not be converted to a date, time, or timestamp constant.

public static final int
INVALID_NAME_1

The error with code 42602 is thrown when invalid name of identifier is used.

public static final int
INVALID_PARAMETER_COUNT_2

The error with code 7001 is thrown when trying to call a function with the wrong number of parameters.

public static final int
INVALID_PRECEDING_OR_FOLLOWING_1

The error with code 22013 is thrown when preceding or following size in a window function is null or negative.

public static final int
INVALID_TO_CHAR_FORMAT

The error with code 90010 is thrown when trying to format a timestamp or number using TO_CHAR with an invalid format.

public static final int
INVALID_TO_DATE_FORMAT

The error with code 90056 is thrown when trying to format a timestamp using TO_DATE and TO_TIMESTAMP with an invalid format.

public static final int
INVALID_TRIGGER_FLAGS_1

The error with code 90005 is thrown when trying to create a trigger with invalid combination of flags.

public static final int
INVALID_USE_OF_AGGREGATE_FUNCTION_1

The error with code 90054 is thrown when an aggregate function is used where it is not allowed.

public static final int
INVALID_VALUE_2

The error with code 90008 is thrown when trying to use a value that is not valid for the given operation.

public static final int
INVALID_VALUE_PRECISION

The error with code 90150 is thrown when trying to use an invalid precision.

public static final int
INVALID_VALUE_SCALE

The error with code 90151 is thrown when trying to use an invalid scale or fractional seconds precision.

public static final int
IO_EXCEPTION_1

The error with code 90028 is thrown when an input / output error occurred.

public static final int
IO_EXCEPTION_2

The error with code 90031 is thrown when an input / output error occurred.

public static final int
JAVA_OBJECT_SERIALIZER_CHANGE_WITH_DATA_TABLE

The error with code 90141 is thrown when trying to change the java object serializer while there was already data in the database.

public static final int
LIKE_ESCAPE_ERROR_1

The error with code 22025 is thrown when using an invalid escape character sequence for LIKE or REGEXP.

public static final int
LITERALS_ARE_NOT_ALLOWED

The error with code 90116 is thrown when trying use a literal in a SQL statement if literals are disabled.

public static final int
LOB_CLOSED_ON_TIMEOUT_1

The error with code 90039 is thrown when trying to access a CLOB or BLOB object that timed out.

public static final int
LOCK_TIMEOUT_1

The error with code 50200 is thrown when another connection locked an object longer than the lock timeout set for this connection, or when a deadlock occurred.

public static final int
METHOD_DISABLED_ON_AUTOCOMMIT_TRUE

The error with code 90147 is thrown when trying to execute a statement which closes the transaction (such as commit and rollback) and autocommit mode is on.

public static final int
METHOD_NOT_ALLOWED_FOR_PREPARED_STATEMENT

The error with code 90130 is thrown when an execute method of PreparedStatement was called with a SQL statement.

public static final int
METHOD_NOT_ALLOWED_FOR_QUERY

The error with code 90001 is thrown when Statement.executeUpdate() was called for a SELECT statement.

public static final int
METHOD_NOT_FOUND_1

The error with code 90087 is thrown when a method with matching number of arguments was not found in the class.

public static final int
METHOD_ONLY_ALLOWED_FOR_QUERY

The error with code 90002 is thrown when Statement.executeQuery() was called for a statement that does not return a result set (for example, an UPDATE statement).

public static final int
METHODS_MUST_HAVE_DIFFERENT_PARAMETER_COUNTS_2

The error with code 90073 is thrown when trying to create an alias for a Java method, if two methods exists in this class that have this name and the same number of parameters.

public static final int
MUST_GROUP_BY_COLUMN_1

The error with code 90016 is thrown when a column was used in the expression list or the order by clause of a group or aggregate query, and that column is not in the GROUP BY clause.

public static final int
NAME_TOO_LONG_2

The error with code 42622 is thrown when name of identifier is too long.

public static final int
NO_DATA_AVAILABLE

The error with code 2000 is thrown when the result set is positioned before the first or after the last row, or not on a valid row for the given operation.

public static final int
NO_DEFAULT_SET_1

The error with code 23507 is thrown when updating or deleting from a table with a foreign key constraint that should set the default value, but there is no default value defined.

public static final int
NOT_ENOUGH_RIGHTS_FOR_1

The error with code 90096 is thrown when trying to perform an operation with a non-admin user if the user does not have enough rights.

public static final int
NOT_ON_UPDATABLE_ROW

The error with code 90029 is thrown when calling ResultSet.deleteRow(), insertRow(), or updateRow() when the current row is not updatable.

public static final int
NULL_NOT_ALLOWED

The error with code 23502 is thrown when trying to insert NULL into a column that does not allow NULL.

public static final int
NULL_VALUE_IN_ARRAY_TARGET

The error with code 22035 is thrown when an attempt is made to update an element in NULL array.

public static final int
NUMERIC_VALUE_OUT_OF_RANGE_1

The error with code 22003 is thrown when a value is out of range when converting to another data type.

public static final int
NUMERIC_VALUE_OUT_OF_RANGE_2

The error with code 22004 is thrown when a value is out of range when converting to another column's data type.

public static final int
OBJECT_CLOSED

The error with code 90007 is thrown when trying to call a JDBC method on an object that has been closed.

public static final int
ORDER_BY_NOT_IN_RESULT

The error with code 90068 is thrown when the given expression that is used in the ORDER BY is not in the result list.

public static final int
OUT_OF_MEMORY

The error with code 90108 is thrown when not enough heap memory was available.

public static final int
PARAMETER_NOT_SET_1

The error with code 90012 is thrown when trying to execute a statement with an parameter.

public static final int
PARSE_ERROR_1

The error with code 90014 is thrown when trying to parse a date with an unsupported format string, or when the date can not be parsed.

public static final int
PUBLIC_STATIC_JAVA_METHOD_NOT_FOUND_1

The error with code 90139 is thrown when the specified public static Java method was not found in the class.

public static final int
REFERENTIAL_INTEGRITY_VIOLATED_CHILD_EXISTS_1

The error with code 23503 is thrown when trying to delete or update a row when this would violate a referential constraint, because there is a child row that would become an orphan.

public static final int
REFERENTIAL_INTEGRITY_VIOLATED_PARENT_MISSING_1

The error with code 23506 is thrown when trying to insert or update a row that would violate a referential constraint, because the referenced row does not exist.

public static final int
REMOTE_CONNECTION_NOT_ALLOWED

The error with code 90117 is thrown when trying to connect to a TCP server from another machine, if remote connections are not allowed.

public static final int
REMOTE_DATABASE_NOT_FOUND_1

The error with code 90149 is thrown when trying to open a database that does not exist remotely without enabling remote database creation first.

public static final int
RESULT_SET_NOT_SCROLLABLE

The error with code 90128 is thrown when trying to call a method of the ResultSet that is only supported for scrollable result sets, and the result set is not scrollable.

public static final int
RESULT_SET_NOT_UPDATABLE

The error with code 90127 is thrown when trying to update or delete a row in a result set if the result set is not updatable.

public static final int
RESULT_SET_READONLY

The error with code 90140 is thrown when trying to update or delete a row in a result set if the statement was not created with updatable concurrency.

public static final int
ROLE_ALREADY_EXISTS_1

The error with code 90069 is thrown when trying to create a role if an object with this name already exists.

public static final int
ROLE_ALREADY_GRANTED_1

The error with code 90074 is thrown when trying to grant a role that has already been granted.

public static final int
ROLE_CAN_NOT_BE_DROPPED_1

The error with code 90091 is thrown when trying to drop the role PUBLIC.

public static final int
ROLE_NOT_FOUND_1

The error with code 90070 is thrown when trying to drop or grant a role that does not exists.

public static final int
ROLES_AND_RIGHT_CANNOT_BE_MIXED

The error with code 90072 is thrown when trying to grant or revoke both roles and rights at the same time.

public static final int
ROW_NOT_FOUND_IN_PRIMARY_INDEX

The error with code 90143 is thrown when trying to fetch a row from the primary index and the row is not there.

public static final int
ROW_NOT_FOUND_WHEN_DELETING_1

The error with code 90112 is thrown when a row was deleted twice while locking was disabled.

public static final int
SAVEPOINT_IS_INVALID_1

The error with code 90063 is thrown when trying to rollback to a savepoint that is not defined.

public static final int
SAVEPOINT_IS_NAMED

The error with code 90065 is thrown when Savepoint.getSavepointId() is called on a named savepoint.

public static final int
SAVEPOINT_IS_UNNAMED

The error with code 90064 is thrown when Savepoint.getSavepointName() is called on an unnamed savepoint.

public static final int
SCALAR_SUBQUERY_CONTAINS_MORE_THAN_ONE_ROW

The error with code 90053 is thrown when a subquery that is used as a value contains more than one row.

public static final int
SCHEMA_ALREADY_EXISTS_1

The error with code 90078 is thrown when trying to create a schema if an object with this name already exists.

public static final int
SCHEMA_CAN_NOT_BE_DROPPED_1

The error with code 90090 is thrown when trying to drop a schema that may not be dropped (the schema PUBLIC and the schema INFORMATION_SCHEMA).

public static final int
SCHEMA_NAME_MUST_MATCH

The error with code 90080 is thrown when trying to rename a object to a different schema, or when trying to create a related object in another schema.

public static final int
SCHEMA_NOT_FOUND_1

The error with code 90079 is thrown when trying to drop a schema that does not exist.

public static final int
SECOND_PRIMARY_KEY

The error with code 90017 is thrown when trying to define a second primary key constraint for this table.

public static final int
SEQUENCE_ALREADY_EXISTS_1

The error with code 90035 is thrown when trying to create a sequence if a sequence with this name already exists.

public static final int
SEQUENCE_ATTRIBUTES_INVALID_7

The error with code 90009 is thrown when trying to create a sequence with an invalid combination of attributes (min value, max value, start value, etc).

public static final int
SEQUENCE_BELONGS_TO_A_TABLE_1

The error with code 90082 is thrown when trying to drop a system generated sequence.

public static final int
SEQUENCE_EXHAUSTED

The error with code 90006 is thrown when trying to get a value from a sequence that has run out of numbers and does not have cycling enabled.

public static final int
SEQUENCE_NOT_FOUND_1

The error with code 90036 is thrown when trying to access a sequence that does not exist.

public static final int
SERIALIZATION_FAILED_1

The error with code 90026 is thrown when an object could not be serialized.

public static final int
STATEMENT_WAS_CANCELED

The error with code 57014 is thrown when a statement was canceled using Statement.cancel() or when the query timeout has been reached.

public static final int
STEP_SIZE_MUST_NOT_BE_ZERO

The error with code 90142 is thrown when trying to set zero for step size.

public static final int
STRING_FORMAT_ERROR_1

The error with code 90095 is thrown when calling the method STRINGDECODE with an invalid escape sequence.

public static final int
SUBQUERY_IS_NOT_SINGLE_COLUMN

The error with code 90052 is thrown when a single-column subquery is expected but a subquery with other number of columns was specified.

public static final int
SUM_OR_AVG_ON_WRONG_DATATYPE_1

The error with code 90015 is thrown when using an aggregate function with a data type that is not supported.

public static final int
SYNTAX_ERROR_1

The error with code 42000 is thrown when trying to execute an invalid SQL statement.

public static final int
SYNTAX_ERROR_2

The error with code 42001 is thrown when trying to execute an invalid SQL statement.

public static final int
TABLE_OR_VIEW_ALREADY_EXISTS_1

The error with code 42101 is thrown when trying to create a table or view if an object with this name already exists.

public static final int
TABLE_OR_VIEW_NOT_FOUND_1

The error with code 42102 is thrown when trying to query, modify or drop a table or view that does not exists in this schema and database.

public static final int
TABLE_OR_VIEW_NOT_FOUND_DATABASE_EMPTY_1

The error with code 42104 is thrown when trying to query, modify or drop a table or view that does not exists in this schema and database but it is empty anyway.

public static final int
TABLE_OR_VIEW_NOT_FOUND_WITH_CANDIDATES_2

The error with code 42103 is thrown when trying to query, modify or drop a table or view that does not exists in this schema and database but similar names were found.

public static final int
TOO_MANY_COLUMNS_1

The error with code 54011 is thrown when too many columns were specified in a table, select statement, or row value.

public static final int
TRACE_CONNECTION_NOT_CLOSED

The error with code 90018 is thrown when the connection was opened, but never closed.

public static final int
TRACE_FILE_ERROR_2

The error with code 90034 is thrown when writing to the trace file failed, for example because the there is an I/O exception.

public static final int
TRANSACTION_NOT_FOUND_1

The error with code 90129 is thrown when trying to commit a transaction that doesn't exist.

public static final int
TRIGGER_ALREADY_EXISTS_1

The error with code 90041 is thrown when trying to create a trigger and there is already a trigger with that name.

public static final int
TRIGGER_NOT_FOUND_1

The error with code 90042 is thrown when trying to drop a trigger that does not exist.

public static final int
TYPES_ARE_NOT_COMPARABLE_2

The error with code 90110 is thrown when trying to compare or combine values of incomparable data types.

public static final int
UNCOMPARABLE_REFERENCED_COLUMN_2

The error with code 90153 is thrown when trying to reference a column of another data type when data types aren't comparable or don't have a session-independent compare order between each other.

public static final int
UNKNOWN_DATA_TYPE_1

The error with code 50004 is thrown when creating a table with an unsupported data type, or when the data type is unknown because parameters are used.

public static final int
UNKNOWN_MODE_1

The error with code 90088 is thrown when trying to switch to an unknown mode.

public static final int
UNSUPPORTED_CIPHER

The error with code 90055 is thrown when trying to open a database with an unsupported cipher algorithm.

public static final int
UNSUPPORTED_COMPRESSION_ALGORITHM_1

The error with code 90103 is thrown when trying to use an unsupported compression algorithm.

public static final int
UNSUPPORTED_COMPRESSION_OPTIONS_1

The error with code 90102 is thrown when trying to use unsupported options for the given compression algorithm.

public static final int
UNSUPPORTED_LOCK_METHOD_1

The error with code 90060 is thrown when trying to use a file locking mechanism that is not supported.

public static final int
UNSUPPORTED_SETTING_1

The error with code 90113 is thrown when the database URL contains unsupported settings.

public static final int
UNSUPPORTED_SETTING_COMBINATION

The error with code 90021 is thrown when trying to change a specific database property that conflicts with other database properties.

public static final int
URL_FORMAT_ERROR_2

The error with code 90046 is thrown when trying to open a connection to a database using an unsupported URL format.

public static final int
URL_RELATIVE_TO_CWD

The error with code 90011 is thrown when trying to open a connection to a database using an implicit relative path, such as "jdbc:h2:test" (in which case the database file would be stored in the current working directory of the application).

public static final int
USER_ALREADY_EXISTS_1

The error with code 90033 is thrown when trying to create a user or role if a user with this name already exists.

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 90032 is thrown when trying to drop or alter a user that does not exist.

public static final int
USER_OR_ROLE_NOT_FOUND_1

The error with code 90071 is thrown when trying to grant or revoke if no role or user with that name exists.

public static final int
VALUE_TOO_LONG_2

The error with code 22001 is thrown when trying to insert a value that is too long for the column.

public static final int
VIEW_ALREADY_EXISTS_1

The error with code 90038 is thrown when trying to create a view if a view with this name already exists.

public static final int
VIEW_IS_INVALID_2

The error with code 90109 is thrown when trying to run a query against an invalid view.

public static final int
VIEW_NOT_FOUND_1

The error with code 90037 is thrown when trying to drop or alter a view that does not exist.

public static final int
WINDOW_NOT_FOUND_1

The error with code 90136 is thrown when trying to reference a window that does not exist.

public static final int
WITH_TIES_WITHOUT_ORDER_BY

The error with code 90122 is thrown when WITH TIES clause is used without ORDER BY clause.

public static final int
WRONG_PASSWORD_FORMAT

The error with code 90050 is thrown when trying to open an encrypted database, but not separating the file password from the user password.

public static final int
WRONG_USER_OR_PASSWORD

The error with code 28000 is thrown when there is no such user registered in the database, when the user password does not match, or when the database encryption password does not match (if database encryption is used).

public static final int
WRONG_XID_FORMAT_1

The error with code 90101 is thrown when the XA API detected unsupported transaction names.

Constructor Summary

AccessConstructor and Description
private

Method Summary

Modifier and TypeMethod and Description
public static String

Returns:

error state
getState
(int
to get state for
errorCode
)

INTERNAL

public static boolean

Returns:

true if provided code is common, false otherwise
isCommon
(int
to check
errorCode
)

INTERNAL

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait