JDBC Driver for SQL/MX Programmer's Reference

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.
[back to the top]
29016 22018 SQL column {0,number,integer} data type can
not be converted to the specified Java data type
Cause: Attempted to convert a non-numeric string to BigDecimal using the
ResultSet.getLong() method.
Effect: An exception is reported and no data is obtained.
Recovery: Ensure that the column is a valid type to be converted.
[back to the top]
29017 HY004 SQL data type not supported
Cause: An unsupported SQL data type was detected in a setter method.
Effect: ARRAY, BINARY, BIT, DATALINK, JAVA_OBJECT, and REF data types are not
supported.
Recovery: Use a supported data type with the JDBC setter method.
[back to the top]
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.
[back to the top]
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.