JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

Recovery. TYPE_FORWARD_ONLY ResultSet object type cursors can move forward only.
TYPE_SCROLL_SENSITIVE and TYPE_SCROLL_INSENSITIVE types are scrollable.
29038 HY107 Row number is not valid
Cause. A ResultSet absolute() method was called when the row number was set to 0.
Effect. The cursor is not moved to the specified row number.
Recovery. Supply a positive row number (specifying the row number counting from the beginning of the
result set), or supply a negative row number (specifying the row number counting from the end of the
result set).
29039 HY092 Concurrency mode of the ResultSet is CONCUR_READ_ONLY
Cause. An action was attempted on a ResultSet object that cannot be updated because the
concurrency is set to CONCUR_READ_ONLY.
Effect. The ResultSet object is not modified.
Recovery. For updates, you must set the ResultSet object concurrency to CONCUR_UPDATABLE.
29040 HY000 Operation invalid. Current row is the insert row
Cause. An attempt was made to retrieve update, delete, or insert information on the current insert row.
Effect. The ResultSet row information retrieval does not succeed.
Recovery. To retrieve row information, move the ResultSet object cursor away from the insert row.
29041 HY000 Operation invalid. No primary key for the table
Cause. The getKeyColumns() method failed on a table that was created without a primary-key
column defined.
Effect. No primary-key data is returned for the table.
Recovery. Change the table to include a primary-key column.
29042 HY000 Fetch size value is not valid
Cause. An attempt was made to set the fetch-row size to a value that is less than 0.
Effect. The number of rows that are fetched from the database when more rows are needed is not set.
Recovery. For the setFetchSize() method, supply a valid row value that is greater than or equal to
0.
29043 HY000 Max rows value is not valid
Cause. An attempt was made to set a limit of less than 0 for the maximum number of rows that any
ResultSet object can contain.
Effect. The limit for the maximum number of rows is not set.
Recovery. For the setMaxRows() method, use a valid value that is greater than or equal to 0.