MySQL Error code and message : MySQL « Database SQL JDBC « Java
MySQL Error code and message
/*
Copyright (C) 2002 MySQL AB
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
import java.util.Hashtable;
/**
* SQLError is a utility class that maps MySQL error codes to X/Open
* error codes as is required by the JDBC spec.
*
* @author Mark Matthews <mmatthew_at_worldserver.com>
* @version $Id: SQLError.java,v 1.2 2002/04/21 03:03:46 mark_matthews Exp $
*/
class SQLError {
//~ Instance/static variables .............................................
private static Hashtable mysqlToSqlState;
private static Hashtable sqlStateMessages;
//~ Initializers ..........................................................
static {
sqlStateMessages = new Hashtable();
sqlStateMessages.put("01002", "Disconnect error");
sqlStateMessages.put("01004", "Data truncated");
sqlStateMessages.put("01006", "Privilege not revoked");
sqlStateMessages.put("01S00", "Invalid connection string attribute");
sqlStateMessages.put("01S01", "Error in row");
sqlStateMessages.put("01S03", "No rows updated or deleted");
sqlStateMessages.put("01S04", "More than one row updated or deleted");
sqlStateMessages.put("07001", "Wrong number of parameters");
sqlStateMessages.put("08001", "Unable to connect to data source");
sqlStateMessages.put("08002", "Connection in use");
sqlStateMessages.put("08003", "Connection not open");
sqlStateMessages.put("08004", "Data source rejected establishment of connection");
sqlStateMessages.put("08007", "Connection failure during transaction");
sqlStateMessages.put("08S01", "Communication link failure");
sqlStateMessages.put("21S01", "Insert value list does not match column list");
sqlStateMessages.put("22003", "Numeric value out of range");
sqlStateMessages.put("22005", "Numeric value out of range");
sqlStateMessages.put("22008", "Datetime field overflow");
sqlStateMessages.put("22012", "Division by zero");
sqlStateMessages.put("28000", "Invalid authorization specification");
sqlStateMessages.put("42000", "Syntax error or access violation");
sqlStateMessages.put("S0001", "Base table or view already exists");
sqlStateMessages.put("S0002", "Base table not found");
sqlStateMessages.put("S0011", "Index already exists");
sqlStateMessages.put("S0012", "Index not found");
sqlStateMessages.put("S0021", "Column already exists");
sqlStateMessages.put("S0022", "Column not found");
sqlStateMessages.put("S0023", "No default for column");
sqlStateMessages.put("S1000", "General error");
sqlStateMessages.put("S1001", "Memory allocation failure");
sqlStateMessages.put("S1002", "Invalid column number");
sqlStateMessages.put("S1009", "Invalid argument value");
sqlStateMessages.put("S1C00", "Driver not capable");
sqlStateMessages.put("S1T00", "Timeout expired");
//
// Map MySQL error codes to X/Open error codes
//
mysqlToSqlState = new Hashtable();
//
// Communications Errors
//
// ER_BAD_HOST_ERROR 1042
// ER_HANDSHAKE_ERROR 1043
// ER_UNKNOWN_COM_ERROR 1047
// ER_IPSOCK_ERROR 1081
//
mysqlToSqlState.put(new Integer(1042), "08S01");
mysqlToSqlState.put(new Integer(1043), "08S01");
mysqlToSqlState.put(new Integer(1047), "08S01");
mysqlToSqlState.put(new Integer(1081), "08S01");
//
// Authentication Errors
//
// ER_ACCESS_DENIED_ERROR 1045
//
mysqlToSqlState.put(new Integer(1045), "28000");
//
// Resource errors
//
// ER_CANT_CREATE_FILE 1004
// ER_CANT_CREATE_TABLE 1005
// ER_CANT_LOCK 1015
// ER_DISK_FULL 1021
// ER_CON_COUNT_ERROR 1040
// ER_OUT_OF_RESOURCES 1041
//
// Out-of-memory errors
//
// ER_OUTOFMEMORY 1037
// ER_OUT_OF_SORTMEMORY 1038
//
mysqlToSqlState.put(new Integer(1037), "S1001");
mysqlToSqlState.put(new Integer(1038), "S1001");
//
// Syntax Errors
//
// ER_PARSE_ERROR 1064
// ER_EMPTY_QUERY 1065
//
mysqlToSqlState.put(new Integer(1064), "42000");
mysqlToSqlState.put(new Integer(1065), "42000");
//
// Invalid argument errors
//
// ER_WRONG_FIELD_WITH_GROUP 1055
// ER_WRONG_GROUP_FIELD 1056
// ER_WRONG_SUM_SELECT 1057
// ER_TOO_LONG_IDENT 1059
// ER_DUP_FIELDNAME 1060
// ER_DUP_KEYNAME 1061
// ER_DUP_ENTRY 1062
// ER_WRONG_FIELD_SPEC 1063
// ER_NONUNIQ_TABLE 1066
// ER_INVALID_DEFAULT 1067
// ER_MULTIPLE_PRI_KEY 1068
// ER_TOO_MANY_KEYS 1069
// ER_TOO_MANY_KEY_PARTS 1070
// ER_TOO_LONG_KEY 1071
// ER_KEY_COLUMN_DOES_NOT_EXIST 1072
// ER_BLOB_USED_AS_KEY 1073
// ER_TOO_BIG_FIELDLENGTH 1074
// ER_WRONG_AUTO_KEY 1075
// ER_NO_SUCH_INDEX 1082
// ER_WRONG_FIELD_TERMINATORS 1083
// ER_BLOBS_AND_NO_TERMINATED 1084
//
mysqlToSqlState.put(new Integer(1055), "S1009");
mysqlToSqlState.put(new Integer(1056), "S1009");
mysqlToSqlState.put(new Integer(1057), "S1009");
mysqlToSqlState.put(new Integer(1059), "S1009");
mysqlToSqlState.put(new Integer(1060), "S1009");
mysqlToSqlState.put(new Integer(1061), "S1009");
mysqlToSqlState.put(new Integer(1062), "S1009");
mysqlToSqlState.put(new Integer(1063), "S1009");
mysqlToSqlState.put(new Integer(1066), "S1009");
mysqlToSqlState.put(new Integer(1067), "S1009");
mysqlToSqlState.put(new Integer(1068), "S1009");
mysqlToSqlState.put(new Integer(1069), "S1009");
mysqlToSqlState.put(new Integer(1070), "S1009");
mysqlToSqlState.put(new Integer(1071), "S1009");
mysqlToSqlState.put(new Integer(1072), "S1009");
mysqlToSqlState.put(new Integer(1073), "S1009");
mysqlToSqlState.put(new Integer(1074), "S1009");
mysqlToSqlState.put(new Integer(1075), "S1009");
mysqlToSqlState.put(new Integer(1082), "S1009");
mysqlToSqlState.put(new Integer(1083), "S1009");
mysqlToSqlState.put(new Integer(1084), "S1009");
//
// ER_WRONG_VALUE_COUNT 1058
//
mysqlToSqlState.put(new Integer(1058), "21S01");
// ER_CANT_CREATE_DB 1006
// ER_DB_CREATE_EXISTS 1007
// ER_DB_DROP_EXISTS 1008
// ER_DB_DROP_DELETE 1009
// ER_DB_DROP_RMDIR 1010
// ER_CANT_DELETE_FILE 1011
// ER_CANT_FIND_SYSTEM_REC 1012
// ER_CANT_GET_STAT 1013
// ER_CANT_GET_WD 1014
// ER_UNEXPECTED_EOF 1039
// ER_CANT_OPEN_FILE 1016
// ER_FILE_NOT_FOUND 1017
// ER_CANT_READ_DIR 1018
// ER_CANT_SET_WD 1019
// ER_CHECKREAD 1020
// ER_DUP_KEY 1022
// ER_ERROR_ON_CLOSE 1023
// ER_ERROR_ON_READ 1024
// ER_ERROR_ON_RENAME 1025
// ER_ERROR_ON_WRITE 1026
// ER_FILE_USED 1027
// ER_FILSORT_ABORT 1028
// ER_FORM_NOT_FOUND 1029
// ER_GET_ERRNO 1030
// ER_ILLEGAL_HA 1031
// ER_KEY_NOT_FOUND 1032
// ER_NOT_FORM_FILE 1033
// ER_DBACCESS_DENIED_ERROR 1044
// ER_NO_DB_ERROR 1046
// ER_BAD_NULL_ERROR 1048
// ER_BAD_DB_ERROR 1049
// ER_TABLE_EXISTS_ERROR 1050
// ER_BAD_TABLE_ERROR 1051
// ER_NON_UNIQ_ERROR 1052
// ER_BAD_FIELD_ERROR 1054
mysqlToSqlState.put(new Integer(1054), "S0022");
// ER_TEXTFILE_NOT_READABLE 1085
// ER_FILE_EXISTS_ERROR 1086
// ER_LOAD_INFO 1087
// ER_ALTER_INFO 1088
// ER_WRONG_SUB_KEY 1089
// ER_CANT_REMOVE_ALL_FIELDS 1090
// ER_CANT_DROP_FIELD_OR_KEY 1091
// ER_INSERT_INFO 1092
// ER_INSERT_TABLE_USED 1093
}
//~ Methods ...............................................................
static String get(String stateCode) {
return (String) sqlStateMessages.get(stateCode);
}
/**
* Map MySQL error codes to X/Open error codes
*
* @param errno the MySQL error code
* @return the corresponding X/Open error code
*/
static String mysqlToXOpen(int errno) {
Integer err = new Integer(errno);
if (mysqlToSqlState.containsKey(err)) {
return (String) mysqlToSqlState.get(err);
} else {
return "S1000";
}
}
}
