Documentation Home
MySQL Connector/J 5.1 Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 478.6Kb
PDF (A4) - 478.7Kb
EPUB - 146.1Kb
HTML Download (TGZ) - 119.5Kb
HTML Download (Zip) - 146.0Kb


MySQL Connector/J 5.1 Developer Guide  /  Connector/J (JDBC) Reference  /  Mapping MySQL Error Numbers to JDBC SQLState Codes

5.8 Mapping MySQL Error Numbers to JDBC SQLState Codes

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


User Comments
Sign Up Login You must be logged in to post a comment.