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

[back to the top]
29021 HY004 Object type not supported
Cause: A prepared-statement setObject() method call contains an unsupported Object Type.
Effect: The setObject() method does not set a value for the designated parameter.
Recovery: Informational message only; no corrective action is needed. Valid Object Types are: null, BigDecimal,
Date, Time, Timestamp, Double, Float, Long, Short, Byte, Boolean, String, byte[], Clob, and Blob.
[back to the top]
29022 HY010 Function sequence error
Cause: The PreparedStatement.execute() method does not support the use of the PreparedStatement.addBatch()
method.
Effect: An exception is reported; the operation is not completed.
Recovery: Use the PreparedStatement.executeBatch() method.
[back to the top]
29023 HY109 The cursor is before the first row, therefore no data can be retrieved.
Cause: getCurrentRow() is called when the cursor is before the first row.
Effect: An exception is reported; no data is retrieved.
Recovery: Validate the application call to the getCurrentRow() method.
[back to the top]
29024 HY109 The cursor is after last row, which could be due to the result set containing no
rows,
or all rows have been retrieved.
Cause: getCurrentRow() is called when the cursor is after the last row.
Effect: An exception is reported; no data is retrieved.
Recovery: Validate the application call to the getCurrentRow() method.
[back to the top]
29025 22003 The data value ({0}) is out of range for column/parameter number
{1,number,integer}
Cause: An attempt was made to set or get a value to or from the database when the value is outside the valid range for
the column data type.
Effect: An exception is thrown; data is not retrieved or updated.
Recovery: Make sure that the value is within the valid range for the column type.
[back to the top]
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.