SQL error messages and exceptions

-Class 01: Warning +

The following tables list SQLStates for exceptions. Exceptions + that begin with an X are specific to .

Class 01: Warning @@ -45,109 +39,117 @@ -01001 -An attempt to update or delete an already deleted row was made: No row was updated or deleted. - - -01003 -Null values were eliminated from the argument of a column function. - - -01006 -Privilege not revoked from {0}. +01001 +An attempt to update or delete an already deleted row +was made: No row was updated or deleted. -0100E -XX Attempt to return too many result sets. +01003 +Null values were eliminated from the argument of a column +function. -01500 -The constraint {0} on table {1} has been dropped. +01006 +Privilege not revoked from <authorizationID>. -01501 -The view {0} has been dropped. +0100E +XX Attempt to return too many result sets. -01502 -The trigger {0} on table {1} has been dropped. +01500 +The constraint <constraintName> on +table <tableName> has been dropped. -01503 -The column {0} on table {1} has been modified by adding a not null constraint. +01501 +The view <viewName> has been dropped. -01504 -The new index is a duplicate of an existing index: {0}. +01502 +The trigger <triggerName> on table <tableName> has +been dropped. -01505 -The value {0} may be truncated. +01503 +The column <columnName> on table <tableName> has +been modified by adding a not null constraint. -01522 -The newly defined synonym '{0}' resolved to the object '{1}' which is currently undefined. +01504 +The new index is a duplicate of an existing index: <indexName>. -01J01 -Database '{0}' not created, connection made to existing database instead. +01505 +The value <valueName> may be truncated. -01J02 -Scroll sensitive cursors are not currently implemented. +01522 +The newly defined synonym '<synonymName>' +resolved to the object '<objectName>' which is currently +undefined. -01J03 -Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented. +01J01 +Database '<databaseName>' not +created, connection made to existing database instead. -01J04 -The class '{0}' for column '{1}' does not implement java.io.Serializable or java.sql.SQLData. Instances must implement one of these interfaces to allow them to be stored. +01J02 +Scroll sensitive cursors are not currently implemented. -01J05 -Database upgrade succeeded. The upgraded database is now ready for use. Revalidating stored prepared statements failed. See next exception for details of failure. +01J04 +The class '<className>' for column +'<columnName>' does not implement java.io.Serializable +or java.sql.SQLData. Instances must implement one of these interfaces to allow +them to be stored. -01J06 -ResultSet not updatable. Query does not qualify to generate an updatable ResultSet. +01J05 +Database upgrade succeeded. The upgraded database is +now ready for use. Revalidating stored prepared statements failed. See next +exception for details of failure. -01J07 -ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT for a global transaction. +01J06 +ResultSet not updatable. Query does not qualify to generate +an updatable ResultSet. -01J08 -Unable to open resultSet type {0}. ResultSet type {1} opened. +01J07 +ResultSetHoldability restricted to ResultSet.CLOSE_CURSORS_AT_COMMIT +for a global transaction. -01J09 -Unable to open ResultSet with concurrency {0}. ResultSet concurrency {1} is used. +01J08 +Unable to open resultSet type <resultSetType>. +ResultSet type <resultSetType> opened. -01J10 -Scroll sensitive result sets are not supported by server; remapping to forward-only cursor +01J10 +Scroll sensitive result sets are not supported by server; +remapping to forward-only cursor -01J11 -Insensitive updatable result sets are not supported by server; remapping to insensitive read-only cursor +01J12 +Unable to obtain message text from server. See the next +exception. The stored procedure SYSIBM.SQLCAMESSAGE is not installed on the +server. Please contact your database administrator. -01J12 -Unable to obtain message text from server. See the next exception. The stored procedure SYSIBM.SQLCAMESSAGE is not installed on the server. Please contact your database administrator. +01J13 +Number of rows returned (<number>) +is too large to fit in an integer; the value returned will be truncated. -01J13 -Number of rows returned ({0}) is too large to fit in an integer; the value returned will be truncated. - - -01J14 -SQL authorization is being used without first enabling authentication. +01J14 +SQL authorization is being used without first enabling +authentication. -

-Class 04: Database authentication +

Class 04: Database authentication @@ -158,13 +160,12 @@ -04501 -Database connection refused. +04501 +Database connection refused. -

-Class 07: Dynamic SQL Error +

Class 07: Dynamic SQL Error @@ -175,21 +176,22 @@ -07000 -At least one parameter to the current statement is uninitialized. +07000 +At least one parameter to the current statement is uninitialized. -07004 -Parameter {0} is an {1} procedure parameter and must be registered with CallableStatement.registerOutParameter before execution. +07004 +Parameter <parameterName> is an <procedureName> procedure +parameter and must be registered with CallableStatement.registerOutParameter +before execution. -07009 -No input parameters. +07009 +No input parameters. -

-Class 08: Connection Exception +

Class 08: Connection Exception @@ -200,101 +202,115 @@ -08000 -Cannot close a connection with an active transaction. The transaction remains open and the connection was not closed. +08000 +Connection closed by unknown interrupt. -08000 -Connection closed by unknown interrupt. +08000 +Cannot close a connection with an active transaction. + The transaction remains open and the connection was not closed. -08001 -Required Derby DataSource property {0} not set. +08001 +A connection could not be established because the security +token is larger than the maximum allowed by the network protocol. -08001 -{0} : Error connecting to server {1} on port {2} with message {3}. +08001 +A connection could not be established because the user +id has a length of zero or is larger than the maximum allowed by the network +protocol. -08001 -SocketException: '{0}' +08001 +A connection could not be established because the password +has a length of zero or is larger than the maximum allowed by the network +protocol. -08001 -Unable to open stream on socket: '{0}'. +08001 +Required property <propertyName> not +set. -08001 -User id length ({0}) is outside the range of 1 to {1}. +08001 +<error> : Error connecting to +server <serverName> on port <portNumber> with +message <messageText>. -08001 -Password length ({0}) is outside the range of 1 to {1}. +08001 +SocketException: '<error>' -08001 -User id can not be null. +08001 +Unable to open stream on socket: '<error>'. -08001 -Password can not be null. +08001 +User id length (<number>) is outside +the range of 1 to <number>. -08001 -A connection could not be established because the database name '{0}' is larger than the maximum length allowed by the network protocol. +08001 +Password length (<value>) is outside +the range of 1 to <number>. -08001 -A connection could not be established because the security token is larger than the maximum allowed by the network protocol. +08001 +User id can not be null. -08001 -A connection could not be established because the user id has a length of zero or is larger than the maximum allowed by the network protocol. +08001 +Password can not be null. -08001 -A connection could not be established because the password has a length of zero or is larger than the maximum allowed by the network protocol. +08001 +A connection could not be established because the database +name '<databaseName>' is larger than the maximum length +allowed by the network protocol. -08003 -No current connection. +08003 +No current connection. -08003 -getConnection() is not valid on a closed PooledConnection. +08003 +getConnection() is not valid on a closed PooledConnection. -08003 -Lob method called after connection was closed +08003 +Lob method called after connection was closed -08003 -The underlying physical connection is stale or closed. +08003 +The underlying physical connection is stale or closed. -08004 -Connection refused : {0} +08004 +Connection refused : <connectionName> -08004 -Connection authentication failure occurred. Reason: {0}. +08004 +Connection authentication failure occurred. Reason: <reasonText>. -08004 -The connection was refused because the database {0} was not found. +08004 +The connection was refused because the database <databaseName> was +not found. -08006 -Database '{0}' shutdown. +08006 +An error occurred during connect reset and the connection +has been terminated. See chained exceptions for details. -08006 -An error occurred during connect reset and the connection has been terminated. See chained exceptions for details. +08006 +Database '<databaseName>' shutdown. -

-Class 0A: Feature not supported +

Class 0A: Feature not supported @@ -305,41 +321,45 @@ -0A000 -Feature not implemented: {0}. +0A000 +Feature not implemented: <featureName>. -0A000 -The DRDA command {0} is not currently implemented. The connection has been terminated. +0A000 +The DRDA command <commandName> is +not currently implemented. The connection has been terminated. -0A000 -JDBC method is not yet implemented. +0A000 +JDBC method is not yet implemented. -0A000 -JDBC method {0} is not supported by the server. Please upgrade the server. +0A000 +JDBC method <methodName> is not +supported by the server. Please upgrade the server. -0A000 -resultSetHoldability property {0} not supported +0A000 +resultSetHoldability property <propertyName> not +supported -0A000 -cancel() not supported by the server. +0A000 +cancel() not supported by the server. -0A000 -Security mechanism '{0}' is not supported. +0A000 +Security mechanism '<mechanismName>' +is not supported. -0A000 -The data type '{0}' is not supported. +0A000 +The data type '<datatypeName>' +is not supported. -

-Class 21: Cardinality Violation +

Class 21: Cardinality Violation @@ -350,13 +370,12 @@ -21000 -Scalar subquery is only allowed to return a single row. +21000 +Scalar subquery is only allowed to return a single row. -

-Class 22: Data Exception +

Class 22: Data Exception @@ -367,133 +386,162 @@ -22001 -A truncation error was encountered trying to shrink {0} '{1}' to length {2}. +22001 +A truncation error was encountered trying to shrink <value> '<value>' +to length <value>. -22003 -The resulting value is outside the range for the data type {0}. +22003 +The resulting value is outside the range for the data +type <datatypeName>. -22003 -Year ({0}) exceeds the maximum '{1}'. +22003 +Year (<value>) exceeds the maximum +'<value>'. -22003 -Decimal may only be up to 31 digits. +22003 +Decimal may only be up to 31 digits. -22003 -Overflow occurred during numeric data type conversion of '{0}' to {1}. +22003 +Overflow occurred during numeric data type conversion +of '<datatypeName>' to <datatypeName>. -22004 -The length ({0}) exceeds the maximum length for the data type ({1}). +22004 +The length (<number>) exceeds +the maximum length for the data type (<datatypeName>). -22005 -An attempt was made to get a data value of type '{0}' from a data value of type '{1}'. +22005 +Unable to convert a value of type '<typeName>' +to type '<typeName>' : the encoding is not supported. -22005 -Unable to convert a value of type '{0}' to type '{1}' : the encoding is not supported. +22005 +The required character converter is not available. -22005 -The required character converter is not available. +22005 +Unicode string cannot convert to Ebcdic string -22005 -Unicode string cannot convert to Ebcdic string +22005 +Unrecognized JDBC type. Type: <typeName>, +columnCount: <value>, columnIndex: <value>. -22005 -Unrecognized JDBC type. Type: {0}, columnCount: {1}, columnIndex: {2}. +22005 +Invalid JDBC type for parameter <parameterName>. -22005 -Invalid JDBC type for parameter {0}. +22005 +Unrecognized Java SQL type <datatypeName>. -22005 -Unrecognized Java SQL type {0}. +22005 +An attempt was made to get a data value of type '<datatypeName>' +from a data value of type '<datatypeName>'. -22007 -The string representation of a datetime value is out of range. +22007 +The string representation of a datetime value is out +of range. -22007 -The syntax of the string representation of a datetime value is incorrect. +22007 +The syntax of the string representation of a datetime +value is incorrect. -22008 -'{0}' is an invalid argument to the {1} function. +22008 +'<argument>' is an invalid argument +to the <functionName> function. -2200L -Values assigned to XML columns must be well-formed DOCUMENT nodes. +2200L +Values assigned to XML columns must be well-formed DOCUMENT +nodes. -2200M -Failed to parse XMLPARSE operand; see next exception for details. +2200M +Failed to parse XMLPARSE operand; see next exception +for details. -2200V -Invalid context item for {0} operator; context items must be well-formed DOCUMENT nodes. +2200V +Invalid context item for <operatorName> operator; +context items must be well-formed DOCUMENT nodes. -22011 -The second or third argument of the SUBSTR function is out of range. +22011 +The second or third argument of the SUBSTR function +is out of range. -22012 -Attempt to divide by zero. +22012 +Attempt to divide by zero. -22013 -Attempt to take the square root of a negative number, '{0}'. +22013 +Attempt to take the square root of a negative number, +'<value>'. -22014 -The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '{2}'. The string to search for is '{0}'. The string to search from is '{1}'. +22014 +The start position for LOCATE is invalid; it must be +a positive integer. The index to start the search from is '<index>'. +The string to search for is '<index>'. The string to +search from is '<index>'. -22015 -The '{0}' function is not allowed on the following set of types. First operand is of type '{1}'. Second operand is of type '{2}'. Third operand (start position) is of type '{3}'. +22015 +Invalid data conversion: requested conversion would +result in a loss of precision of <value> -22015 -Invalid data conversion: requested conversion would result in a loss of precision of {0} +22015 +The '<functionName>' function +is not allowed on the following set of types. First operand is of type '<typeName>'. + Second operand is of type '<typeName>'. Third operand +(start position) is of type '<typeName>'. -22018 -Invalid character string format for type {0}. +22018 +Invalid character string format for type <typeName>. -22019 -Invalid escape sequence, '{0}'. The escape string must be exactly one character. It cannot be a null or more than one character. +22019 +Invalid escape sequence, '<sequenceName>'. +The escape string must be exactly one character. It cannot be a null or more +than one character. -22025 -Escape character must be followed by escape character, '_', or '%'. It cannot be followed by any other character or be at the end of the pattern. +22025 +Escape character must be followed by escape character, +'_', or '%'. It cannot be followed by any other character or be at the end +of the pattern. -22027 -The built-in TRIM() function only supports a single trim character. The LTRIM() and RTRIM() built-in functions support multiple trim characters. +22027 +The built-in TRIM() function only supports a single +trim character. The LTRIM() and RTRIM() built-in functions support multiple +trim characters. -22028 -The string exceeds the maximum length of {0}. +22028 +The string exceeds the maximum length of <number>. -22501 -An ESCAPE clause of NULL returns undefined results and is not allowed. +22501 +An ESCAPE clause of NULL returns undefined results and +is not allowed. -

-Class 23: Constraint Violation +

Class 23: Constraint Violation @@ -504,25 +552,30 @@ -23502 -Column '{0}' cannot accept a NULL value. +23502 +Column '<columnName>' cannot +accept a NULL value. -23503 -{2} on table '{1}' caused a violation of foreign key constraint '{0}' for key {3}. The statement has been rolled back. +23503 +<value> on table '<tableName>' +caused a violation of foreign key constraint '<constraintName>' +for key <keyName>. The statement has been rolled back. -23505 -The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by '{0}' defined on '{1}'. +23505 +The statement was aborted because it would have caused +a duplicate key value in a unique or primary key constraint or unique index +identified by '<value>' defined on '<value>'. -23513 -The check constraint '{1}' was violated while performing an INSERT or UPDATE on table '{0}'. +23513 +The check constraint '<constraintName>' +was violated while performing an INSERT or UPDATE on table '<tableName>'. -

-Class 24: Invalid Cursor State +

Class 24: Invalid Cursor State @@ -533,17 +586,16 @@ -24000 -Invalid cursor state - no current row. +24000 +Invalid cursor state - no current row. -24501 -The identified cursor is not open. +24501 +The identified cursor is not open. -

-Class 25: Invalid Transaction State +

Class 25: Invalid Transaction State @@ -554,33 +606,37 @@ -25000 -Invalid transaction state. +25000 +Invalid transaction state. -25001 -Cannot close a connection while a transaction is still active. +25001 +Cannot close a connection while a transaction is still +active. -25501 -Unable to set the connection read-only property in an active transaction. +25501 +Unable to set the connection read-only property in an +active transaction. -25502 -An SQL data change is not permitted for a read-only connection, user or database. +25502 +An SQL data change is not permitted for a read-only +connection, user or database. -25503 -DDL is not permitted for a read-only connection, user or database. +25503 +DDL is not permitted for a read-only connection, user +or database. -25505 -A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection. +25505 +A read-only user or a user in a read-only database is +not permitted to disable read-only mode on a connection. -

-Class 28: Invalid Authorization Specification +

Class 28: Invalid Authorization Specification @@ -591,73 +647,88 @@ -28501 -Invalid database authorization property '{0}={1}'. - - -28502 -The user name '{0}' is not valid. +28501 +Invalid database authorization property '<value>=<value>'. -28503 -User(s) '{0}' must not be in both read-only and full-access authorization lists. +28502 +The user name '<authorizationID>' +is not valid. -28504 -Repeated user(s) '{1}' in access list '{0}'; +28503 +User(s) '<authorizationID>' must +not be in both read-only and full-access authorization lists. -28505 -Internal Error: invalid {0} id in statement permission list. +28504 +Repeated user(s) '<authorizationID>' +in access list '<listName>'; -28506 -User '{0}' does not have {1} permission on table '{2}'.'{3}'. +28505 +Internal Error: invalid <authorizationID> id +in statement permission list. -28507 -User '{0}' does not have {1} permission on table '{2}'.'{3}' for grant. +28506 +User '<authorizationID>' does +not have <permissionType> permission on table '<schemaNamet>'.'<tableName>'. -28508 -User '{0}' does not have {1} permission on column '{2}' of table '{3}'.'{4}'. +28507 +User '<authorizationID>' does +not have <permissionType> permission on table '<schemaNamet>'.'<tableName>' +for grant. -28509 -User '{0}' does not have {1} permission on column '{2}' of table '{3}'.'{4}' for grant. +28508 +User '<authorizationID>' does +not have <permissionType> permission on column '<columnName>' +of table '<schemaName>'.'<tableName>'. -2850A -User '{0}' does not have execute permission on {1} '{2}'.'{3}'. +28509 +User '<authorizationID>' does +not have <permissionType> permission on column '<columnName>' +of table '<schemaName>'.'<tableName>' +for grant. -2850B -User '{0}' does not have execute permission on {1} '{2}'.'{3}' for grant. +2850A +User '<authorizationID>' does +not have execute permission on <objectName> '<schemaName>'.'<tableName>'. -2850C -User '{0}' is not the owner of {1} '{2}'.'{3}'. +2850B +User '<authorizationID>' does +not have execute permission on <objectName> '<schemaName>'.'<tableName>'. +for grant. -2850D -User '{0}' can not perform the operation in schema '{1}'. +2850C +User '<authorizationID>' is not +the owner of <objectName> '<schemaName>'.'<tableName>'. -2850E -User '{0}' can not create schema '{1}'. Only database owner could issue this statement. +2850D +User '<authorizationID>' can not +perform the operation in schema '<schemaName>'. -2850F -Specified grant or revoke operation is not allowed on object '{0}'. +2850E +User '<authorizationID>' can not +create schema '<schemaName>'. Only database owner could +issue this statement. -2850G -User '{0}' does not have {1} permission on object '{2}'.'{3}'. +2850F +Specified grant or revoke operation is not allowed on +object '<objectName>'. -

-Class 2D: Invalid Transaction Termination +

Class 2D: Invalid Transaction Termination @@ -668,17 +739,17 @@ -2D521 -setAutoCommit(true) invalid during global transaction. +2D521 +setAutoCommit(true) invalid during global transaction. -2D521 -COMMIT or ROLLBACK invalid for application execution environment. +2D521 +COMMIT or ROLLBACK invalid for application execution +environment. -

-Class 38: External Function Exception +

Class 38: External Function Exception @@ -689,25 +760,27 @@ -38000 -The exception '{0}' was thrown while evaluating an expression. +38000 +The exception '<exception>' was +thrown while evaluating an expression. -38001 -The external routine is not allowed to execute SQL statements. +38001 +The external routine is not allowed to execute SQL statements. -38002 -The routine attempted to modify data, but the routine was not defined as MODIFIES SQL DATA. +38002 +The routine attempted to modify data, but the routine +was not defined as MODIFIES SQL DATA. -38004 -The routine attempted to read data, but the routine was not defined as READS SQL DATA. +38004 +The routine attempted to read data, but the routine +was not defined as READS SQL DATA. -

-Class 39: External Routine Invocation Exception +

Class 39: External Routine Invocation Exception @@ -718,13 +791,13 @@ -39004 -A NULL value cannot be passed to a method which takes a parameter of primitive type '{0}'. +39004 +A NULL value cannot be passed to a method which takes +a parameter of primitive type '<type>'. -

-Class 3B: Invalid SAVEPOINT +

Class 3B: Invalid SAVEPOINT @@ -735,25 +808,27 @@ -3B001 -SAVEPOINT, {0} does not exist or is not active in the current transaction. +3B001 +SAVEPOINT, <savepoint> does not exist or is not +active in the current transaction. -3B002 -The maximum number of savepoints has been reached. +3B002 +The maximum number of savepoints has been reached. -3B501 -A SAVEPOINT with the passed name already exists in the current transaction. +3B501 +A SAVEPOINT with the passed name already exists in the +current transaction. -3B502 -A RELEASE or ROLLBACK TO SAVEPOINT was specified, but the savepoint does not exist. +3B502 +A RELEASE or ROLLBACK TO SAVEPOINT was specified, but +the savepoint does not exist. -

-Class 40: Transaction Rollback +

Class 40: Transaction Rollback @@ -764,66 +839,71 @@ -40001 -A lock could not be obtained due to a deadlock, cycle of locks and waiters is -{0}. The selected victim is XID : {1}. +40001 +A lock could not be obtained due to a deadlock, cycle +of locks and waiters is: <value>. The selected victim +is XID : <value>. -40XC0 -Dead statement. This may be caused by catching a transaction severity error inside this statement. +40XC0 +Dead statement. This may be caused by catching a transaction +severity error inside this statement. -40XD0 -Container has been closed +40XD0 +Container has been closed -40XD1 -Container was opened in read-only mode. +40XD1 +Container was opened in read-only mode. -40XD2 -Container {0} cannot be opened; it either has been dropped or does not exist. +40XD2 +Container <containerName> cannot +be opened; it either has been dropped or does not exist. -40XL1 -A lock could not be obtained within the time requested +40XL1 +A lock could not be obtained within the time requested -40XL2 -A lock could not be obtained within the time requested. The lockTable dump is: {0} +40XL2 +A lock could not be obtained within the time requested. + The lockTable dump is: <tableDump> -40XT0 -An internal error was identified by RawStore module. +40XT0 +An internal error was identified by RawStore module. -40XT1 -An exception was thrown during transaction commit. +40XT1 +An exception was thrown during transaction commit. -40XT2 -An exception was thrown during rollback of a SAVEPOINT. +40XT2 +An exception was thrown during rollback of a SAVEPOINT. -40XT4 -An attempt was made to close a transaction that was still active. The transaction has been aborted. +40XT4 +An attempt was made to close a transaction that was +still active. The transaction has been aborted. -40XT5 -Exception thrown during an internal transaction. +40XT5 +Exception thrown during an internal transaction. -40XT6 -Database is in quiescent state, cannot activate transaction. Please wait for a moment till it exits the quiescent state. +40XT6 +Database is in quiescent state, cannot activate transaction. + Please wait for a moment till it exits the quiescent state. -40XT7 -Operation is not supported in an internal transaction. +40XT7 +Operation is not supported in an internal transaction. -

-Class 42: Syntax Error or Access Rule Violation +

Class 42: Syntax Error or Access Rule Violation @@ -834,933 +914,1187 @@ -42000 -Syntax error or access rule violation; see additional errors for details. +42000 +Syntax error or access rule violation; see additional +errors for details. -42601 -ALTER TABLE statement cannot add an IDENTITY column to a table. +42601 +In an ALTER TABLE statement, the column '<columnName>' +has been specified as NOT NULL and either the DEFAULT clause was not specified +or was specified as DEFAULT NULL. -42601 -In an ALTER TABLE statement, the column '{0}' has been specified as NOT NULL and either the DEFAULT clause was not specified or was specified as DEFAULT NULL. +42601 +ALTER TABLE statement cannot add an IDENTITY column +to a table. -42605 -The number of arguments for function '{0}' is incorrect. +42605 +The number of arguments for function '<functionName>' +is incorrect. -42606 -An invalid hexadecimal constant starting with '{0}' has been detected. +42606 +An invalid hexadecimal constant starting with '<number>' +has been detected. -42610 -All the arguments to the COALESCE/VALUE function cannot be parameters. The function needs at least one argument that is not a parameter. +42610 +All the arguments to the COALESCE/VALUE function cannot +be parameters. The function needs at least one argument that is not a parameter. -42611 -The length, precision, or scale attribute for column, or type mapping '{0}' is not valid. +42611 +The length, precision, or scale attribute for column, +or type mapping '<value>' is not valid. -42613 -Multiple or conflicting keywords involving the '{0}' clause are present. +42613 +Multiple or conflicting keywords involving the '<clause>' +clause are present. -42621 -A check constraint or generated column that is defined with '{0}' is invalid. +42621 +A check constraint or generated column that is defined +with '<value>' is invalid. -42622 -The name '{0}' is too long. The maximum length is '{1}'. +42622 +The name '<name>' is too long. +The maximum length is '<number>'. -42734 -Name '{0}' specified in context '{1}' is not unique. +42734 +Name '<name>' specified in context +'<context>' is not unique. -42802 -The number of values assigned is not the same as the number of specified or implied columns. +42802 +The number of values assigned is not the same as the +number of specified or implied columns. -42803 -An expression containing the column '{0}' appears in the SELECT list and is not part of a GROUP BY clause. +42803 +An expression containing the column '<columnName>' +appears in the SELECT list and is not part of a GROUP BY clause. -42815 -The replacement value for '{0}' is invalid. +42815 +The replacement value for '<value>' +is invalid. -42815 -The data type, length or value of arguments '{0}' and '{1}' is incompatible. +42815 +The data type, length or value of arguments '<value>' +and '<value>' is incompatible. -42818 -Comparisons between '{0}' and '{1}' are not supported. +42818 +Comparisons between '<value>' +and 'value1>' are not supported. -42820 -The floating point literal '{0}' contains more than 30 characters. +42820 +The floating point literal '<string>' +contains more than 30 characters. -42821 -Columns of type '{0}' cannot hold values of type '{1}'. +42821 +Columns of type '<type>' cannot +hold values of type '<type>'. -42824 -An operand of LIKE is not a string, or the first operand is not a column. +42824 +An operand of LIKE is not a string, or the first operand +is not a column. -42831 -'{0}' cannot be a column of a primary key or unique key because it can contain null values. +42831 +'<columnName>' cannot be a column +of a primary key or unique key because it can contain null values. -42834 -SET NULL cannot be specified because FOREIGN KEY '{0}' cannot contain null values. +42834 +SET NULL cannot be specified because FOREIGN KEY '<key>' + cannot contain null values. -42837 -ALTER TABLE '{0}' specified attributes for column '{1}' that are not compatible with the existing column. +42837 +ALTER TABLE '<tableName>' specified +attributes for column '<columnName>' that are not compatible +with the existing column. -42846 -Cannot convert types '{0}' to '{1}'. +42846 +Cannot convert types '<type>' +to '<type>'. -42877 -A qualified column name '{0}' is not allowed in the ORDER BY clause. +42877 +A qualified column name '<columnName>' +is not allowed in the ORDER BY clause. -42884 -No authorized routine named '{0}' of type '{1}' having compatible arguments was found. +42884 +No authorized routine named '<routineName>' of type +'<type>' having compatible arguments was found. -42886 -'{0}' parameter '{1}' requires a parameter marker '?'. +42886 +'<value>' parameter '<value>' +requires a parameter marker '?'. -42894 -DEFAULT value or IDENTITY attribute value is not valid for column '{0}'. +42894 +DEFAULT value or IDENTITY attribute value is not valid +for column '<columnName>'. -428C1 -Only one identity column is allowed in a table. +428C1 +Only one identity column is allowed in a table. -428EK -The qualifier for a declared global temporary table name must be SESSION. +428EK +The qualifier for a declared global temporary table +name must be SESSION. -42903 -Invalid use of an aggregate function. +42903 +Invalid use of an aggregate function. -42908 -The CREATE VIEW statement does not include a column list. +42908 +The CREATE VIEW statement does not include a column +list. -42915 -Foreign Key '{0}' is invalid because '{1}'. +42915 +Foreign Key '<key>' is invalid +because '<value>'. -42916 -Synonym '{0}' cannot be created for '{1}' as it would result in a circular synonym chain. +42916 +Synonym '<synonym2>' cannot be +created for '<synonym1>' as it would result in a circular +synonym chain. -42939 -An object cannot be created with the schema name '{0}'. +42939 +An object cannot be created with the schema name '<schemaNamet>'. -42962 -Long column type column or parameter '{0}' not permitted in declared global temporary tables or procedure definitions. +42962 +Long column type column or parameter '<columnName>' +not permitted in declared global temporary tables or procedure definitions. -42972 -An ON clause associated with a JOIN operator is not valid. +42972 +An ON clause associated with a JOIN operator is not +valid. -42995 -The requested function does not apply to global temporary tables. +42995 +The requested function does not apply to global temporary +tables. -42X01 -Syntax error: {0}. +42X01 +Syntax error: <error>. -42X02 -{0}. +42X02 +<value>. -42X03 -Column name '{0}' is in more than one table in the FROM list. +42X03 +Column name '<columnName>' is +in more than one table in the FROM list. -42X04 -Column '{0}' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then '{0}' is not a column in the target table. +42X04 +Column '<columnName>' is either +not in any table in the FROM list or appears within a join specification and +is outside the scope of the join specification or appears in a HAVING clause +and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement +then '<columnName>' is not a column in the target table. -42X05 -Table/View '{0}' does not exist. +42X05 +Table/View '<objectName>' does +not exist. -42X06 -Too many result columns specified for table '{0}'. +42X06 +Too many result columns specified for table '<tableName>'. -42X07 -Null is only allowed in a VALUES clause within an INSERT statement. +42X07 +Null is only allowed in a VALUES clause within an INSERT +statement. -42X08 -The constructor for class '{0}' cannot be used as an external virtual table because the class does not implement '{1}'. +42X08 +The constructor for class '<className>' +cannot be used as an external virtual table because the class does not implement +'<constructorName>'. -42X09 -The table or alias name '{0}' is used more than once in the FROM list. +42X09 +The table or alias name '<tableName>' +is used more than once in the FROM list. -42X10 -'{0}' is not an exposed table name in the scope in which it appears. +42X10 +'<tableName>' is not an exposed +table name in the scope in which it appears. -42X12 -Column name '{0}' appears more than once in the CREATE TABLE statement. +42X12 +Column name '<columnName>' appears +more than once in the CREATE TABLE statement. -42X13 -Column name '{0}' appears more than once times in the column list of an INSERT statement. +42X13 +Column name '<columnName>' appears +more than once times in the column list of an INSERT statement. -42X14 -'{0}' is not a column in table or VTI '{1}'. +42X14 +'<columnName>' is not a column +in table or VTI '<value>'. -42X15 -Column name '{0}' appears in a statement without a FROM list. +42X15 +Column name '<columnName>' appears +in a statement without a FROM list. -42X16 -Column name '{0}' appears multiple times in the SET clause of an UPDATE statement. +42X16 +Column name '<columnName>' appears +multiple times in the SET clause of an UPDATE statement. -42X17 -In the Properties list of a FROM clause, the value '{0}' is not valid as a joinOrder specification. Only the values FIXED and UNFIXED are valid. +42X17 +In the Properties list of a FROM clause, the value '<value>' +is not valid as a joinOrder specification. Only the values FIXED and UNFIXED +are valid. -42X19 -The WHERE or HAVING clause or CHECK CONSTRAINT definition is a '{0}' expression. It must be a BOOLEAN expression. +42X19 +The WHERE or HAVING clause or CHECK CONSTRAINT definition +is a '<value>' expression. It must be a BOOLEAN expression. -42X23 -Cursor {0} is not updatable. +42X23 +Cursor <cursorName> is not updatable. -42X25 -The '{0}' function is not allowed on the '{1}' type. +42X25 +The '<functionName>' function +is not allowed on the '<1>' type. -42X26 -The class '{0}' for column '{1}' does not exist or is inaccessible. This can happen if the class is not public. +42X26 +The class '<className>' for column +'<columnName>' does not exist or is inaccessible. This +can happen if the class is not public. -42X28 -Delete table '{0}' is not target of cursor '{1}'. +42X28 +Delete table '<tableName>' is +not target of cursor '<cursorName>'. -42X29 -Update table '{0}' is not the target of cursor '{1}'. +42X29 +Update table '<tableName>' is +not the target of cursor '<cursorName>'. -42X30 -Cursor '{0}' not found. Verify that autocommit is OFF. +42X30 +Cursor '<cursorName>' not found. +Verify that autocommit is OFF. -42X31 -Column '{0}' is not in the FOR UPDATE list of cursor '{1}'. +42X31 +Column '<columnName>' is not in +the FOR UPDATE list of cursor '<cursorName>'. -42X32 -The number of columns in the derived column list must match the number of columns in table '{0}'. +42X32 +The number of columns in the derived column list must +match the number of columns in table '<tableName>'. -42X33 -The derived column list contains a duplicate column name '{0}'. +42X33 +The derived column list contains a duplicate column +name '<columnName>'. -42X34 -There is a ? parameter in the select list. This is not allowed. +42X34 +There is a ? parameter in the select list. This is +not allowed. -42X35 -It is not allowed for both operands of '{0}' to be ? parameters. +42X35 +It is not allowed for both operands of '<value>' +to be ? parameters. -42X36 -The '{0}' operator is not allowed to take a ? parameter as an operand. +42X36 +The '<operator>' operator is not +allowed to take a ? parameter as an operand. -42X37 -The unary '{0}' operator is not allowed on the '{1}' type. +42X37 +The unary '<operator>' operator +is not allowed on the '<type>' type. -42X38 -'SELECT *' only allowed in EXISTS and NOT EXISTS subqueries. +42X38 +'SELECT *' only allowed in EXISTS and NOT EXISTS subqueries. -42X39 -Subquery is only allowed to return a single column. +42X39 +Subquery is only allowed to return a single column. -42X40 -A NOT statement has an operand that is not boolean . The operand of NOT must evaluate to TRUE, FALSE, or UNKNOWN. +42X40 +A NOT statement has an operand that is not boolean . +The operand of NOT must evaluate to TRUE, FALSE, or UNKNOWN. -42X41 -In the Properties clause of a FROM list, the property '{0}' is not valid (the property was being set to '{1}'). +42X41 +In the Properties clause of a FROM list, the property +'<propertyName>' is not valid (the property was being +set to '<value>'). -42X42 -Correlation name not allowed for column '{0}' because it is part of the FOR UPDATE list. +42X42 +Correlation name not allowed for column '<columnName>' +because it is part of the FOR UPDATE list. -42X43 -The ResultSetMetaData returned for the class/object '{0}' was null. In order to use this class as an external virtual table, the ResultSetMetaData cannot be null. +42X43 +The ResultSetMetaData returned for the class/object +'<className>' was null. In order to use this class as +an external virtual table, the ResultSetMetaData cannot be null. -42X44 -Invalid length '{0}' in column specification. +42X44 +Invalid length '<number>' in column +specification. -42X45 -{0} is an invalid type for argument number {1} of {2}. +42X45 +<type> is an invalid type for +argument number <value> of <value>. -42X46 -There are multiple functions named '{0}'. Use a the full signature or the specific name. +42X46 +There are multiple functions named '<functionName>'. +Use a the full signature or the specific name. -42X47 -There are multiple procedures named '{0}'. Use a the full signature or the specific name. +42X47 +There are multiple procedures named '<procedureName>'. +Use a the full signature or the specific name. -42X48 -Value '{1}' is not a valid precision for {0}. +42X48 +Value '<value>' is not a valid +precision for <value>. -42X49 -Value '{0}' is not a valid integer literal. +42X49 +Value '<value>' is not a valid +integer literal. -42X50 -No method was found that matched the method call {0}.{1}({2}), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. +42X50 +No method was found that matched the method call <methodName>.<value>(<value>), tried all combinations of object and primitive types and any possible +type conversion for any parameters the method call may have. The method might +exist but it is not public and/or static, or the parameter types are not method +invocation convertible. -42X51 -The class '{0}' does not exist or is inaccessible. This can happen if the class is not public. +42X51 +The class '<className>' does not +exist or is inaccessible. This can happen if the class is not public. -42X52 -Calling method ('{0}') using a receiver of the Java primitive type '{1}" is not allowed. +42X52 +Calling method ('<methodName>') +using a receiver of the Java primitive type '<type>" +is not allowed. -42X53 -The LIKE predicate can only have 'CHAR' or 'VARCHAR' operands. Type '{0}' is not permitted. +42X53 +The LIKE predicate can only have 'CHAR' or 'VARCHAR' +operands. Type '<type>' is not permitted. -42X54 -The Java method '{0}' has a ? as a receiver. This is not allowed. +42X54 +The Java method '<methodName>' +has a ? as a receiver. This is not allowed. -42X55 -Table name '{1}' should be the same as '{0}'. +42X55 +Table name '<tableName>' should +be the same as '<value>'. -42X56 -The number of columns in the view column list does not match the number of columns in the underlying query expression in the view definition for '{0}'. +42X56 +The number of columns in the view column list does not +match the number of columns in the underlying query expression in the view +definition for '<value>'. -42X57 -The getColumnCount() for external virtual table '{0}' returned an invalid value '{1}'. Valid values are greater than or equal to 1. +42X57 +The getColumnCount() for external virtual table '<tableName>' +returned an invalid value '<value>'. Valid values are +greater than or equal to 1. -42X58 -The number of columns on the left and right sides of the {0} must be the same. +42X58 +The number of columns on the left and right sides of +the <tableName> must be the same. -42X59 -The number of columns in each VALUES constructor must be the same. +42X59 +The number of columns in each VALUES constructor must +be the same. -42X60 -Invalid value '{0}' for insertMode property specified for table '{1}'. +42X60 +Invalid value '<value>' for insertMode +property specified for table '<tableName>'. -42X61 -Types '{0}' and '{1}' are not {2} compatible. +42X61 +Types '<type>' and '<type>' +are not <value> compatible. -42X62 -'{0}' is not allowed in the '{1}' schema. +42X62 +'<value>' is not allowed in the +'<schemaNamet>' schema. -42X63 -The USING clause did not return any results. No parameters can be set. +42X63 +The USING clause did not return any results. No parameters +can be set. -42X64 -In the Properties list, the invalid value '{0}' was specified for the useStatistics property. The only valid values are TRUE or FALSE. +42X64 +In the Properties list, the invalid value '<value>' +was specified for the useStatistics property. The only valid values are TRUE +or FALSE. -42X65 -Index '{0}' does not exist. +42X65 +Index '<index>' does not exist. -42X66 -Column name '{0}' appears more than once in the CREATE INDEX statement. +42X66 +Column name '<columnName>' appears +more than once in the CREATE INDEX statement. -42X68 -No field '{0}' was found belonging to class '{1}'. It may be that the field exists, but it is not public, or that the class does not exist or is not public. +42X68 +No field '<fieldName>' was found +belonging to class '<className>'. It may be that the +field exists, but it is not public, or that the class does not exist or is +not public. -42X69 -It is not allowed to reference a field ('{0}') using a referencing expresssion of the Java primitive type '{1}'. +42X69 +It is not allowed to reference a field ('<fieldName>') +using a referencing expresssion of the Java primitive type '<type>'. -42X72 -No static field '{0}' was found belonging to class '{1}'. The field might exist, but it is not public and/or static, or the class does not exist or the class is not public. +42X72 +No static field '<fieldName>' +was found belonging to class '<className>'. The field +might exist, but it is not public and/or static, or the class does not exist +or the class is not public. -42X73 -Method resolution for signature {0}.{1}({2}) was ambiguous. (No single maximally specific method.) +42X73 +Method resolution for signature <value>.<value>(<value>) +was ambiguous. (No single maximally specific method.) -42X74 -Invalid CALL statement syntax. +42X74 +Invalid CALL statement syntax. -42X75 -No constructor was found with the signature {0}({1}). It may be that the parameter types are not method invocation convertible. +42X75 +No constructor was found with the signature <value>(<value>). + It may be that the parameter types are not method invocation convertible. -42X76 -At least one column, '{0}', in the primary key being added is nullable. All columns in a primary key must be non-nullable. +42X76 +At least one column, '<columnName>', +in the primary key being added is nullable. All columns in a primary key must +be non-nullable. -42X77 -Column position '{0}' is out of range for the query expression. +42X77 +Column position '<columnPosition>' +is out of range for the query expression. -42X78 -Column '{0}' is not in the result of the query expression. +42X78 +Column '<columnName>' is not in +the result of the query expression. -42X79 [... 4574 lines stripped ...]