JDBC Type 2 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

Recovery: Disable
AutoCommit
. Use the method only when the
AutoCommit
mode is disabled.
[back to the top]
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.
[back to the top]
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.
[back to the top]
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.
[back to the top]
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.
[back to the top]
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.
[back to the top]
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