JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

11 Messages
• “About the Message Format” (page 86)
• “Type 4 Driver Error Messages” (page 86)
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 throw, and null resultSet is returned.
Recovery: Remove the feature functionality from the program.
nl
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.
nl
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.
nl
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.
nl
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.
nl
86 Messages