JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Recovery: Before calling the begintransaction() method, validate whether other transactions
are currently started.
nl
29050 HY107 Row value out of range
Cause: A call to getCurrentRow retrieved is outside the first and last row range.
Effect: The current row is not retrieved.
Recovery: It is an informational message only; no recovery is needed. Report the entire message
to your service provider.
nl
29051 01S02 ResultSet type changed to TYPE_SCROLL_INSENSITIVE
Cause: The Result Set Type was changed.
Effect: None.
Recovery: This message is reported as an SQL Warning. It is an informational message only; no
recovery is needed.
nl
29052 22003 The Timestamp ({0}) is not in format yyyy-mm-dd
hh:mm:ss.fffffffff for column/parameter number {1,number,integer}`
Cause: An attempt was made to enter an invalid timestamp format into a TIMESTAMP column
type.
Effect: An exception is thrown; data is not updated.
Recovery: Make sure that a timestamp in the form of yyyy-mm-dd hh:mm:ss.fffffffff is
used.
nl
29053 HY000 SQL SELECT statement is invalid in executeUpdate() method
Cause: A select SQL statement was used in the executeUpdate() method.
Effect: The SQL query not performed exception is reported.
Recovery: Use the executeQuery() method to issue the select SQL statement.
nl
29054 HY000 Only SQL SELECT statements are valid in executeQuery()
method
Cause: A non-select SQL statement was used in the executeQuery() method.
Effect: The exception reported is "SQL query not performed".
Recovery: Use the executeUpdate() method to issue the non-select SQL statement.
nl
29055 22003 The Date ({0}) is not in format yyyy-mm-dd for
column/parameter number {1,number,integer}
Cause: An attempt was made to enter an invalid date format into a DATE column type.
Effect: An exception is thrown; is not updated.
Recovery: Make sure that a date in the form of yyyy-mm-dd is used.
nl
29056 HY000 Statement is already closed
Cause: A validateSetInvocation() or validateExecuteInvocation method was used
on a closed statement.
Effect: The validation on the statement fails and returns an exception.
Messages From the Java Side of the JDBC/MX Driver 87