|
|||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||
90134 is thrown when
trying to load a Java class that is not part of the allowed classes.
90040 is thrown when
a user that is not administrator tries to execute a statement
that requires admin privileges.
90132 is thrown when
trying to drop a user-defined aggregate function that doesn't exist.
ALIAS_COLUMN_NAME (default: false).h2.allowBigDecimalExtensions (default:
false).h2.allowedClasses (default: *).90059 is thrown when
a query contains a column that could belong to multiple tables.
ANALYZE_AUTO (default: 0).ANALYZE_SAMPLE (default: 10000).h2.bindAddress (default: null).h2.browser (default: null).90137 is thrown when
trying to assign a value to something that is not a variable.
90133 is thrown when
trying to change a specific database property while the database is already
open.
90107 is thrown when
trying to drop an object because another object would become invalid.
90019 is thrown when
trying to drop the current user, if there are no other admin users.
90084 is thrown when
trying to drop the last column of a table.
90118 is thrown when
trying to drop a table can not be dropped.
90123 is thrown when
trying mix regular parameters and indexed parameters in the same statement.
90106 is thrown when
trying to truncate a table that can not be truncated.
h2.check (default: true).h2.check2 (default: true).23000 is thrown when a check
constraint is violated.
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.
h2.clientTraceDirectory (default:
trace.db/).90093 is thrown when
trying to connect to a clustered database that runs in standalone
mode.
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.
90089 is thrown when
trying to change the collation while there was already data in
the database.
h2.collatorCacheSize (default: 32000).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.
21002 is thrown when the number of
columns does not match.
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.
90083 is thrown when
trying to drop a column that is part of a constraint.
90023 is thrown when
trying to set a primary key on a nullable column.
42122 is thrown when
referencing an non-existing column.
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.
90104 is thrown when
the data can not be de-compressed.
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.
90067 is thrown when the client could
not connect to the database, or if the connection was lost.
h2.consoleStream (default: true).90114 is thrown when
trying to create a constant if a constant with this name already exists.
90115 is thrown when
trying to drop a constant that does not exists.
90045 is thrown when
trying to create a constraint if an object with this name already exists.
90057 is thrown when
trying to drop a constraint that does not exist.
90021 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.
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).
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.
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.
90135 is thrown when
trying to open a connection to a database that is currently open
in exclusive mode.
90126 is thrown when
trying to call the BACKUP statement for an in-memory database.
90097 is thrown when
trying to delete or update a database if it is open in read-only mode.
90013 is thrown when
trying to open a database that does not exist using the flag IFEXISTS=TRUE,
or when trying to access a database object with a catalog name that does
not match the database name.
DATABASE_TO_UPPER (default: true).h2.dataSourceTraceLevel (default: 1).90009 is thrown when
a text can not be converted to a date constant.
DB_CLOSE_ON_EXIT (default: true).40001 is thrown when the database
engine has detected a deadlock.
DEFAULT_ESCAPE (default: \).DEFRAG_ALWAYS (default: false).h2.delayWrongPasswordMax (default: 4000).h2.delayWrongPasswordMin (default: 250).90027 is thrown when
an object could not be de-serialized.
22012 is thrown when trying to divide
a value by zero.
90047 is thrown when
trying to connect to a TCP server with an incompatible client.
DROP_RESTRICT (default: false).42121 is thrown when trying to create
a table or insert into a table and use the same column name twice.
23001 is thrown when trying to insert
a row that would violate a unique index or primary key.
90066 is thrown when
the same property appears twice in the database URL or in
the connection properties.
h2.emptyPassword (default: true).h2.enableAnonymousSSL (default: true).90111 is thrown when
an exception occurred while accessing a linked table.
90043 is thrown when
there is an error initializing the trigger, for example because the
class does not implement the Trigger interface.
90044 is thrown when
an exception or error occurred while calling the triggers fire method.
8000 is thrown when
there was a problem trying to create a database lock.
90099 is thrown when an error occurred
trying to initialize the database event listener.
ESTIMATED_FUNCTION_TABLE_ROWS (default:
1000).90105 is thrown when
an exception occurred in a user-defined method.
90061 is thrown when
trying to start a server if a server is already running on the same port.
50100 is thrown when calling an
unsupported JDBC method or database feature.
90030 is thrown when
the database engine has detected a checksum mismatch in the data
or index.
90062 is thrown when
a directory or file could not be created.
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.
file.encoding (default: Cp1252).90049 is thrown when
trying to open an encrypted database with the wrong file encryption
password or algorithm.
90124 is thrown when
trying to access a file that doesn't exist.
90024 is thrown when
a file could not be renamed.
file.separator (default: /).90048 is thrown when
the file header of a database files (*.db) does not match the
expected version, or if it is corrupted.
90076 is thrown when
trying to create a function alias for a system function or for a function
that is already defined.
90077 is thrown when
trying to drop a system function or a function alias that does not exist.
90000 is thrown when
a function that does not return a result set was used in the FROM clause.
90022 is thrown when
trying to call a unknown function.
FUNCTIONS_IN_SCHEMA (default:
false).50000 is thrown when
something unexpected occurs, for example an internal stack
overflow.
h2.scriptDirectory (default: empty
string).90003 is thrown when
trying to convert a String to a binary value.
90004 is thrown when
trying to convert a text to binary, but the expression contains
a non-hexadecimal character.
42111 is thrown when
trying to create an index if an index with the same name already exists.
90085 is thrown when
trying to manually drop an index that was generated by the system
because of a unique or referential constraint.
42112 is thrown when
trying to drop or reference an index that does not exist.
INDEX(..) or KEY(..).
90125 is thrown when
PreparedStatement.setBigDecimal is called
with object that extends the class BigDecimal, and the system property
h2.allowBigDecimalExtensions is not set.
90138 is thrown when
trying to open a persistent database using an incorrect database name.
7001 is thrown when
trying to call a function with the wrong number of parameters.
90054 is thrown when
an aggregate function is used where it is not allowed.
90008 is thrown when
trying to use a value that is not valid for the given operation.
90028 is thrown when
an input / output error occurred.
90031 is thrown when
an input / output error occurred.
java.specification.version.LARGE_RESULT_BUFFER_SIZE (default: 4096).LARGE_TRANSACTIONS (default: false).22025 is thrown when using an invalid
escape character sequence for LIKE or REGEXP.
line.separator (default: \n).90116 is thrown when
trying use a literal in a SQL statement if literals are disabled.
h2.lobClientMaxSizeMemory (default: 65536).h2.lobFilesPerDirectory (default: 256).h2.lobInDatabase (default: false).h2.lobCloseBetweenReads (default: false).50200 is thrown when
another connection locked an object longer than the lock timeout
set for this connection, or when a deadlock occurred.
h2.logAllErrors (default: false).h2.logAllErrorsFile (default:
h2errors.txt).h2.maxFileRetry (default: 16).h2.maxReconnect (default: 3).h2.maxTraceDataLength (default: 65535).MAX_COMPACT_COUNT
(default: Integer.MAX_VALUE).MAX_COMPACT_TIME (default: 200).MAX_MEMORY_ROWS_DISTINCT (default:
Integer.MAX_VALUE).MAX_QUERY_TIMEOUT (default: 0).90130 is thrown when
an execute method of PreparedStatement was called with a SQL statement.
90001 is thrown when
Statement.executeUpdate() was called for a SELECT statement.
90087 is thrown when
the specified method was not found in the class.
90002 is thrown when
Statement.executeQuery() was called for a statement that does
not return a result set (for example, an UPDATE statement).
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.
h2.minColumnNameMap (default: 3).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.
NESTED_JOINS (default: false).h2.nioCleanerHack (default: false).h2.nioLoadMapped (default: false).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.
90056 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.
90100 is thrown when
there is no more space available on the device where the database
files are stored.
90096 is thrown when
trying to perform an operation with a non-admin user if the
user does not have enough rights.
90029 is thrown when
calling ResultSet.deleteRow(), insertRow(), or updateRow()
when the current row is not updatable.
90006 is thrown when
trying to insert NULL into a column that does not allow NULL.
22003 is thrown when a value is out of
range when converting to another data type.
h2.objectCache (default: true).h2.objectCacheMaxPerElementSize (default:
4096).h2.objectCacheSize (default: 1024).90007 is thrown when
trying to call a JDBC method on an object that has been closed.
90122 is thrown when
trying to altering, adding or dropping columns of a table that has views.
OPTIMIZE_DISTINCT (default: true).OPTIMIZE_EVALUATABLE_SUBQUERIES (default:
true).OPTIMIZE_IN_LIST (default: true).OPTIMIZE_INSERT_FROM_SELECT
(default: false).OPTIMIZE_IS_NULL (default: false).OPTIMIZE_OR (default: false).OPTIMIZE_SUBQUERY_CACHE (default: true).OPTIMIZE_TWO_EQUALS (default: true).OPTIMIZE_UPDATE (default: true).90068 is thrown when the given
expression that is used in the ORDER BY is not in the result list.
90108 is thrown when not enough heap
memory was available.
90110 is thrown when
the result of the calculation does not fit in the given data type.
PAGE_STORE_INTERNAL_COUNT
(default: false).PAGE_STORE_TRIM (default: true).90012 is thrown when
trying to execute a statement with an parameter.
90014 is thrown when
trying to parse a date with an unsupported format string, or
when the date can not be parsed.
h2.pgClientEncoding (default: UTF-8).h2.prefixTempFile (default: h2.temp).SortOrder object given the list of SelectOrderBy
objects.
90139 is thrown when
the specified public static Java method was not found in the class.
QUERY_CACHE_SIZE (default: 0).RECOMPILE_ALWAYS (default: false).RECONNECT_CHECK_DELAY (default: 200).23003 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.
23002 is thrown when trying to insert
or update a row that would violate a referential constraint, because the
referenced row does not exist.
90117 is thrown when
trying to connect to a TCP server from another machine, if remote
connections are not allowed.
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.
90127 is thrown when
trying to update or delete a row in a result set if the result set is
not updatable.
90140 is thrown when trying to update or
delete a row in a result set if the statement was not created with
updatable concurrency.
h2.returnLobObjects (default: true).90069 is thrown when
trying to create a role if an object with this name already exists.
90074 is thrown when
trying to grant a role that has already been granted.
90091 is thrown when
trying to drop the role PUBLIC.
90070 is thrown when
trying to drop or grant a role that does not exists.
90072 is thrown when
trying to grant or revoke if no role or user with that name exists.
90112 is thrown when a row was deleted
twice while locking was disabled.
h2.runFinalize (default: true).90063 is thrown when
trying to rollback to a savepoint that is not defined.
90065 is thrown when
Savepoint.getSavepointId() is called on a named savepoint.
90064 is thrown when
Savepoint.getSavepointName() is called on an unnamed savepoint.
90053 is thrown when
a subquery that is used as a value contains more than one row.
90078 is thrown when
trying to create a schema if an object with this name already exists.
90090 is thrown when
trying to drop a schema that may not be dropped (the schema PUBLIC
and the schema INFORMATION_SCHEMA).
90080 is thrown when
trying to rename a object to a different schema, or when trying to
create a related object in another schema.
90079 is thrown when
trying to drop a schema that does not exist.
90017 is thrown when
trying to define a second primary key constraint for this table.
SELECT_FOR_UPDATE_MVCC
(default: false).90035 is thrown when
trying to create a sequence if a sequence with this name already
exists.
90082 is thrown when
trying to drop a system generated sequence.
90036 is thrown when
trying to access a sequence that does not exist.
90026 is thrown when
an object could not be serialized.
h2.serverCachedObjects (default: 64).h2.serverResultSetFetchSize
(default: 100).SHARE_LINKED_CONNECTIONS
(default: true).h2.socketConnectRetry (default: 16).h2.socketConnectTimeout (default: 2000).h2.sortNullsHigh (default: false).h2.splitFileSizeShift (default: 30).90051 is thrown when
a statement was canceled using Statement.cancel() or
when the query timeout has been reached.
90095 is thrown when
calling the method STRINGDECODE with an invalid escape sequence.
90052 is thrown when
a subquery that is used as a value contains more than one column.
90015 is thrown when
using an aggregate function with a data type that is not supported.
h2.syncMethod (default: sync).42000 is thrown when
trying to execute an invalid SQL statement.
42001 is thrown when
trying to execute an invalid SQL statement.
42101 is thrown when
trying to create a table or view if an object with this name already exists.
42102 is thrown when
trying to query, modify or drop a table or view that does not exists
in this schema and database.
90010 is thrown when
a text can not be converted to a time constant.
90011 is thrown when
a text can not be converted to a timestamp constant.
90018 is thrown when
the connection was opened, but never closed.
90034 is thrown when
writing to the trace file failed, for example because the there
is an I/O exception.
h2.traceIO (default: false).90129 is thrown when
trying to commit a transaction that doesn't exist.
90041 is thrown when
trying to create a trigger and there is already a trigger with that name.
90042 is thrown when
trying to drop a trigger that does not exist.
50004 is thrown when
creating a table with an unsupported data type, or
when the data type is unknown because parameters are used.
90088 is thrown when
trying to switch to an unknown mode.
90055 is thrown when
trying to open a database with an unsupported cipher algorithm.
90103 is thrown when
trying to use an unsupported compression algorithm.
90102 is thrown when
trying to use unsupported options for the given compression algorithm.
90092 is thrown when
the source code is not compiled for the Java platform used.
90060 is thrown when
trying to use a file locking mechanism that is not supported.
90136 is thrown when
executing a query that used an unsupported outer join condition.
90113 is thrown when
the database URL contains unsupported settings.
90046 is thrown when
trying to open a connection to a database using an unsupported URL format.
90033 is thrown when
trying to create a user or role if a user with this name already exists.
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.
90120 is thrown when
trying to drop a domain that doesn't exists.
user.home (empty string if not set).90032 is thrown when
trying to drop or alter a user that does not exist.
90071 is thrown when
trying to grant or revoke if no role or user with that name exists.
90039 is thrown when
trying to convert a decimal value to lower precision if the
value is out of range for this precision.
90005 is thrown when
trying to insert a value that is too long for the column.
90038 is thrown when
trying to create a view if a view with this name already
exists.
90109 is thrown when
trying to run a query against an invalid view.
90037 is thrown when
trying to drop or alter a view that does not exist.
h2.webMaxValueLength (default: 100000).90050 is thrown when trying to open an
encrypted database, but not separating the file password from the user
password.
8004 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).
90101 is thrown when
the XA API detected unsupported transaction names.
|
|||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||