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

[back to the top]
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 cannot 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.
[back to the top]
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.