JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

29026 HY000 Transaction can't be committed or rolled back when

AutoCommit mode is on

Cause: An attempt was made to commit a transaction while AutoCommit mode is enabled.

Effect: The transaction is not committed.

Recovery: Disable AutoCommit. Use the method only when the AutoCommit mode is disabled.

29027 HY011 SetAutoCommit not possible, since a transaction is active

Cause: An attempt was made to call the setAutoCommit() mode while a transaction was active.

Effect: The current AutoCommit mode is not modified.

Recovery: Complete the transaction, then attempt to set the AutoCommit mode.

29028 22003 The data value ({0}) is negative, but the column/parameter

number {1,number,integer} is unsigned

Cause: An attempt was made to set a negative value into an unsigned column.

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

Recovery: Make sure that the value is within the valid range for the column type.

29030 22003 The data value ({0}) had to be rounded up for

column/parameter number {1,number,integer}

Cause: The setBigDecimal() method rounded up a value to be inserted into a column.

Effect: An SQLWarning is issued to indicate that a value is rounded up. Data is entered into

database column.

Recovery: None. This is a warning condition.

29031 HY000 SQL SELECT statement in batch is illegal

Cause: A SELECT SQL statement was used in the executeBatch() method.

Effect: An exception is reported; the SELECT SQL query cannot be used in batch queries.

Recovery: Use the executeQuery() method to issue the SELECT SQL statement.

29032 23000 Row has been modified since it is last read

Cause: An attempt was made to update or delete a ResultSet object row while the cursor was

on the insert row.

Effect: The ResultSet row modification does not succeed.

Recovery: Move the ResultSet object cursor away from the row before updating or deleting the

row.

29033 23000 Primary key column value can't be updated

Cause: An attempt was made to update the primary-key column in a table.

Effect: The column is not updated.

Recovery: Columns in the primary-key definition cannot be updated and cannot contain null values,

even if you omit the NOT NULL clause in the column definition.

84 Messages