JDBC Driver for SQL/MX Programmer's Reference

Recovery: This message is reported as an SQL Warning. It is an informational message only;
no recovery is needed.
[back to the top]
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.
[back to the top]
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.
[back to the top]
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.
[back to the top]
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.