SqlState | Vendor Code | Description |
01000 | | General error. |
01001 | 532,10095 | Cursor update or delete failure due to optimistic concurrency check failure. |
01003 | 8153 | Elimination of null values by set operator (warning). |
08S01 | | Communication link failure |
21000 | 512 | Singleton select returns more than one row, or sub query preceded by = returns more than one value. |
21S01 | 109,110 | INSERT statement processed, incorrect number of values supplied |
22001 | 8152 | String data truncated (on right) on insert or update. |
22003 | 168,220,232,234, 236-238,244, 246,248,519-524, 535,8115, 10015 | Arithmetic overflow error. |
22005 | 206,235,245,247,249, 256,257,305,409,518, 529 | Data type conversion error. |
22008 | 210,211,241,242,295, 296,517 | Data type conversion error. |
22012 | 8134 | Divide by zero error. |
22019 | 1010, 506 | Invalid escape character. |
22025 | 310 | Invalid escape sequence, for example, escape char not followed by %, _, or escape char. |
23000 | 233,272,273,515,530, 547,1505,1508,2601, 2615,2626,2627,3604, 3605 | Constraint violation. |
24000 | 16929 | ResultSet is read only. |
25000 | 266,277,611,628,3902, 3903,3906,3908,6401 | Transaction state error. |
28000 | 18456 | Invalid authorization identifier |
37000 | 102,105,156,170,2715,2812,4145 | Syntax error |
40000 | 1205,1211,2625, 3309,7112 | Transaction rollback due to deadlock. |
42000 | 213,229, 230,260,8118,8119,8121 | Syntax error, permission violation, or other nonspecific error. |
44000 | 550 | View with check option violation. |
IM001 | | Driver does not support this function |
S0002 | 208 | Table or view not found |
S0022 | 207 | Column name does not exist |
S1T00 | | Timeout |