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

Chapter 11. Messages
Prev Next
Chapter 11. Messages
About the Message Format
Type 4 Driver Error Messages
About the Message Format
Messages are listed in numerical SQLCODE order. Descriptions include the following:
SQLCODE SQLSTATE message-text
Cause [ What occurred to trigger the message.]
Effect [ What is the result when this occurs. ]
Recovery [ How to diagnose and fix the problem. ]
Type 4 Driver Error Messages
29001 HYC00 Unsupported feature - {0}
Cause. The feature listed is not supported by the JDBC driver.
Effect. An unsupported exception is thrown, and null
resultSet is returned.
Recovery. Remove the feature functionality from the program.
29002 08003 Connection does not exist
Cause. An action was attempted when the connection to the database was closed.
Effect. The database is inaccessible.
Recovery. Retry the action after the connection to the database is established.
29003 HY000 Statement does not exist
Cause. A validation attempt was made on the getter or exec invocation on a closed statement.
Effect. The getter or exec invocation validation fails.
Recovery. Issue
validateGetInvocation() or validateExecDirectInvocation when the statement is open.
29004 HY024 Invalid transaction isolation value
Cause. An attempt was made to set the transaction isolation level to an invalid value.
Effect. SQLMXConnection.setTransactionIsolation does not set the transaction isolation value.
Recovery. Valid isolation values are:
SQL_TXN_READ_COMMITTED, SQL_TXN_READ_UNCOMMITTED, SQL_TXN_REPEATABLE_READ, and
SQL_TXN_SERIALIZABLE. If no isolation value is specified, the default is SQL_TXN_READ_COMMITTED.
29005 HY024 Invalid ResultSet type
Cause. An attempt was made to set an invalid
ResultSet Type value.
Effect. The SQLMXStatement call with the
resultSetType parameter fails.
Recovery. Valid
ResultSet types are: TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, and TYPE_SCROLL_SENSITIVE.
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.
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.