MX 2.x)

29065 22018 Java data type cannot be converted to the specified SQL data type

Cause: A PreparedStatement setter method Java object conversion to the given SQL data type is invalid.

Effect: An exception is thrown; data is not updated.

Recovery: Make sure that the column data type is valid for the PreparedStatement setter method.

[back to the top]

29066 22018 The String data {0} cannot be converted to a numeric value

Cause: A PreparedStatement setter method could not convert a string to an integer.

Effect: An exception is thrown and the string data is not converted.

Recovery: Make sure that the data to be converted to an integer is valid.

[back to the top]

29067 07009 Invalid input value in the method {0}

Cause: One or more input values in the given method is invalid.

Effect: The given input method failed.

Recovery: Check the input values for the given method.

[back to the top]

29068 07009 The value for position can be any value between 1 and one more than the length

of the LOB data

Cause: The position input value in Blob.setBinaryStream, Clob.setCharacterStream, or Clob.setAsciiStream

can be between 1 and one more than the length of the LOB data.

Effect: The application cannot write the LOB data at the specified position.

Recovery: Correct the position input value.

[back to the top]

29069 HY000 Autocommit is on and LOB objects are involved

Cause: LOB data is involved with autocommit enabled and an external transaction does not exist.

Effect: An exception is reported; the LOB columns are not set.

Recovery: Start an external transaction or disable the autocommit mode when using the Clob.setASciiStream(),

Clob.setCharacterStream(), or Blob.setBinaryStream() method.

[back to the top]

29070 HY000 Transaction error {0} - {1} while updating LOB tables

Cause: An SQL or file system (FS) exception occurred during insert or update operations on the base and LOB tables

within an internal transaction.

Effect: An exception is reported; the internal transaction is rolled back.

Recovery: See the SQL or FS error message.

[back to the top]