JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)
Cause.
A getter or setter method parameter count index is outside of the valid input-descriptor range, or the input-descriptor range is null.
Effect. The getter and setter method invocation validation fails.
Recovery. Change the getter or setter parameter index to a valid parameter value.
29021 HY004 Object type not supported
Cause. A
PreparedStatement.setObject() method call contains an unsupported Object Type.
Effect. The
setObject() method does not set a value for the designated parameter.
Recovery. Informational message only; no corrective action is needed. Valid Object Types are:
null, BigDecimal, Date, Time, Timestamp,
Double, Float, Long, Short, Byte, Boolean, String, byte[], Clob, and Blob.
29022 HY010 Function sequence error
Cause. The
PreparedStatement.execute() method does not support the use of the PreparedStatement.addBatch() method.
Effect. An exception is reported; the operation is not completed.
Recovery. Use the PreparedStatement.executeBatch() method.
29026 HY000 Transaction can't be committed or rolled back when AutoCommit mode is on
Cause. An attempt was made to commit a transaction while
AutoCommit mode is enabled.
Effect. The transaction is not committed.
Recovery. Disable AutoCommit. Use the method only when the AutoCommit mode is disabled.
29027 HY011 SetAutoCommit not possible, since a transaction is active
Cause. An attempt was made to call the
setAutoCommit() mode while a transaction was active.
Effect. The current
AutoCommit mode is not modified.
Recovery. Complete the transaction, then attempt to set the
AutoCommit mode.
29029 HY011 SetTransactionIsolation not possible, since a transaction is active
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.










