JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

Cause: Attempted to access a
BLOB
column without setting the property
blobTableName
, or the property is set to an
invalid value.
Effect: The application cannot access BLOB columns.
Recovery: Set the blobTableName property to a valid LOB table name. The LOB table name is of format
catalog.schema.lobTableName.
[back to the top
29060 HY000 'clobTableName' property is not set or set to null value or set to invalid value
Cause: clobTableName property is not set or is set to null value or set to an invalid value.
Effect: The application cannot access CLOB columns.
Recovery: Set the clobTableName property to a valid LOB table name. The LOB table name is of format
catalog.schema.lobTableName.
[back to the top]
29061 HY000 Lob object {0} is not current
Cause: Attempted to access a CLOB column without setting the property jdbcmx.clobTableName or the property is set
to an invalid value.
Effect: The application cannot access CLOB columns.
Recovery: Set the jdbcmx.clobTableName property to a valid LOB table name. The LOB table name is of format
catalog.schema.lobTableName.
[back to the top]
29062 HY000 Operation not allowed since primary key columns are not in the select list
Cause: getKeyColumns() fails on table created without a primary key column.
Effect: No primary key data is returned for table.
Recovery: Alter the table to include a primary key column, or remove the getKeyColumns() method call from the
program.
[back to the top]
29063 HY000 Transaction error {0} - {1} while obtaining start data locator
Cause: A transaction error occurred when the JDBC/MX driver attempted to reserve the data locators for the given
process while inserting or updating a LOB column.
Effect: The application cannot insert or update the LOB columns.
Recovery: Check the file-system error in the message and take recovery action accordingly.
[back to the top]
29064 22018 Java data type does not match SQL data type for
column
Cause: Attempted to call a PreparedStatement setter method with an invalid column data type.
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]