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

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.

29014 HY000 SQL data type not recognized

Cause: An unrecognized SQL data type was detected by JDBC.

Effect: An exception is thrown; data is not updated.

Recovery: Make sure that the SQL data type is supported by JDBC. The error is internal to the

JDBC/MX driver.

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.

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.

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.

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.

82 Messages