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

29019 07002 Parameter {0, number, integer} for {1, number, integer} set of
parameters is not set
Cause: An input descriptor contains a parameter that does not have a value set.
Effect: The method checkIfAllParamsSet() reports the parameter that is not set.
Recovery: Set a value for the listed parameter.
nl
29020 07009 Invalid parameter index
Cause: A getter or setter method parameter count index is outside of the valid input-descriptor
range, or the input-descriptor range is null.
Effect: The getter and setter method invocation validation fails.
Recovery: Change the getter or setter parameter index to a valid parameter value.
nl
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.
nl
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.
nl
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.
nl
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.
nl
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.
nl
Messages From the Java Side of the JDBC/MX Driver 83