JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
29005 HY024 Invalid ResultSet type
Cause: An attempt was made to set an invalid ResultSet Type value.
Effect: The SQLMX Statement call with the resultSetType parameter fails.
Recovery: Valid ResultSet types are: TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE,
and TYPE_SCROLL_SENSITIVE.
nl
29006 HY000 Invalid Result Set concurrency
Cause: An attempt was made to set an invalid result-set concurrency value.
Effect: The SQLMXStatement call with resultSetConcurrency fails.
Recovery: Valid resultSetConcurrency values are: CONCUR_READ_ONLY and
CONCUR_UPDATABLE.
nl
29007 07009 Invalid descriptor index
Cause: A ResultSetMetadata column parameter or a ParameterMetaData param parameter
is outside of the descriptor range.
Effect: The ResultSetMetadata or ParameterMetaData method data is not returned as
expected.
Recovery: Validate the column or parameter that is supplied to the method.
nl
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.
nl
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.
nl
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 findColum(),
validateGetInvocation(), and validateUpdInvocation() methods.
nl
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.
nl
Messages From the Java Side of the JDBC/MX Driver 81










