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

Recovery.
ASCII (ISO88591), KANJI, KSC5601, and UCS2 are the only supported character encodings. SQL/MP tables do not support UCS2
character encoding.
29037 HY106 ResultSet type is TYPE_FORWARD_ONLY
Cause. An attempt was made to point a
ResultSet cursor to a previous row when the object type is set as TYPE_FORWARD_ONLY.
Effect. The
ResultSet object cursor manipulation does not occur.
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.
29044 HY000 Query timeout value is not valid
Cause. An attempt was made to set a value of less than 0 for the number of seconds the driver waits for a
Statement object to execute.
Effect. The query timeout limit is not set.
Recovery. For the setQueryTimeout() method, supply a valid value that is greater than or equal to 0.
29045 01S07 Fractional truncation
Cause. The data retrieved by the
ResultSet getter method has been truncated.
Effect. The data retrieved is truncated.
Recovery. Make sure that the data to be retrieved is within a valid data-type range.
29046 22003 Numeric value out of range
Cause. A value retrieved from the
ResultSet getter method is outside the range for the data type.
Effect. The ResultSet getter method does not retrieve the data.
Recovery. Make sure the data to be retrieved is within a valid data-type range.