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

29008 24000 Invalid cursor state
Cause. The ResultSet method was called when the connection was closed.
Effect. The method call does not succeed.
Recovery. Make sure the connection is open before making the ResultSet method call.
29009 HY109 Invalid cursor position
Cause. An attempt was made to perform a
deleteRow() method or updateRow() method or cancelRowUpdates method when the ResultSet row
cursor was on the insert row. Or an attempt was made to perform the
insertRow() method when the ResultSet row cursor was not on the insert
row.
Effect. The row changes and cursor manipulation do not succeed.
Recovery. To insert a row, move the cursor to the insert row. To delete, cancel, or update a row, move the cursor from the insert row.
29010 07009 Invalid column name
Cause. A column search does not contain
columnName string.
Effect. The column comparison or searches do not succeed.
Recovery. Supply a valid columnName string to the findColumn(), validateGetInvocation(), and validateUpdInvocation() methods.
29011 07009 Invalid column index or descriptor index
Cause. A
ResultSet method was issued that has a column parameter that is outside of the valid range.
Effect. The
ResultSet method data is not returned as expected.
Recovery. Make sure to validate the column that is supplied to the method.
29012 07006 Restricted data type attribute violation
Cause. An attempt was made to execute a method either while an invalid data type was set or the data type did not match the SQL column
type.
Effect. The interface method is not executed.
Recovery. Make sure the correct method and Java data type is used for the column type.
29013 HY024 Fetch size is less than 0
Cause. The size set for
ResultSet.setFetchSize rows to fetch is less than zero.
Effect. The number of rows that need to be fetched from the database when more rows are needed for a
ResultSet object is not set.
Recovery. Set the
setFetchSize() method rows parameter to a value greater than zero.
29015 HY024 Invalid fetch direction
Cause. The
setFetchDirection() method direction parameter is set to an invalid value.
Effect. The direction in which the rows in this
ResultSet object are processed is not set.
Recovery. Valid fetch directions are:
ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, and ResultSet.FETCH_UNKNOWN.
29017 HY004 SQL data type not supported
Cause. An unsupported
getBytes() or setBytes() JDBC method call was issued using a BINARY, VARBINARY, or LONGVARBINARY data type.
Effect.
BINARY, VARBINARY, and LONGVARBINARY data types are not supported.
Recovery. Informational message only; no corrective action is needed.
29018 22018 Invalid character value in cast specification
Cause. An attempt was made to convert a string to a numeric type but the string does not have the appropriate format.
Effect. Strings that are obtained through a getter method cannot be cast to the method type.
Recovery. Validate the string in the database to make sure it is a compatible type.
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.
29020 07009 Invalid parameter index