MySQL Connector/J 5.1 Developer Guide
The table below provides a mapping of the MySQL error numbers to
JDBC SQLState values.
Table 5.4 Mapping of MySQL Error Numbers to SQLStates
| MySQL Error Number | MySQL Error Name | Legacy (X/Open) SQLState | SQL Standard SQLState |
|---|---|---|---|
| 1022 | ER_DUP_KEY | 23000 | 23000 |
| 1037 | ER_OUTOFMEMORY | S1001 | HY001 |
| 1038 | ER_OUT_OF_SORTMEMORY | S1001 | HY001 |
| 1040 | ER_CON_COUNT_ERROR | 08004 | 08004 |
| 1042 | ER_BAD_HOST_ERROR | 08004 | 08S01 |
| 1043 | ER_HANDSHAKE_ERROR | 08004 | 08S01 |
| 1044 | ER_DBACCESS_DENIED_ERROR | 42000 | 42000 |
| 1045 | ER_ACCESS_DENIED_ERROR | 28000 | 28000 |
| 1046 | ER_NO_DB_ERROR | 3D000 | 3D000 |
| 1047 | ER_UNKNOWN_COM_ERROR | 08S01 | 08S01 |
| 1048 | ER_BAD_NULL_ERROR | 23000 | 23000 |
| 1049 | ER_BAD_DB_ERROR | 42000 | 42000 |
| 1050 | ER_TABLE_EXISTS_ERROR | 42S01 | 42S01 |
| 1051 | ER_BAD_TABLE_ERROR | 42S02 | 42S02 |
| 1052 | ER_NON_UNIQ_ERROR | 23000 | 23000 |
| 1053 | ER_SERVER_SHUTDOWN | 08S01 | 08S01 |
| 1054 | ER_BAD_FIELD_ERROR | S0022 | 42S22 |
| 1055 | ER_WRONG_FIELD_WITH_GROUP | S1009 | 42000 |
| 1056 | ER_WRONG_GROUP_FIELD | S1009 | 42000 |
| 1057 | ER_WRONG_SUM_SELECT | S1009 | 42000 |
| 1058 | ER_WRONG_VALUE_COUNT | 21S01 | 21S01 |
| 1059 | ER_TOO_LONG_IDENT | S1009 | 42000 |
| 1060 | ER_DUP_FIELDNAME | S1009 | 42S21 |
| 1061 | ER_DUP_KEYNAME | S1009 | 42000 |
| 1062 | ER_DUP_ENTRY | S1009 | 23000 |
| 1063 | ER_WRONG_FIELD_SPEC | S1009 | 42000 |
| 1064 | ER_PARSE_ERROR | 42000 | 42000 |
| 1065 | ER_EMPTY_QUERY | 42000 | 42000 |
| 1066 | ER_NONUNIQ_TABLE | S1009 | 42000 |
| 1067 | ER_INVALID_DEFAULT | S1009 | 42000 |
| 1068 | ER_MULTIPLE_PRI_KEY | S1009 | 42000 |
| 1069 | ER_TOO_MANY_KEYS | S1009 | 42000 |
| 1070 | ER_TOO_MANY_KEY_PARTS | S1009 | 42000 |
| 1071 | ER_TOO_LONG_KEY | S1009 | 42000 |
| 1072 | ER_KEY_COLUMN_DOES_NOT_EXITS | S1009 | 42000 |
| 1073 | ER_BLOB_USED_AS_KEY | S1009 | 42000 |
| 1074 | ER_TOO_BIG_FIELDLENGTH | S1009 | 42000 |
| 1075 | ER_WRONG_AUTO_KEY | S1009 | 42000 |
| 1080 | ER_FORCING_CLOSE | 08S01 | 08S01 |
| 1081 | ER_IPSOCK_ERROR | 08S01 | 08S01 |
| 1082 | ER_NO_SUCH_INDEX | S1009 | 42S12 |
| 1083 | ER_WRONG_FIELD_TERMINATORS | S1009 | 42000 |
| 1084 | ER_BLOBS_AND_NO_TERMINATED | S1009 | 42000 |
| 1090 | ER_CANT_REMOVE_ALL_FIELDS | 42000 | 42000 |
| 1091 | ER_CANT_DROP_FIELD_OR_KEY | 42000 | 42000 |
| 1101 | ER_BLOB_CANT_HAVE_DEFAULT | 42000 | 42000 |
| 1102 | ER_WRONG_DB_NAME | 42000 | 42000 |
| 1103 | ER_WRONG_TABLE_NAME | 42000 | 42000 |
| 1104 | ER_TOO_BIG_SELECT | 42000 | 42000 |
| 1106 | ER_UNKNOWN_PROCEDURE | 42000 | 42000 |
| 1107 | ER_WRONG_PARAMCOUNT_TO_PROCEDURE | 42000 | 42000 |
| 1109 | ER_UNKNOWN_TABLE | 42S02 | 42S02 |
| 1110 | ER_FIELD_SPECIFIED_TWICE | 42000 | 42000 |
| 1112 | ER_UNSUPPORTED_EXTENSION | 42000 | 42000 |
| 1113 | ER_TABLE_MUST_HAVE_COLUMNS | 42000 | 42000 |
| 1115 | ER_UNKNOWN_CHARACTER_SET | 42000 | 42000 |
| 1118 | ER_TOO_BIG_ROWSIZE | 42000 | 42000 |
| 1120 | ER_WRONG_OUTER_JOIN | 42000 | 42000 |
| 1121 | ER_NULL_COLUMN_IN_INDEX | 42000 | 42000 |
| 1129 | ER_HOST_IS_BLOCKED | 08004 | HY000 |
| 1130 | ER_HOST_NOT_PRIVILEGED | 08004 | HY000 |
| 1131 | ER_PASSWORD_ANONYMOUS_USER | 42000 | 42000 |
| 1132 | ER_PASSWORD_NOT_ALLOWED | 42000 | 42000 |
| 1133 | ER_PASSWORD_NO_MATCH | 42000 | 42000 |
| 1136 | ER_WRONG_VALUE_COUNT_ON_ROW | 21S01 | 21S01 |
| 1138 | ER_INVALID_USE_OF_NULL | S1000 | 42000 |
| 1139 | ER_REGEXP_ERROR | 42000 | 42000 |
| 1140 | ER_MIX_OF_GROUP_FUNC_AND_FIELDS | 42000 | 42000 |
| 1141 | ER_NONEXISTING_GRANT | 42000 | 42000 |
| 1142 | ER_TABLEACCESS_DENIED_ERROR | 42000 | 42000 |
| 1143 | ER_COLUMNACCESS_DENIED_ERROR | 42000 | 42000 |
| 1144 | ER_ILLEGAL_GRANT_FOR_TABLE | 42000 | 42000 |
| 1145 | ER_GRANT_WRONG_HOST_OR_USER | 42000 | 42000 |
| 1146 | ER_NO_SUCH_TABLE | 42S02 | 42S02 |
| 1147 | ER_NONEXISTING_TABLE_GRANT | 42000 | 42000 |
| 1148 | ER_NOT_ALLOWED_COMMAND | 42000 | 42000 |
| 1149 | ER_SYNTAX_ERROR | 42000 | 42000 |
| 1152 | ER_ABORTING_CONNECTION | 08S01 | 08S01 |
| 1153 | ER_NET_PACKET_TOO_LARGE | 08S01 | 08S01 |
| 1154 | ER_NET_READ_ERROR_FROM_PIPE | 08S01 | 08S01 |
| 1155 | ER_NET_FCNTL_ERROR | 08S01 | 08S01 |
| 1156 | ER_NET_PACKETS_OUT_OF_ORDER | 08S01 | 08S01 |
| 1157 | ER_NET_UNCOMPRESS_ERROR | 08S01 | 08S01 |
| 1158 | ER_NET_READ_ERROR | 08S01 | 08S01 |
| 1159 | ER_NET_READ_INTERRUPTED | 08S01 | 08S01 |
| 1160 | ER_NET_ERROR_ON_WRITE | 08S01 | 08S01 |
| 1161 | ER_NET_WRITE_INTERRUPTED | 08S01 | 08S01 |
| 1162 | ER_TOO_LONG_STRING | 42000 | 42000 |
| 1163 | ER_TABLE_CANT_HANDLE_BLOB | 42000 | 42000 |
| 1164 | ER_TABLE_CANT_HANDLE_AUTO_INCREMENT | 42000 | 42000 |
| 1166 | ER_WRONG_COLUMN_NAME | 42000 | 42000 |
| 1167 | ER_WRONG_KEY_COLUMN | 42000 | 42000 |
| 1169 | ER_DUP_UNIQUE | 23000 | 23000 |
| 1170 | ER_BLOB_KEY_WITHOUT_LENGTH | 42000 | 42000 |
| 1171 | ER_PRIMARY_CANT_HAVE_NULL | 42000 | 42000 |
| 1172 | ER_TOO_MANY_ROWS | 42000 | 42000 |
| 1173 | ER_REQUIRES_PRIMARY_KEY | 42000 | 42000 |
| 1176 | ER_KEY_DOES_NOT_EXITS | 42000 | 42000 |
| 1177 | ER_CHECK_NO_SUCH_TABLE | 42000 | 42000 |
| 1178 | ER_CHECK_NOT_IMPLEMENTED | 42000 | 42000 |
| 1179 | ER_CANT_DO_THIS_DURING_AN_TRANSACTION | 25000 | 25000 |
| 1184 | ER_NEW_ABORTING_CONNECTION | 08S01 | 08S01 |
| 1189 | ER_MASTER_NET_READ | 08S01 | 08S01 |
| 1190 | ER_MASTER_NET_WRITE | 08S01 | 08S01 |
| 1203 | ER_TOO_MANY_USER_CONNECTIONS | 42000 | 42000 |
| 1205 | ER_LOCK_WAIT_TIMEOUT | 40001 | 40001 |
| 1207 | ER_READ_ONLY_TRANSACTION | 25000 | 25000 |
| 1211 | ER_NO_PERMISSION_TO_CREATE_USER | 42000 | 42000 |
| 1213 | ER_LOCK_DEADLOCK | 40001 | 40001 |
| 1216 | ER_NO_REFERENCED_ROW | 23000 | 23000 |
| 1217 | ER_ROW_IS_REFERENCED | 23000 | 23000 |
| 1218 | ER_CONNECT_TO_MASTER | 08S01 | 08S01 |
| 1222 | ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT | 21000 | 21000 |
| 1226 | ER_USER_LIMIT_REACHED | 42000 | 42000 |
| 1227 | ER_SPECIFIC_ACCESS_DENIED_ERROR | 42000 | 42000 |
| 1230 | ER_NO_DEFAULT | 42000 | 42000 |
| 1231 | ER_WRONG_VALUE_FOR_VAR | 42000 | 42000 |
| 1232 | ER_WRONG_TYPE_FOR_VAR | 42000 | 42000 |
| 1234 | ER_CANT_USE_OPTION_HERE | 42000 | 42000 |
| 1235 | ER_NOT_SUPPORTED_YET | 42000 | 42000 |
| 1239 | ER_WRONG_FK_DEF | 42000 | 42000 |
| 1241 | ER_OPERAND_COLUMNS | 21000 | 21000 |
| 1242 | ER_SUBQUERY_NO_1_ROW | 21000 | 21000 |
| 1247 | ER_ILLEGAL_REFERENCE | 42S22 | 42S22 |
| 1248 | ER_DERIVED_MUST_HAVE_ALIAS | 42000 | 42000 |
| 1249 | ER_SELECT_REDUCED | 01000 | 01000 |
| 1250 | ER_TABLENAME_NOT_ALLOWED_HERE | 42000 | 42000 |
| 1251 | ER_NOT_SUPPORTED_AUTH_MODE | 08004 | 08004 |
| 1252 | ER_SPATIAL_CANT_HAVE_NULL | 42000 | 42000 |
| 1253 | ER_COLLATION_CHARSET_MISMATCH | 42000 | 42000 |
| 1261 | ER_WARN_TOO_FEW_RECORDS | 01000 | 01000 |
| 1262 | ER_WARN_TOO_MANY_RECORDS | 01000 | 01000 |
| 1263 | ER_WARN_NULL_TO_NOTNULL | S1000 | 01000 |
| 1264 | ER_WARN_DATA_OUT_OF_RANGE | 01000 | 01000 |
| 1265 | ER_WARN_DATA_TRUNCATED | 01000 | 01000 |
| 1280 | ER_WRONG_NAME_FOR_INDEX | 42000 | 42000 |
| 1281 | ER_WRONG_NAME_FOR_CATALOG | 42000 | 42000 |
| 1286 | ER_UNKNOWN_STORAGE_ENGINE | 42000 | 42000 |
| 1292 | ER_TRUNCATED_WRONG_VALUE | 22007 | 22007 |
| 1303 | ER_SP_NO_RECURSIVE_CREATE | S1000 | 2F003 |
| 1304 | ER_SP_ALREADY_EXISTS | 42000 | 42000 |
| 1305 | ER_SP_DOES_NOT_EXIST | 42000 | 42000 |
| 1308 | ER_SP_LILABEL_MISMATCH | 42000 | 42000 |
| 1309 | ER_SP_LABEL_REDEFINE | 42000 | 42000 |
| 1310 | ER_SP_LABEL_MISMATCH | 42000 | 42000 |
| 1311 | ER_SP_UNINIT_VAR | 01000 | 01000 |
| 1312 | ER_SP_BADSELECT | 0A000 | 0A000 |
| 1313 | ER_SP_BADRETURN | 42000 | 42000 |
| 1314 | ER_SP_BADSTATEMENT | 0A000 | 0A000 |
| 1315 | ER_UPDATE_LOG_DEPRECATED_IGNORED | 42000 | 42000 |
| 1316 | ER_UPDATE_LOG_DEPRECATED_TRANSLATED | 42000 | 42000 |
| 1317 | ER_QUERY_INTERRUPTED | S1000 | 70100 |
| 1318 | ER_SP_WRONG_NO_OF_ARGS | 42000 | 42000 |
| 1319 | ER_SP_COND_MISMATCH | 42000 | 42000 |
| 1320 | ER_SP_NORETURN | 42000 | 42000 |
| 1321 | ER_SP_NORETURNEND | S1000 | 2F005 |
| 1322 | ER_SP_BAD_CURSOR_QUERY | 42000 | 42000 |
| 1323 | ER_SP_BAD_CURSOR_SELECT | 42000 | 42000 |
| 1324 | ER_SP_CURSOR_MISMATCH | 42000 | 42000 |
| 1325 | ER_SP_CURSOR_ALREADY_OPEN | 24000 | 24000 |
| 1326 | ER_SP_CURSOR_NOT_OPEN | 24000 | 24000 |
| 1327 | ER_SP_UNDECLARED_VAR | 42000 | 42000 |
| 1329 | ER_SP_FETCH_NO_DATA | S1000 | 02000 |
| 1330 | ER_SP_DUP_PARAM | 42000 | 42000 |
| 1331 | ER_SP_DUP_VAR | 42000 | 42000 |
| 1332 | ER_SP_DUP_COND | 42000 | 42000 |
| 1333 | ER_SP_DUP_CURS | 42000 | 42000 |
| 1335 | ER_SP_SUBSELECT_NYI | 0A000 | 0A000 |
| 1336 | ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG | 0A000 | 0A000 |
| 1337 | ER_SP_VARCOND_AFTER_CURSHNDLR | 42000 | 42000 |
| 1338 | ER_SP_CURSOR_AFTER_HANDLER | 42000 | 42000 |
| 1339 | ER_SP_CASE_NOT_FOUND | S1000 | 20000 |
| 1365 | ER_DIVISION_BY_ZERO | 22012 | 22012 |
| 1367 | ER_ILLEGAL_VALUE_FOR_TYPE | 22007 | 22007 |
| 1370 | ER_PROCACCESS_DENIED_ERROR | 42000 | 42000 |
| 1397 | ER_XAER_NOTA | S1000 | XAE04 |
| 1398 | ER_XAER_INVAL | S1000 | XAE05 |
| 1399 | ER_XAER_RMFAIL | S1000 | XAE07 |
| 1400 | ER_XAER_OUTSIDE | S1000 | XAE09 |
| 1401 | ER_XA_RMERR | S1000 | XAE03 |
| 1402 | ER_XA_RBROLLBACK | S1000 | XA100 |
| 1403 | ER_NONEXISTING_PROC_GRANT | 42000 | 42000 |
| 1406 | ER_DATA_TOO_LONG | 22001 | 22001 |
| 1407 | ER_SP_BAD_SQLSTATE | 42000 | 42000 |
| 1410 | ER_CANT_CREATE_USER_WITH_GRANT | 42000 | 42000 |
| 1413 | ER_SP_DUP_HANDLER | 42000 | 42000 |
| 1414 | ER_SP_NOT_VAR_ARG | 42000 | 42000 |
| 1415 | ER_SP_NO_RETSET | 0A000 | 0A000 |
| 1416 | ER_CANT_CREATE_GEOMETRY_OBJECT | 22003 | 22003 |
| 1425 | ER_TOO_BIG_SCALE | 42000 | 42000 |
| 1426 | ER_TOO_BIG_PRECISION | 42000 | 42000 |
| 1427 | ER_M_BIGGER_THAN_D | 42000 | 42000 |
| 1437 | ER_TOO_LONG_BODY | 42000 | 42000 |
| 1439 | ER_TOO_BIG_DISPLAYWIDTH | 42000 | 42000 |
| 1440 | ER_XAER_DUPID | S1000 | XAE08 |
| 1441 | ER_DATETIME_FUNCTION_OVERFLOW | 22008 | 22008 |
| 1451 | ER_ROW_IS_REFERENCED_2 | 23000 | 23000 |
| 1452 | ER_NO_REFERENCED_ROW_2 | 23000 | 23000 |
| 1453 | ER_SP_BAD_VAR_SHADOW | 42000 | 42000 |
| 1458 | ER_SP_WRONG_NAME | 42000 | 42000 |
| 1460 | ER_SP_NO_AGGREGATE | 42000 | 42000 |
| 1461 | ER_MAX_PREPARED_STMT_COUNT_REACHED | 42000 | 42000 |
| 1463 | ER_NON_GROUPING_FIELD_USED | 42000 | 42000 |
| 1557 | ER_FOREIGN_DUPLICATE_KEY | 23000 | 23000 |
| 1568 | ER_CANT_CHANGE_TX_ISOLATION | S1000 | 25001 |
| 1582 | ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT | 42000 | 42000 |
| 1583 | ER_WRONG_PARAMETERS_TO_NATIVE_FCT | 42000 | 42000 |
| 1584 | ER_WRONG_PARAMETERS_TO_STORED_FCT | 42000 | 42000 |
| 1586 | ER_DUP_ENTRY_WITH_KEY_NAME | 23000 | 23000 |
| 1613 | ER_XA_RBTIMEOUT | S1000 | XA106 |
| 1614 | ER_XA_RBDEADLOCK | S1000 | XA102 |
| 1630 | ER_FUNC_INEXISTENT_NAME_COLLISION | 42000 | 42000 |
| 1641 | ER_DUP_SIGNAL_SET | 42000 | 42000 |
| 1642 | ER_SIGNAL_WARN | 01000 | 01000 |
| 1643 | ER_SIGNAL_NOT_FOUND | S1000 | 02000 |
| 1645 | ER_RESIGNAL_WITHOUT_ACTIVE_HANDLER | S1000 | 0K000 |
| 1687 | ER_SPATIAL_MUST_HAVE_GEOM_COL | 42000 | 42000 |
| 1690 | ER_DATA_OUT_OF_RANGE | 22003 | 22003 |
| 1698 | ER_ACCESS_DENIED_NO_PASSWORD_ERROR | 28000 | 28000 |
| 1701 | ER_TRUNCATE_ILLEGAL_FK | 42000 | 42000 |
| 1758 | ER_DA_INVALID_CONDITION_NUMBER | 35000 | 35000 |
| 1761 | ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO | 23000 | 23000 |
| 1762 | ER_FOREIGN_DUPLICATE_KEY_WITHOUT_CHILD_INFO | 23000 | 23000 |
| 1792 | ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION | S1000 | 25006 |
| 1845 | ER_ALTER_OPERATION_NOT_SUPPORTED | 0A000 | 0A000 |
| 1846 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON | 0A000 | 0A000 |
| 1859 | ER_DUP_UNKNOWN_IN_INDEX | 23000 | 23000 |
| 1873 | ER_ACCESS_DENIED_CHANGE_USER_ERROR | 28000 | 28000 |
| 1887 | ER_GET_STACKED_DA_WITHOUT_ACTIVE_HANDLER | S1000 | 0Z002 |
| 1903 | ER_INVALID_ARGUMENT_FOR_LOGARITHM | S1000 | 2201E |