SQLSTATEs issued by the IBM Data Server Driver for JDBC and SQLJ
SQLSTATEs in the range 46600 to 466ZZ are reserved for the IBM® Data Server Driver for JDBC and SQLJ.
The following table lists the SQLSTATEs that are generated
or used by the IBM Data Server Driver for JDBC and
SQLJ.
SQLSTATE class | SQLSTATE | Description |
---|---|---|
01xxx | Warning | |
02xxx | No data | |
02xxx | 02501 | The cursor position is not valid for a FETCH of the current row. |
02xxx | 02506 | Tolerable error |
08xxx | Connection exception | |
08xxx | 08001 | The application requester is unable to establish the connection. |
08xxx | 08003 | A connection does not exist |
08xxx | 08004 | The application server rejected establishment of the connection |
08xxx | 08506 | Client reroute exception |
0Axxx | Feature not supported | |
0Axxx | 0A502 | The action or operation is not enabled for this database instance |
0Axxx | 0A504 | The feature is not supported by the driver |
22xxx | Data exception | |
22xxx | 22007 | The string representation of a datetime value is invalid |
22xxx | 22021 | A character is not in the coded character set |
23xxx | Constraint violation | |
23xxx | 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 | |
24xxx | 24501 | The identified cursor is not open |
28xxx | Authorization exception | |
28xxx | 28000 | Authorization name is invalid. |
2Dxxx | Invalid transaction termination | |
2Dxxx | 2D521 | SQL COMMIT or ROLLBACK are invalid in the current operating environment. |
34xxx | Invalid cursor name | |
34xxx | 34000 | Cursor name is invalid. |
3Bxxx | Invalid savepoint | |
3Bxxx | 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 | |
42xxx | 42601 | A character, token, or clause is invalid or missing |
42xxx | 42734 | A duplicate parameter name, SQL variable name, cursor name, condition name, or label was detected. |
42xxx | 42807 | The INSERT, UPDATE, or DELETE is not permitted on this object |
42xxx | 42808 | A column identified in the insert or update operation is not updateable |
42xxx | 42815 | The data type, length, scale, value, or CCSID is invalid |
42xxx | 42820 | A numeric constant is too long, or it has a value that is not within the range of its data type |
42xxx | 42968 | The connection failed because there is no current software license. |
57xxx | Resource not available or operator intervention | |
57xxx | 57033 | A deadlock or timeout occurred without automatic rollback |
58xxx | System error | |
58xxx | 58008 | Execution failed due to a distribution protocol error that will not affect the successful execution of subsequent DDM commands or SQL statements |
58xxx | 58009 | Execution failed due to a distribution protocol error that caused deallocation of the conversation |
58xxx | 58012 | The bind process with the specified package name and consistency token is not active |
58xxx | 58014 | The DDM command is not supported |
58xxx | 58015 | The DDM object is not supported |
58xxx | 58016 | The DDM parameter is not supported |
58xxx | 58017 | The DDM parameter value is not supported |