JDBC Driver for SQL/MX Programmer's Reference

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]
29029 22003 The scale value from SQL/MX ({0}) is negative
for column/parameter number {1,number,integer}
Cause: The setBigDecimal()method is attempting to insert data into a column with a
negative scale.
Effect: An exception is thrown; data is not updated.
Recovery: Make sure that the scale is positive for the NUMERIC column or DECIMAL column.
[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