4.1 SQLSTATE output format
SQLSTATE is one of the return codes HADB returns after executing an SQL statement. An SQLSTATE value consists of five digits, where the first two digits indicate a class and the remaining three digits a subclass.
The following table lists the SQLSTATE classes.
Class |
Meaning |
---|---|
00 |
Normal termination |
01 |
Warning |
02 |
No data satisfies the retrieval condition. |
07 |
Dynamic SQL statement errors |
08 |
HADB server connection errors |
21 |
Cardinality violation |
22 |
Data exception |
23 |
Integrity constraint violation |
24 |
Cursor status errors |
40 |
Errors resulting in transaction rollback |
42 |
Syntax errors or access rule violation |
51 |
SQL function-specific errors (errors caused by specific nonstandard SQL functions) |
52 |
Errors due to an execution environment status that prohibits SQL statement execution |
53 |
Errors due to a system resource status that prohibits SQL statement execution (such as a memory or resource shortage) |
54 |
Error caused by application program settings, processing, attributes, or statuses |
56 |
Limit- or value-related errors |
5B |
User-requested cancellation |
5C |
Other system errors |
5D |
SQLSTATE cannot be obtained. |
R2 |
JDBC driver-related errors |