Table 91. SQLSTATEs returned by the IBM Data Server Driver for JDBC and SQLJ
SQLSTATE
class SQLSTATE Description
01xxx Warning
02xxx No data
02501 The cursor position is not valid for a FETCH of the current
row.
02506 Tolerable error
08xxx Connection exception
08003 A connection does not exist
08004 The application server rejected establishment of the
connection
08506 Client reroute exception
0Axxx Feature not supported
0A502 The action or operation is not enabled for this database
instance
0A504 The feature is not supported by the driver
22xxx Data exception
22007 The string representation of a datetime value is invalid
22021 A character is not in the coded character set
23xxx Constraint violation
23502 A value that is inserted into a column or updates a column is
null, but the column cannot contain null values.
24xxx Invalid cursor state
24501 The identified cursor is not open
28xxx Authorization exception
28000 Authorization name is invalid.
2Dxxx Invalid transaction termination
2D521 SQL COMMIT or ROLLBACK are invalid in the current
operating environment.
34xxx Invalid cursor name
34000 Cursor name is invalid.
3Bxxx Invalid savepoint
3B503 A SAVEPOINT, RELEASE SAVEPOINT, or ROLLBACK TO
SAVEPOINT statement is not allowed in a trigger or global
transaction.
40xxx Transaction rollback
42xxx Syntax error or access rule violation
42601 A character, token, or clause is invalid or missing
42734 A duplicate parameter name, SQL variable name, cursor
name, condition name, or label was detected.
42807 The INSERT, UPDATE, or DELETE is not permitted on this
object
42808 A column identified in the insert or update operation is not
updateable
Chapter 7. JDBC and SQLJ reference information 389
To Next Page
Loading...
Need help?
General