JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)
Cause. An attempt was made to set transaction isolation level while a transaction was active.
Effect. Attempts to change the transaction isolation level for this Connection object fail.
Recovery. Complete the transaction, then attempt to set the transaction isolation level.
29031 HY000 SQL SELECT statement in batch is illegal
Cause. A SELECT SQL statement was used in the executeBatch() method.
Effect. An exception is reported; the SELECT SQL query cannot be used in batch queries.
Recovery. Use the executeQuery() method to issue the SELECT SQL statement.
29032 23000 Row has been modified since it is last read
Cause. An attempt was made to update or delete a ResultSet object row while the cursor was on the
insert row.
Effect. The ResultSet row modification does not succeed.
Recovery. Move the ResultSet object cursor away from the row before updating or deleting the row.
29033 23000 Primary key column value can't be updated
Cause. An attempt was made to update the primary-key column in a table.
Effect. The column is not updated.
Recovery. Columns in the primary-key definition cannot be updated and cannot contain null values, even
if you omit the NOT NULL clause in the column definition.
29035 HY000 IO Exception occurred {0}
Cause. An ASCII or Binary or Character stream setter or an updater method resulted in a
java.io.IOException.
Effect. The designated setter or updater method does not modify the ASCII or Binary or Character
stream.
Recovery. Informational message only; no corrective action is needed.
29036 HY000 Unsupported encoding {0}
Cause. The character encoding is not supported.
Effect. An exception is thrown when the requested character encoding is not supported.
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.










