一、前言
通过mysql-connector-java版本包(5.1.16)中的com.mysql.jdbc.SQLError及其LocalizedErrorMessages.properties配置文件,可以查看jdbc操作使用mysql数据库常见所有异常描述代码及相关描述说明。
二、源码说明
1.SQLError源码部分
package com.mysql.jdbc;@b@@b@...@b@@b@public class SQLError@b@{@b@ static final int ER_WARNING_NOT_COMPLETE_ROLLBACK = 1196;@b@ private static Map mysqlToSql99State;@b@ private static Map mysqlToSqlState;@b@ public static final String SQL_STATE_BASE_TABLE_NOT_FOUND = "S0002";@b@ public static final String SQL_STATE_BASE_TABLE_OR_VIEW_ALREADY_EXISTS = "S0001";@b@ public static final String SQL_STATE_BASE_TABLE_OR_VIEW_NOT_FOUND = "42S02";@b@ public static final String SQL_STATE_COLUMN_ALREADY_EXISTS = "S0021";@b@ public static final String SQL_STATE_COLUMN_NOT_FOUND = "S0022";@b@ public static final String SQL_STATE_COMMUNICATION_LINK_FAILURE = "08S01";@b@ public static final String SQL_STATE_CONNECTION_FAIL_DURING_TX = "08007";@b@ public static final String SQL_STATE_CONNECTION_IN_USE = "08002";@b@ public static final String SQL_STATE_CONNECTION_NOT_OPEN = "08003";@b@ public static final String SQL_STATE_CONNECTION_REJECTED = "08004";@b@ public static final String SQL_STATE_DATE_TRUNCATED = "01004";@b@ public static final String SQL_STATE_DATETIME_FIELD_OVERFLOW = "22008";@b@ public static final String SQL_STATE_DEADLOCK = "41000";@b@ public static final String SQL_STATE_DISCONNECT_ERROR = "01002";@b@ public static final String SQL_STATE_DIVISION_BY_ZERO = "22012";@b@ public static final String SQL_STATE_DRIVER_NOT_CAPABLE = "S1C00";@b@ public static final String SQL_STATE_ERROR_IN_ROW = "01S01";@b@ public static final String SQL_STATE_GENERAL_ERROR = "S1000";@b@ public static final String SQL_STATE_ILLEGAL_ARGUMENT = "S1009";@b@ public static final String SQL_STATE_INDEX_ALREADY_EXISTS = "S0011";@b@ public static final String SQL_STATE_INDEX_NOT_FOUND = "S0012";@b@ public static final String SQL_STATE_INSERT_VALUE_LIST_NO_MATCH_COL_LIST = "21S01";@b@ public static final String SQL_STATE_INVALID_AUTH_SPEC = "28000";@b@ public static final String SQL_STATE_INVALID_CHARACTER_VALUE_FOR_CAST = "22018";@b@ public static final String SQL_STATE_INVALID_COLUMN_NUMBER = "S1002";@b@ public static final String SQL_STATE_INVALID_CONNECTION_ATTRIBUTE = "01S00";@b@ public static final String SQL_STATE_MEMORY_ALLOCATION_FAILURE = "S1001";@b@ public static final String SQL_STATE_MORE_THAN_ONE_ROW_UPDATED_OR_DELETED = "01S04";@b@ public static final String SQL_STATE_NO_DEFAULT_FOR_COLUMN = "S0023";@b@ public static final String SQL_STATE_NO_ROWS_UPDATED_OR_DELETED = "01S03";@b@ public static final String SQL_STATE_NUMERIC_VALUE_OUT_OF_RANGE = "22003";@b@ public static final String SQL_STATE_PRIVILEGE_NOT_REVOKED = "01006";@b@ public static final String SQL_STATE_SYNTAX_ERROR = "42000";@b@ public static final String SQL_STATE_TIMEOUT_EXPIRED = "S1T00";@b@ public static final String SQL_STATE_TRANSACTION_RESOLUTION_UNKNOWN = "08007";@b@ public static final String SQL_STATE_UNABLE_TO_CONNECT_TO_DATASOURCE = "08001";@b@ public static final String SQL_STATE_WRONG_NO_OF_PARAMETERS = "07001";@b@ public static final String SQL_STATE_INVALID_TRANSACTION_TERMINATION = "2D000";@b@ private static Map sqlStateMessages;@b@ private static final long DEFAULT_WAIT_TIMEOUT_SECONDS = 28800L;@b@ private static final int DUE_TO_TIMEOUT_FALSE = 0;@b@ private static final int DUE_TO_TIMEOUT_MAYBE = 2;@b@ private static final int DUE_TO_TIMEOUT_TRUE = 1;@b@ private static final Constructor JDBC_4_COMMUNICATIONS_EXCEPTION_CTOR;@b@ private static Method THROWABLE_INIT_CAUSE_METHOD;@b@@b@ ...@b@@b@ @b@ if (streamingResultSetInPlay) {@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.ClientWasStreaming"));@b@ }@b@ else {@b@ if (serverTimeoutSeconds != 0L) {@b@ if (timeSinceLastPacket > serverTimeoutSeconds) {@b@ dueToTimeout = 1;@b@@b@ timeoutMessageBuf = new StringBuffer();@b@@b@ timeoutMessageBuf.append(Messages.getString("CommunicationsException.2"));@b@@b@ if (!(isInteractiveClient)) {@b@ timeoutMessageBuf.append(Messages.getString("CommunicationsException.3"));@b@ }@b@ else@b@ timeoutMessageBuf.append(Messages.getString("CommunicationsException.4"));@b@@b@ }@b@@b@ }@b@ else if (timeSinceLastPacket > 28800L) {@b@ dueToTimeout = 2;@b@@b@ timeoutMessageBuf = new StringBuffer();@b@@b@ timeoutMessageBuf.append(Messages.getString("CommunicationsException.5"));@b@@b@ timeoutMessageBuf.append(Messages.getString("CommunicationsException.6"));@b@@b@ timeoutMessageBuf.append(Messages.getString("CommunicationsException.7"));@b@@b@ timeoutMessageBuf.append(Messages.getString("CommunicationsException.8"));@b@ }@b@@b@ if ((dueToTimeout == 1) || (dueToTimeout == 2))@b@ {@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.9_1"));@b@@b@ exceptionMessageBuf.append(timeSinceLastPacketReceived);@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.9_2"));@b@@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.9"));@b@@b@ exceptionMessageBuf.append(timeSinceLastPacket);@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.10"));@b@@b@ if (timeoutMessageBuf != null) {@b@ exceptionMessageBuf.append(timeoutMessageBuf);@b@ }@b@@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.11"));@b@@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.12"));@b@@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.13"));@b@ }@b@ else if (underlyingException instanceof BindException) {@b@ if ((conn.getLocalSocketAddress() != null) && (!(Util.interfaceExists(conn.getLocalSocketAddress()))))@b@ {@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.19a"));@b@ }@b@ else@b@ {@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.14"));@b@@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.15"));@b@@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.16"));@b@@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.17"));@b@@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.18"));@b@@b@ exceptionMessageBuf.append(Messages.getString("CommunicationsException.19"));@b@ }@b@@b@ }@b@@b@ } @b@ @b@...@b@@b@ static@b@ {@b@ ...@b@@b@ sqlStateMessages = new HashMap();@b@ sqlStateMessages.put("01002", Messages.getString("SQLError.35"));@b@@b@ sqlStateMessages.put("01004", Messages.getString("SQLError.36"));@b@@b@ sqlStateMessages.put("01006", Messages.getString("SQLError.37"));@b@@b@ sqlStateMessages.put("01S00", Messages.getString("SQLError.38"));@b@@b@ sqlStateMessages.put("01S01", Messages.getString("SQLError.39"));@b@@b@ sqlStateMessages.put("01S03", Messages.getString("SQLError.40"));@b@@b@ sqlStateMessages.put("01S04", Messages.getString("SQLError.41"));@b@@b@ sqlStateMessages.put("07001", Messages.getString("SQLError.42"));@b@@b@ sqlStateMessages.put("08001", Messages.getString("SQLError.43"));@b@@b@ sqlStateMessages.put("08002", Messages.getString("SQLError.44"));@b@@b@ sqlStateMessages.put("08003", Messages.getString("SQLError.45"));@b@@b@ sqlStateMessages.put("08004", Messages.getString("SQLError.46"));@b@@b@ sqlStateMessages.put("08007", Messages.getString("SQLError.47"));@b@@b@ sqlStateMessages.put("08S01", Messages.getString("SQLError.48"));@b@@b@ sqlStateMessages.put("21S01", Messages.getString("SQLError.49"));@b@@b@ sqlStateMessages.put("22003", Messages.getString("SQLError.50"));@b@@b@ sqlStateMessages.put("22008", Messages.getString("SQLError.51"));@b@@b@ sqlStateMessages.put("22012", Messages.getString("SQLError.52"));@b@@b@ sqlStateMessages.put("41000", Messages.getString("SQLError.53"));@b@@b@ sqlStateMessages.put("28000", Messages.getString("SQLError.54"));@b@@b@ sqlStateMessages.put("42000", Messages.getString("SQLError.55"));@b@@b@ sqlStateMessages.put("42S02", Messages.getString("SQLError.56"));@b@@b@ sqlStateMessages.put("S0001", Messages.getString("SQLError.57"));@b@@b@ sqlStateMessages.put("S0002", Messages.getString("SQLError.58"));@b@@b@ sqlStateMessages.put("S0011", Messages.getString("SQLError.59"));@b@@b@ sqlStateMessages.put("S0012", Messages.getString("SQLError.60"));@b@@b@ sqlStateMessages.put("S0021", Messages.getString("SQLError.61"));@b@@b@ sqlStateMessages.put("S0022", Messages.getString("SQLError.62"));@b@@b@ sqlStateMessages.put("S0023", Messages.getString("SQLError.63"));@b@@b@ sqlStateMessages.put("S1000", Messages.getString("SQLError.64"));@b@@b@ sqlStateMessages.put("S1001", Messages.getString("SQLError.65"));@b@@b@ sqlStateMessages.put("S1002", Messages.getString("SQLError.66"));@b@@b@ sqlStateMessages.put("S1009", Messages.getString("SQLError.67"));@b@@b@ sqlStateMessages.put("S1C00", Messages.getString("SQLError.68"));@b@@b@ sqlStateMessages.put("S1T00", Messages.getString("SQLError.69"));@b@@b@ mysqlToSqlState = new Hashtable();@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1040), "08004");@b@ mysqlToSqlState.put(Constants.integerValueOf(1042), "08004");@b@ mysqlToSqlState.put(Constants.integerValueOf(1043), "08004");@b@ mysqlToSqlState.put(Constants.integerValueOf(1047), "08S01");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1081), "08S01");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1129), "08004");@b@ mysqlToSqlState.put(Constants.integerValueOf(1130), "08004");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1045), "28000");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1037), "S1001");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1038), "S1001");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1064), "42000");@b@ mysqlToSqlState.put(Constants.integerValueOf(1065), "42000");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1055), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1056), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1057), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1059), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1060), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1061), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1062), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1063), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1066), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1067), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1068), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1069), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1070), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1071), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1072), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1073), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1074), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1075), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1082), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1083), "S1009");@b@ mysqlToSqlState.put(Constants.integerValueOf(1084), "S1009");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1058), "21S01");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1051), "42S02");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1054), "S0022");@b@@b@ mysqlToSqlState.put(Constants.integerValueOf(1205), "41000");@b@ mysqlToSqlState.put(Constants.integerValueOf(1213), "41000");@b@@b@ mysqlToSql99State = new HashMap();@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1205), "41000");@b@ mysqlToSql99State.put(Constants.integerValueOf(1213), "41000");@b@ mysqlToSql99State.put(Constants.integerValueOf(1022), "23000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1037), "HY001");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1038), "HY001");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1040), "08004");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1042), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1043), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1044), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1045), "28000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1050), "42S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1051), "42S02");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1052), "23000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1053), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1054), "42S22");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1055), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1056), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1057), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1058), "21S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1059), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1060), "42S21");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1061), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1062), "23000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1063), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1064), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1065), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1066), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1067), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1068), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1069), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1070), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1071), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1072), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1073), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1074), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1075), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1080), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1081), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1082), "42S12");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1083), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1084), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1090), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1091), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1101), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1102), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1103), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1104), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1106), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1107), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1109), "42S02");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1110), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1112), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1113), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1115), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1118), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1120), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1121), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1131), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1132), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1133), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1136), "21S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1138), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1139), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1140), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1141), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1142), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1143), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1144), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1145), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1146), "42S02");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1147), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1148), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1149), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1152), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1153), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1154), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1155), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1156), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1157), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1158), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1159), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1160), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1161), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1162), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1163), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1164), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1166), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1167), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1169), "23000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1170), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1171), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1172), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1173), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1177), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1178), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1179), "25000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1184), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1189), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1190), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1203), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1207), "25000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1211), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1213), "40001");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1216), "23000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1217), "23000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1218), "08S01");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1222), "21000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1226), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1230), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1231), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1232), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1234), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1235), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1239), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1241), "21000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1242), "21000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1247), "42S22");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1248), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1249), "01000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1250), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1251), "08004");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1252), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1253), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1261), "01000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1262), "01000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1263), "01000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1264), "01000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1265), "01000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1280), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1281), "42000");@b@@b@ mysqlToSql99State.put(Constants.integerValueOf(1286), "42000");@b@ }@b@}
2.LocalizedErrorMessages.properties
...@b@@b@Statement.0=Connection is closed.@b@Statement.2=Unsupported character encoding ''{0}''@b@Statement.5=Illegal value for setFetchDirection().@b@Statement.7=Illegal value for setFetchSize().@b@Statement.11=Illegal value for setMaxFieldSize().@b@Statement.13=Can not set max field size > max allowed packet of {0} bytes.@b@Statement.15=setMaxRows() out of range. @b@Statement.19=Illegal flag for getMoreResults(int).@b@Statement.21=Illegal value for setQueryTimeout().@b@Statement.27=Connection is read-only. @b@Statement.28=Queries leading to data modification are not allowed.@b@Statement.34=Connection is read-only. @b@Statement.35=Queries leading to data modification are not allowed.@b@Statement.40=Can not issue INSERT/UPDATE/DELETE with executeQuery().@b@Statement.42=Connection is read-only. @b@Statement.43=Queries leading to data modification are not allowed.@b@Statement.46=Can not issue SELECT via executeUpdate().@b@Statement.49=No operations allowed after statement closed.@b@Statement.57=Can not issue data manipulation statements with executeQuery().@b@Statement.59=Can not issue NULL query.@b@Statement.61=Can not issue empty query.@b@Statement.63=Statement not closed explicitly. You should call close() on created@b@Statement.64=Statement instances from your code to be more efficient.@b@@b@UpdatableResultSet.1=Can not call deleteRow() when on insert row.@b@UpdatableResultSet.2=Can not call deleteRow() on empty result set.@b@UpdatableResultSet.3=Before start of result set. Can not call deleteRow().@b@UpdatableResultSet.4=After end of result set. Can not call deleteRow().@b@UpdatableResultSet.7=Not on insert row.@b@UpdatableResultSet.8=Can not call refreshRow() when on insert row.@b@UpdatableResultSet.9=Can not call refreshRow() on empty result set.@b@UpdatableResultSet.10=Before start of result set. Can not call refreshRow().@b@UpdatableResultSet.11=After end of result set. Can not call refreshRow().@b@UpdatableResultSet.12=refreshRow() called on row that has been deleted or had primary key changed.@b@UpdatableResultSet.34=Updatable result set created, but never updated. You should only create updatable result sets when you want to update/insert/delete values using the updateRow(), deleteRow() and insertRow() methods.@b@UpdatableResultSet.39=Unsupported character encoding ''{0}''.@b@UpdatableResultSet.43=Can not create updatable result sets when there is no currently selected database and MySQL server version < 4.1.@b@@b@ ...@b@ @b@CallableStatement.2=Parameter name can not be NULL or zero-length.@b@CallableStatement.3=No parameter named '@b@CallableStatement.4='@b@CallableStatement.5=Parameter named '@b@CallableStatement.6=' is not an OUT parameter@b@CallableStatement.7=No output parameters registered.@b@CallableStatement.8=No output parameters returned by procedure.@b@CallableStatement.9=Parameter number @b@CallableStatement.10=\ is not an OUT parameter@b@CallableStatement.11=Parameter index of @b@CallableStatement.12=\ is out of range (1, @b@CallableStatement.13=)@b@CallableStatement.14=Can not use streaming result sets with callable statements that have output parameters@b@CallableStatement.1=Unable to retrieve metadata for procedure.@b@CallableStatement.0=Parameter name can not be @b@CallableStatement.15=null.@b@CallableStatement.16=empty.@b@CallableStatement.21=Parameter @b@CallableStatement.22=\ is not registered as an output parameter@b@CommunicationsException.2=\ is longer than the server configured value of @b@CommunicationsException.3='wait_timeout'@b@CommunicationsException.4='interactive_timeout'@b@CommunicationsException.5=may or may not be greater than the server-side timeout @b@CommunicationsException.6=(the driver was unable to determine the value of either the @b@CommunicationsException.7='wait_timeout' or 'interactive_timeout' configuration values from @b@CommunicationsException.8=the server.@b@CommunicationsException.9_1=The last packet successfully received from the server was@b@CommunicationsException.9_2=\ seconds ago.@b@CommunicationsException.9=The last packet sent successfully to the server was @b@CommunicationsException.10=\ seconds ago, which @b@CommunicationsException.11=. You should consider either expiring and/or testing connection validity @b@CommunicationsException.12=before use in your application, increasing the server configured values for client timeouts, @b@CommunicationsException.13=or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.@b@CommunicationsException.14=The driver was unable to create a connection due to @b@CommunicationsException.15=an inability to establish the client portion of a socket.\n\n@b@CommunicationsException.16=This is usually caused by a limit on the number of sockets imposed by @b@CommunicationsException.17=the operating system. This limit is usually configurable. \n\n@b@CommunicationsException.18=For Unix-based platforms, see the manual page for the 'ulimit' command. Kernel or system reconfiguration may also be required.@b@CommunicationsException.19=\n\nFor Windows-based platforms, see Microsoft Knowledge Base Article 196271 (Q196271).@b@CommunicationsException.19a=The configuration parameter \"localSocketAddress\" has been set to a network interface not available for use by the JVM.@b@CommunicationsException.20=Communications link failure@b@CommunicationsException.21=\ due to underlying exception: @b@CommunicationsException.ClientWasStreaming=Application was streaming results when the connection failed. Consider raising value of 'net_write_timeout' on the server.@b@NonRegisteringDriver.3=Hostname of MySQL Server@b@NonRegisteringDriver.7=Port number of MySQL Server@b@NonRegisteringDriver.13=Username to authenticate as@b@NonRegisteringDriver.16=Password to use for authentication@b@NonRegisteringDriver.17=Cannot load connection class because of underlying exception: '@b@NonRegisteringDriver.18='.@b@NonRegisteringDriver.37=Must specify port after ':' in connection string@b@SQLError.35=Disconnect error@b@SQLError.36=Data truncated@b@SQLError.37=Privilege not revoked@b@SQLError.38=Invalid connection string attribute@b@SQLError.39=Error in row@b@SQLError.40=No rows updated or deleted@b@SQLError.41=More than one row updated or deleted@b@SQLError.42=Wrong number of parameters@b@SQLError.43=Unable to connect to data source@b@SQLError.44=Connection in use@b@SQLError.45=Connection not open@b@SQLError.46=Data source rejected establishment of connection@b@SQLError.47=Connection failure during transaction@b@SQLError.48=Communication link failure@b@SQLError.49=Insert value list does not match column list@b@SQLError.50=Numeric value out of range@b@SQLError.51=Datetime field overflow@b@SQLError.52=Division by zero@b@SQLError.53=Deadlock found when trying to get lock; Try restarting transaction@b@SQLError.54=Invalid authorization specification@b@SQLError.55=Syntax error or access violation@b@SQLError.56=Base table or view not found@b@SQLError.57=Base table or view already exists@b@SQLError.58=Base table not found@b@SQLError.59=Index already exists@b@SQLError.60=Index not found@b@SQLError.61=Column already exists@b@SQLError.62=Column not found@b@SQLError.63=No default for column@b@SQLError.64=General error@b@SQLError.65=Memory allocation failure@b@SQLError.66=Invalid column number@b@SQLError.67=Invalid argument value@b@SQLError.68=Driver not capable@b@SQLError.69=Timeout expired@b@ChannelBuffer.0=Unsupported character encoding '@b@ChannelBuffer.1='@b@Field.12=Unsupported character encoding '@b@Field.13='@b@@b@Blob.0=indexToWriteAt must be >= 1@b@Blob.1=IO Error while writing bytes to blob@b@Blob.2=Position 'pos' can not be < 1@b@Blob.invalidStreamLength=Requested stream length of {2} is out of range, given blob length of {0} and starting position of {1}.@b@Blob.invalidStreamPos=Position 'pos' can not be < 1 or > blob length.@b@@b@StringUtils.0=Unsupported character encoding '@b@StringUtils.1='.@b@StringUtils.5=Unsupported character encoding '@b@StringUtils.6='.@b@StringUtils.10=Unsupported character encoding '@b@StringUtils.11='.@b@RowDataDynamic.2=WARN: Possible incomplete traversal of result set. Streaming result set had @b@RowDataDynamic.3=\ rows left to read when it was closed.@b@RowDataDynamic.4=\n\nYou should consider re-formulating your query to @b@RowDataDynamic.5=return only the rows you are interested in using.@b@RowDataDynamic.6=\n\nResultSet was created at: @b@RowDataDynamic.7=\n\nNested Stack Trace:\n@b@RowDataDynamic.8=Error retrieving record: Unexpected Exception: @b@RowDataDynamic.9=\ message given: @b@RowDataDynamic.10=Operation not supported for streaming result sets@b@Clob.0=indexToWriteAt must be >= 1@b@Clob.1=indexToWriteAt must be >= 1@b@Clob.2=Starting position can not be < 1@b@Clob.3=String to set can not be NULL@b@Clob.4=Starting position can not be < 1@b@Clob.5=String to set can not be NULL@b@Clob.6=CLOB start position can not be < 1@b@Clob.7=CLOB start position + length can not be > length of CLOB@b@Clob.8=Illegal starting position for search, '@b@Clob.9='@b@Clob.10=Starting position for search is past end of CLOB@b@Clob.11=Cannot truncate CLOB of length @b@Clob.12=\ to length of @b@Clob.13=.@b@PacketTooBigException.0=Packet for query is too large (@b@PacketTooBigException.1=\ > @b@PacketTooBigException.2=). @b@PacketTooBigException.3=You can change this value on the server by setting the @b@PacketTooBigException.4=max_allowed_packet' variable.@b@Util.1=\n\n** BEGIN NESTED EXCEPTION ** \n\n@b@Util.2=\nMESSAGE: @b@Util.3=\n\nSTACKTRACE:\n\n@b@Util.4=\n\n** END NESTED EXCEPTION **\n\n@b@MiniAdmin.0=Conection can not be null.@b@MiniAdmin.1=MiniAdmin can only be used with MySQL connections@b@NamedPipeSocketFactory.2=Can not specify NULL or empty value for property '@b@NamedPipeSocketFactory.3='.@b@NamedPipeSocketFactory.4=Named pipe path can not be null or empty@b@MysqlIO.1=Unexpected end of input stream@b@MysqlIO.2=Reading packet of length @b@MysqlIO.3=\nPacket header:\n@b@MysqlIO.4=readPacket() payload:\n@b@MysqlIO.8=Slow query explain results for '@b@MysqlIO.9=' :\n\n@b@MysqlIO.10=\ message from server: "@b@MysqlIO.15=SSL Connection required, but not supported by server.@b@MysqlIO.17=Attempt to close streaming result set @b@MysqlIO.18=\ when no streaming result set was registered. This is an internal error.@b@MysqlIO.19=Attempt to close streaming result set @b@MysqlIO.20=\ that was not registered.@b@MysqlIO.21=\ Only one streaming result set may be open and in use per-connection. Ensure that you have called .close() on @b@MysqlIO.22=\ any active result sets before attempting more queries.@b@MysqlIO.23=Can not use streaming results with multiple result statements@b@MysqlIO.25=\ ... (truncated)@b@MysqlIO.SlowQuery=Slow query (exceeded {0} {1}, duration: {2} {1}): @b@Nanoseconds=ns@b@Milliseconds=ms@b@MysqlIO.28=Not issuing EXPLAIN for query of size > @b@MysqlIO.29=\ bytes.@b@MysqlIO.33=The following query was executed with a bad index, use 'EXPLAIN' for more details: @b@MysqlIO.35=The following query was executed using no index, use 'EXPLAIN' for more details: @b@MysqlIO.36=\n\nLarge packet dump truncated at @b@MysqlIO.37=\ bytes.@b@MysqlIO.39=Streaming result set @b@MysqlIO.40=\ is still active.@b@MysqlIO.41=\ No statements may be issued when any streaming result sets are open and in use on a given connection.@b@MysqlIO.42=\ Ensure that you have called .close() on any active streaming result sets before attempting more queries.@b@MysqlIO.43=Unexpected end of input stream@b@MysqlIO.44=Reading reusable packet of length @b@MysqlIO.45=\nPacket header:\n@b@MysqlIO.46=reuseAndReadPacket() payload:\n@b@MysqlIO.47=Unexpected end of input stream@b@MysqlIO.48=Unexpected end of input stream@b@MysqlIO.49=Packets received out of order@b@MysqlIO.50=Short read from server, expected @b@MysqlIO.51=\ bytes, received only @b@MysqlIO.53=Packets received out of order@b@MysqlIO.54=Short read from server, expected @b@MysqlIO.55=\ bytes, received only @b@MysqlIO.57=send() compressed packet:\n@b@MysqlIO.58=\n\nOriginal packet (uncompressed):\n@b@MysqlIO.59=send() packet payload:\n@b@MysqlIO.60=Unable to open file @b@MysqlIO.63=for 'LOAD DATA LOCAL INFILE' command.@b@MysqlIO.64=Due to underlying IOException: @b@MysqlIO.65=Unable to close local file during LOAD DATA LOCAL INFILE command@b@MysqlIO.68=\ message from server: "@b@MysqlIO.70=Unknown column@b@MysqlIO.72=\ message from server: "@b@MysqlIO.75=No name specified for socket factory@b@MysqlIO.76=Could not create socket factory '@b@MysqlIO.77=' due to underlying exception: @b@MysqlIO.79=Unexpected end of input stream@b@MysqlIO.80=Unexpected end of input stream@b@MysqlIO.81=Unexpected end of input stream@b@MysqlIO.82=Unexpected end of input stream@b@MysqlIO.83=Packets received out of order@b@MysqlIO.84=Packets received out of order@b@MysqlIO.85=Unexpected end of input stream@b@MysqlIO.86=Unexpected end of input stream@b@MysqlIO.87=Unexpected end of input stream@b@MysqlIO.88=Packets received out of order@b@MysqlIO.89=Packets received out of order@b@MysqlIO.91=Failed to create message digest 'SHA-1' for authentication. @b@MysqlIO.92=\ You must use a JDK that supports JCE to be able to use secure connection authentication@b@MysqlIO.93=Failed to create message digest 'SHA-1' for authentication. @b@MysqlIO.94=\ You must use a JDK that supports JCE to be able to use secure connection authentication@b@MysqlIO.95=Failed to create message digest 'SHA-1' for authentication. @b@MysqlIO.96=\ You must use a JDK that supports JCE to be able to use secure connection authentication@b@MysqlIO.97=Unknown type '@b@MysqlIO.98=\ in column @b@MysqlIO.99=\ of @b@MysqlIO.100=\ in binary-encoded result set.@b@MysqlIO.102=, underlying cause: @b@MysqlIO.EOF=Can not read response from server. Expected to read {0} bytes, read {1} bytes before connection was unexpectedly lost.@b@MysqlIO.NoInnoDBStatusFound=No InnoDB status output returned by server.@b@MysqlIO.InnoDBStatusFailed=Couldn't retrieve InnoDB status due to underlying exception: @b@MysqlIO.LoadDataLocalNotAllowed=Server asked for stream in response to LOAD DATA LOCAL INFILE but functionality is disabled at client by 'allowLoadLocalInfile' being set to 'false'.@b@NotImplemented.0=Feature not implemented@b@PreparedStatement.0=SQL String can not be NULL@b@PreparedStatement.1=SQL String can not be NULL@b@PreparedStatement.2=Parameter index out of range (@b@PreparedStatement.3=\ > @b@PreparedStatement.4=)@b@PreparedStatement.16=Unknown Types value@b@PreparedStatement.17=Cannot convert @b@PreparedStatement.18=\ to SQL type requested due to @b@PreparedStatement.19=\ - @b@PreparedStatement.20=Connection is read-only. @b@PreparedStatement.21=Queries leading to data modification are not allowed@b@PreparedStatement.25=Connection is read-only. @b@PreparedStatement.26=Queries leading to data modification are not allowed@b@PreparedStatement.32=Unsupported character encoding '@b@PreparedStatement.33='@b@PreparedStatement.34=Connection is read-only. @b@PreparedStatement.35=Queries leading to data modification are not allowed@b@PreparedStatement.37=Can not issue executeUpdate() for SELECTs@b@PreparedStatement.40=No value specified for parameter @b@PreparedStatement.43=PreparedStatement created, but used 1 or fewer times. It is more efficient to prepare statements once, and re-use them many times@b@PreparedStatement.48=PreparedStatement has been closed. No further operations allowed.@b@PreparedStatement.49=Parameter index out of range (@b@PreparedStatement.50=\ < 1 ).@b@PreparedStatement.51=Parameter index out of range (@b@PreparedStatement.52=\ > number of parameters, which is @b@PreparedStatement.53=).@b@PreparedStatement.54=Invalid argument value: @b@PreparedStatement.55=Error reading from InputStream @b@PreparedStatement.56=Error reading from InputStream @b@PreparedStatement.61=SQL String can not be NULL@b@ServerPreparedStatement.2=Connection is read-only. @b@ServerPreparedStatement.3=Queries leading to data modification are not allowed@b@ServerPreparedStatement.6=\ unable to materialize as string due to underlying SQLException: @b@ServerPreparedStatement.7=Not supported for server-side prepared statements.@b@ServerPreparedStatement.8=No parameters defined during prepareCall()@b@ServerPreparedStatement.9=Parameter index out of bounds. @b@ServerPreparedStatement.10=\ is not between valid values of 1 and @b@ServerPreparedStatement.11=Driver can not re-execute prepared statement when a parameter has been changed @b@ServerPreparedStatement.12=from a streaming type to an intrinsic data type without calling clearParameters() first.@b@ServerPreparedStatement.13=Statement parameter @b@ServerPreparedStatement.14=\ not set.@b@ServerPreparedStatement.15=Slow query (exceeded @b@ServerPreparedStatement.15a=\ ms., duration:\ @b@ServerPreparedStatement.16=\ ms): @b@ServerPreparedStatement.18=Unknown LONG DATA type '@b@ServerPreparedStatement.22=Unsupported character encoding '@b@ServerPreparedStatement.24=Error while reading binary stream: @b@ServerPreparedStatement.25=Error while reading binary stream: @b@ByteArrayBuffer.0=ByteArrayBuffer has no NIO buffers@b@ByteArrayBuffer.1=Unsupported character encoding '@b@AssertionFailedException.0=ASSERT FAILS: Exception @b@AssertionFailedException.1=\ that should not be thrown, was thrown@b@@b@...