| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mysql >> MySQL数据库常见的出错代码及出错信息 MySQL shu ju ku chang jian de chu cuo dai ma ji chu cuo xin xi
 

MySQL数据库常见的出错代码及出错信息

2008-06-01 03:25:05 编辑來源:互联网 繁體版 评论
 
 
本文为【MySQL数据库常见的出错代码及出错信息】的汉字拼音对照版显示拼音
  benwenjieshaodeMySQLshujukudechucuodaimabiaoyijuMySQLshujukutouwenjianmysql/include/mysqld_error.hzhenglierchengxiangxineirongqingdajiashenkaoxiawen

  1005chuangjianbiaoshibai

  1006chuangjianshujukushibai

  1007shujukuyicunzaichuangjianshujukushibai

  1008shujukubucunzaishanchushujukushibai

  1009bunengshanchushujukuwenjiandaozhishanchushujukushibai

  1010bunengshanchushujumuludaozhishanchushujukushibai

  1011shanchushujukuwenjianshibai

  1012bunengduquxitongbiaozhongdejilu

  1020jiluyibeiqitayonghuxiugai

  1021yingpanshengyukongjianbuzuqingjiadayingpankeyongkongjian

  1022guanjianzichongfugenggaijilushibai

  1023guanbishifashengcuowu

  1024duwenjiancuowu

  1025genggaimingzishifashengcuowu

  1026xiewenjiancuowu

  1032jilubucunzai

  1036shujubiaoshizhidudebunengduitajinxingxiugai

  1037xitongneicunbuzuqingchongqishujukuhuochongqifuwuqi

  1038yongyupaixudeneicunbuzuqingzengdapaixuhuanchongqu

  1040yidaodashujukudezuidalianjieshuqingjiadashujukukeyonglianjieshu

  1041xitongneicunbuzu

  1042wuxiaodezhujiming

  1043wuxiaolianjie

  1044dangqianyonghumeiyou访fangwenshujukudequanxian

  1045bunenglianjieshujukuyonghuminghuomimacuowu

  1048ziduanbunengweikong

  1049shujukubucunzai

  1050shujubiaoyicunzai

  1051shujubiaobucunzai

  1054ziduanbucunzai

  1065wuxiaodeSQLyujuSQLyujuweikong

  1081bunengjianliSocketlianjie

  1114shujubiaoyimanbunengrongnarenhejilu

  1116dakaideshujubiaotaiduo

  1129shujukuchuxianyichangqingchongqishujuku

  1130lianjieshujukushibaimeiyoulianjieshujukudequanxian

  1133shujukuyonghubucunzai

  1141dangqianyonghuwuquan访fangwenshujuku

  1142dangqianyonghuwuquan访fangwenshujubiao

  1143dangqianyonghuwuquan访fangwenshujubiaozhongdeziduan

  1146shujubiaobucunzai

  1147weidingyiyonghuduishujubiaode访fangwenquanxian

  1149SQLyujuyufacuowu

  1158wangluocuowuchuxianducuowuqingjianchawangluolianjiezhuangkuang

  1159wangluocuowuduchaoshiqingjianchawangluolianjiezhuangkuang

  1160wangluocuowuchuxianxiecuowuqingjianchawangluolianjiezhuangkuang

  1161wangluocuowuxiechaoshiqingjianchawangluolianjiezhuangkuang

  1062ziduanzhichongfurukushibai

  1169ziduanzhichongfugengxinjilushibai

  1177dakaishujubiaoshibai

  1180tijiaoshiwushibai

  1181huigunshiwushibai

  1203dangqianyonghuheshujukujianlidelianjieyidaodashujukudezuidalianjieshuqingzengdakeyongdeshujukulianjieshuhuochongqishujuku

  1205jiasuochaoshi

  1211dangqianyonghumeiyouchuangjianyonghudequanxian

  1216waijianyueshujianchashibaigengxinzibiaojilushibai

  1217waijianyueshujianchashibaishanchuhuoxiugaizhubiaojilushibai

  1226dangqianyonghu使shiyongdeziyuanyichaoguosuoyuanxudeziyuanqingchongqishujukuhuochongqifuwuqi

  1227quanxianbuzuninwuquanjinxingcicaozuo

  1235MySQLbanbenguodibujuyoubengongneng

  

  fudaiyigejavaleikeyibamysqldechucuodaimafanyichengduiyingdechucuoxinxi

  import java.util.*;

  public class MyErrorContext

  {

  public static class MyError

  {

  int errno;

  String szErrorDesc;

  public MyError(int errno, String errorDesc)

  {

  this.errno = errno;

  this.szErrorDesc = errorDesc;

  }

  public int getErrorNo()

  {

  return errno;

  }

  public String getErrorDesc()

  {

  return szErrorDesc;

  }

  }

  public static final int DB_ER_CANT_CREATE_TABLE = 1005; //chuangjianbiaoshibai

  public static final int DB_ER_CANT_CREATE_DB = 1006; //chuangjianshujukushibai

  public static final int DB_ER_DB_CREATE_EXISTS = 1007; //shujukuyicunzaichuangjianshujukushibai

  public static final int DB_ER_DB_DROP_EXISTS = 1008; //shujukubucunzaishanchushujukushibai

  public static final int DB_ER_DB_DROP_DELETE = 1009; //bunengshanchushujukuwenjiandaozhishanchushujukushibai

  public static final int DB_ER_DB_DROP_RMDIR = 1010; //bunengshanchushujumuludaozhishanchushujukushibai

  public static final int DB_ER_CANT_DELETE_FILE = 1011; //shanchushujukuwenjianshibai

  public static final int DB_ER_CANT_FIND_SYSTEM_REC = 1012; //bunengduquxitongbiaozhongdejilu

  public static final int DB_ER_CHECKREAD = 1020; //jiluyibeiqitayonghuxiugai

  public static final int DB_ER_DISK_FULL = 1021; //yingpanshengyukongjianbuzuqingjiadayingpankeyongkongjian

  public static final int DB_ER_DUP_KEY = 1022; //guanjianzichongfugenggaijilushibai

  public static final int DB_ER_ERROR_ON_CLOSE = 1023; //guanbishifashengcuowu

  public static final int DB_ER_ERROR_ON_READ = 1024; //duwenjiancuowu

  public static final int DB_ER_ERROR_ON_RENAME = 1025; //genggaimingzishifashengcuowu

  public static final int DB_ER_ERROR_ON_WRITE = 1026; //xiewenjiancuowu

  public static final int DB_ER_KEY_NOT_FOUND = 1032; //jilubucunzai

  public static final int DB_ER_OPEN_AS_READONLY = 1036; //shujubiaoshizhidudebunengduitajinxingxiugai

  public static final int DB_ER_OUTOFMEMORY = 1037; //xitongneicunbuzuqingchongqishujukuhuochongqifuwuqi

  public static final int DB_ER_OUT_OF_SORTMEMORY = 1038; //yongyupaixudeneicunbuzuqingzengdapaixuhuanchongqu

  public static final int DB_ER_CON_COUNT_ERROR = 1040; //yidaodashujukudezuidalianjieshuqingjiadashujukukeyonglianjieshu

  public static final int DB_ER_OUT_OF_RESOURCES = 1041; //xitongneicunbuzu

  public static final int DB_ER_BAD_HOST_ERROR = 1042; //wuxiaodezhujiming

  public static final int DB_ER_HANDSHAKE_ERROR = 1043; //wuxiaolianjie

  public static final int DB_ER_DBACCESS_DENIED_ERROR = 1044; //dangqianyonghumeiyou访fangwenshujukudequanxian

  public static final int DB_ER_ACCESS_DENIED_ERROR = 1045; //bunenglianjieshujukuyonghuminghuomimacuowu

  public static final int DB_ER_BAD_NULL_ERROR = 1048; //ziduanbunengweikong

  public static final int DB_ER_BAD_DB_ERROR = 1049; //shujukubucunzai

  public static final int DB_ER_TABLE_EXISTS_ERROR = 1050; //shujubiaoyicunzai

  public static final int DB_ER_BAD_TABLE_ERROR = 1051; //shujubiaobucunzai

  public static final int DB_ER_BAD_FIELD_ERROR = 1054; //ziduanbucunzai

  public static final int DB_ER_EMPTY_QUERY = 1065; //wuxiaodeSQLyujuSQLyujuweikong

  public static final int DB_ER_IPSOCK_ERROR = 1081; //bunengjianliSocketlianjie

  public static final int DB_ER_RECORD_FILE_FULL = 1114; //shujubiaoyimanbunengrongnarenhejilu

  public static final int DB_ER_TOO_MANY_TABLES = 1116; //dakaideshujubiaotaiduo

  public static final int DB_ER_HOST_IS_BLOCKED = 1129; //shujukuchuxianyichangqingchongqishujuku

  public static final int DB_ER_HOST_NOT_PRIVILEGED = 1130; //lianjieshujukushibaimeiyoulianjieshujukudequanxian

  public static final int DB_ER_PASSWORD_NO_MATCH = 1133; //shujukuyonghubucunzai

  public static final int DB_ER_NONEXISTING_GRANT = 1141; //dangqianyonghuwuquan访fangwenshujuku

  public static final int DB_ER_TABLEACCESS_DENIED_ERROR = 1142; //dangqianyonghuwuquan访fangwenshujubiao

  public static final int DB_ER_COLUMNACCESS_DENIED_ERROR = 1143; //dangqianyonghuwuquan访fangwenshujubiaozhongdeziduan

  public static final int DB_ER_NO_SUCH_TABLE = 1146; //shujubiaobucunzai

  public static final int DB_ER_NONEXISTING_TABLE_GRANT = 1147; //weidingyiyonghuduishujubiaode访fangwenquanxian

  public static final int DB_ER_SYNTAX_ERROR = 1149; //SQLyujuyufacuowu

  public static final int DB_ER_NET_READ_ERROR = 1158; //wangluocuowuchuxianducuowuqingjianchawangluolianjiezhuangkuang

  public static final int DB_ER_NET_READ_INTERRUPTED = 1159; //wangluocuowuduchaoshiqingjianchawangluolianjiezhuangkuang

  public static final int DB_ER_NET_ERROR_ON_WRITE = 1160; //wangluocuowuchuxianxiecuowuqingjianchawangluolianjiezhuangkuang

  public static final int DB_ER_NET_WRITE_INTERRUPTED = 1161; //wangluocuowuxiechaoshiqingjianchawangluolianjiezhuangkuang

  public static final int DB_ER_DUP_ENTRY = 1062; //ziduanzhichongfurukushibai

  public static final int DB_ER_DUP_UNIQUE = 1169; //ziduanzhichongfugengxinjilushibai

  public static final int DB_ER_CHECK_NO_SUCH_TABLE = 1177; //dakaishujubiaoshibai

  public static final int DB_ER_ERROR_DURING_COMMIT = 1180; //tijiaoshiwushibai

  public static final int DB_ER_ERROR_DURING_ROLLBACK = 1181; //huigunshiwushibai

  public static final int DB_ER_TOO_MANY_USER_CONNECTIONS = 1203; //dangqianyonghuheshujukujianlidelianjieyidaodashujukudezuidalianjieshuqingzengdakeyongdeshujukulianjieshuhuochongqishujuku

  public static final int DB_ER_LOCK_WAIT_TIMEOUT = 1205; //jiasuochaoshi

  public static final int DB_ER_NO_PERMISSION_TO_CREATE_USER = 1211; //dangqianyonghumeiyouchuangjianyonghudequanxian

  public static final int DB_ER_NO_REFERENCED_ROW = 1216; //waijianyueshujianchashibaigengxinzibiaojilushibai

  public static final int DB_ER_ROW_IS_REFERENCED = 1217; //waijianyueshujianchashibaishanchuhuoxiugaizhubiaojilushibai

  public static final int DB_ER_USER_LIMIT_REACHED = 1226; //dangqianyonghu使shiyongdeziyuanyichaoguosuoyuanxudeziyuanqingchongqishujukuhuochongqifuwuqi

  public static final int DB_ER_SPECIFIC_ACCESS_DENIED_ERROR = 1227; //quanxianbuzuninwuquanjinxingcicaozuo

  public static final int DB_ER_NOT_SUPPORTED_YET = 1235; //MySQLbanbenguodibujuyoubengongneng

  private static final MyError[] errormap =

  {

  new MyError(DB_ER_CANT_CREATE_TABLE ,"chuangjianbiaoshibai"),

  new MyError(DB_ER_CANT_CREATE_DB ,"chuangjianshujukushibai"),

  new MyError(DB_ER_DB_CREATE_EXISTS ,"shujukuyicunzaichuangjianshujukushibai"),

  new MyError(DB_ER_DB_DROP_EXISTS ,"shujukubucunzaishanchushujukushibai"),

  new MyError(DB_ER_DB_DROP_DELETE ,"bunengshanchushujukuwenjiandaozhishanchushujukushibai"),

  new MyError(DB_ER_DB_DROP_RMDIR ,"bunengshanchushujumuludaozhishanchushujukushibai"),

  new MyError(DB_ER_CANT_DELETE_FILE ,"shanchushujukuwenjianshibai"),

  new MyError(DB_ER_CANT_FIND_SYSTEM_REC ,"bunengduquxitongbiaozhongdejilu"),

  new MyError(DB_ER_CHECKREAD ,"jiluyibeiqitayonghuxiugai"),

  new MyError(DB_ER_DISK_FULL ,"yingpanshengyukongjianbuzuqingjiadayingpankeyongkongjian"),

  new MyError(DB_ER_DUP_KEY ,"guanjianzichongfugenggaijilushibai"),

  new MyError(DB_ER_ERROR_ON_CLOSE ,"guanbishifashengcuowu"),

  new MyError(DB_ER_ERROR_ON_READ ,"duwenjiancuowu"),

  new MyError(DB_ER_ERROR_ON_RENAME ,"genggaimingzishifashengcuowu"),

  new MyError(DB_ER_ERROR_ON_WRITE ,"xiewenjiancuowu"),

  new MyError(DB_ER_KEY_NOT_FOUND ,"jilubucunzai"),

  new MyError(DB_ER_OPEN_AS_READONLY ,"shujubiaoshizhidudebunengduitajinxingxiugai"),

  new MyError(DB_ER_OUTOFMEMORY ,"xitongneicunbuzuqingchongqishujukuhuochongqifuwuqi"),

  new MyError(DB_ER_OUT_OF_SORTMEMORY ,"yongyupaixudeneicunbuzuqingzengdapaixuhuanchongqu"),

  new MyError(DB_ER_CON_COUNT_ERROR ,"yidaodashujukudezuidalianjieshuqingjiadashujukukeyonglianjieshu"),

  new MyError(DB_ER_OUT_OF_RESOURCES ,"xitongneicunbuzu"),

  new MyError(DB_ER_BAD_HOST_ERROR ,"wuxiaodezhujiming"),

  new MyError(DB_ER_HANDSHAKE_ERROR ,"wuxiaolianjie"),

  new MyError(DB_ER_DBACCESS_DENIED_ERROR ,"dangqianyonghumeiyou访fangwenshujukudequanxian"),

  new MyError(DB_ER_ACCESS_DENIED_ERROR ,"bunenglianjieshujukuyonghuminghuomimacuowu"),

  new MyError(DB_ER_BAD_NULL_ERROR ,"ziduanbunengweikong"),

  new MyError(DB_ER_BAD_DB_ERROR ,"shujukubucunzai"),

  new MyError(DB_ER_TABLE_EXISTS_ERROR ,"shujubiaoyicunzai"),

  new MyError(DB_ER_BAD_TABLE_ERROR ,"shujubiaobucunzai"),

  new MyError(DB_ER_BAD_FIELD_ERROR ,"ziduanbucunzai"),

  new MyError(DB_ER_EMPTY_QUERY ,"wuxiaodeSQLyujuSQLyujuweikong"),

  new MyError(DB_ER_IPSOCK_ERROR ,"bunengjianliSocketlianjie"),

  new MyError(DB_ER_RECORD_FILE_FULL ,"shujubiaoyimanbunengrongnarenhejilu"),

  new MyError(DB_ER_TOO_MANY_TABLES ,"dakaideshujubiaotaiduo"),

  new MyError(DB_ER_HOST_IS_BLOCKED ,"shujukuchuxianyichangqingchongqishujuku"),

  new MyError(DB_ER_HOST_NOT_PRIVILEGED ,"lianjieshujukushibaimeiyoulianjieshujukudequanxian"),

  new MyError(DB_ER_PASSWORD_NO_MATCH ,"shujukuyonghubucunzai"),

  new MyError(DB_ER_NONEXISTING_GRANT ,"dangqianyonghuwuquan访fangwenshujuku"),

  new MyError(DB_ER_TABLEACCESS_DENIED_ERROR ,"dangqianyonghuwuquan访fangwenshujubiao"),

  new MyError(DB_ER_COLUMNACCESS_DENIED_ERROR ,"dangqianyonghuwuquan访fangwenshujubiaozhongdeziduan"),

  new MyError(DB_ER_NO_SUCH_TABLE ,"shujubiaobucunzai"),

  new MyError(DB_ER_NONEXISTING_TABLE_GRANT ,"weidingyiyonghuduishujubiaode访fangwenquanxian"),

  new MyError(DB_ER_SYNTAX_ERROR ,"SQLyujuyufacuowu"),

  new MyError(DB_ER_NET_READ_ERROR ,"wangluocuowuchuxianducuowuqingjianchawangluolianjiezhuangkuang"),

  new MyError(DB_ER_NET_READ_INTERRUPTED ,"wangluocuowuduchaoshiqingjianchawangluolianjiezhuangkuang"),

  new MyError(DB_ER_NET_ERROR_ON_WRITE ,"wangluocuowuchuxianxiecuowuqingjianchawangluolianjiezhuangkuang"),

  new MyError(DB_ER_NET_WRITE_INTERRUPTED ,"wangluocuowuxiechaoshiqingjianchawangluolianjiezhuangkuang"),

  new MyError(DB_ER_DUP_ENTRY ,"ziduanzhichongfurukushibai"),

  new MyError(DB_ER_DUP_UNIQUE ,"ziduanzhichongfugengxinjilushibai"),

  new MyError(DB_ER_CHECK_NO_SUCH_TABLE ,"dakaishujubiaoshibai"),

  new MyError(DB_ER_ERROR_DURING_COMMIT ,"tijiaoshiwushibai"),

  new MyError(DB_ER_ERROR_DURING_ROLLBACK ,"huigunshiwushibai"),

  new MyError(DB_ER_TOO_MANY_USER_CONNECTIONS ,"dangqianyonghuheshujukujianlidelianjieyidaodashujukudezuidalianjieshuqingzengdakeyongdeshujukulianjieshuhuochongqishujuku"),

  new MyError(DB_ER_LOCK_WAIT_TIMEOUT ,"jiasuochaoshi"),

  new MyError(DB_ER_NO_PERMISSION_TO_CREATE_USER ,"dangqianyonghumeiyouchuangjianyonghudequanxian"),

  new MyError(DB_ER_NO_REFERENCED_ROW ,"waijianyueshujianchashibaigengxinzibiaojilushibai"),

  new MyError(DB_ER_ROW_IS_REFERENCED ,"waijianyueshujianchashibaishanchuhuoxiugaizhubiaojilushibai"),

  new MyError(DB_ER_USER_LIMIT_REACHED ,"dangqianyonghu使shiyongdeziyuanyichaoguosuoyuanxudeziyuanqingchongqishujukuhuochongqifuwuqi"),

  new MyError(DB_ER_SPECIFIC_ACCESS_DENIED_ERROR ,"quanxianbuzuninwuquanjinxingcicaozuo"),

  new MyError(DB_ER_NOT_SUPPORTED_YET ,"MySQLbanbenguodibujuyoubengongneng"),

  };

  public static String getErrorInfo(int errno)

  {

  for(int i=0; i{

  if(errno == errormap[i].getErrorNo())

  {

  return errormap[i].getErrorDesc();

  }

  }

  return "";

  }

  public static void main(String[] args)

  {

  for(int i=0; i{

  System.out.println(errormap[i].getErrorNo() + "" + errormap[i].getErrorDesc());

  }

  }

  }原文】【拼音
 
 
 
 
上一篇《实例讲解MySQL数据库密码的恢复与重设》
下一篇《使用实例管理器轻松管理多个MySQL实例》
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
本文介绍的MySQL数据库的出错代码表,依据MySQL数据库头文件mysql/include/mysqld_error.h整理而成。详细内容请大家参考下文: 1005:创建表失败 1006:创建数据库失败 1007:数据库已存在,创建数据库失败 1008:数据库不存在,删除数据库失败 1009:不能删除数据库文件导致删除数据库失败 1010:不能删除数据目录导致删除数据库失败 1011:删除数据库文件失败 1012:不能读取系统表中的记录 1020:记录已被其他用户修改 1021:硬盘剩余空间不足,请加大硬盘可用空间 1022:关键字重复,更改记录失败 1023:关闭时发生错误 1024:读文件错误 1025:更改名字时发生错误 1026:写文件错误 1032:记录不存在 1036:数据表是只读的,不能对它进行修改 1037:系统内存不足,请重启数据库或重启服务器 1038:用于排序的内存不足,请增大排序缓冲区 1040:已到达数据库的最大连接数,请加大数据库可用连接数 1041:系统内存不足 1042:无效的主机名 1043:无效连接 1044:当前用户没有访问数据库的权限 1045:不能连接数据库,用户名或密码错误 1048:字段不能为空 1049:数据库不存在 1050:数据表已存在 1051:数据表不存在 1054:字段不存在 1065:无效的SQL语句,SQL语句为空 1081:不能建立Socket连接 1114:数据表已满,不能容纳任何记录 1116:打开的数据表太多 1129:数据库出现异常,请重启数据库 1130:连接数据库失败,没有连接数据库的权限 1133:数据库用户不存在 1141:当前用户无权访问数据库 1142:当前用户无权访问数据表 1143:当前用户无权访问数据表中的字段 1146:数据表不存在 1147:未定义用户对数据表的访问权限 1149:SQL语句语法错误 1158:网络错误,出现读错误,请检查网络连接状况 1159:网络错误,读超时,请检查网络连接状况 1160:网络错误,出现写错误,请检查网络连接状况 1161:网络错误,写超时,请检查网络连接状况 1062:字段值重复,入库失败 1169:字段值重复,更新记录失败 1177:打开数据表失败 1180:提交事务失败 1181:回滚事务失败 1203:当前用户和数据库建立的连接已到达数据库的最大连接数,请增大可用的数据库连接数或重启数据库 1205:加锁超时 1211:当前用户没有创建用户的权限 1216:外键约束检查失败,更新子表记录失败 1217:外键约束检查失败,删除或修改主表记录失败 1226:当前用户使用的资源已超过所允许的资源,请重启数据库或重启服务器 1227:权限不足,您无权进行此操作 1235:MySQL版本过低,不具有本功能 附带一个java类,可以把mysql的出错代码翻译成对应的出错信息: import java.util.*; public class MyErrorContext { public static class MyError { int errno; String szErrorDesc; public MyError(int errno, String errorDesc) { this.errno = errno; this.szErrorDesc = errorDesc; } public int getErrorNo() { return errno; } public String getErrorDesc() { return szErrorDesc; } } public static final int DB_ER_CANT_CREATE_TABLE = 1005; //创建表失败 public static final int DB_ER_CANT_CREATE_DB = 1006; //创建数据库失败 public static final int DB_ER_DB_CREATE_EXISTS = 1007; //数据库已存在,创建数据库失败 public static final int DB_ER_DB_DROP_EXISTS = 1008; //数据库不存在,删除数据库失败 public static final int DB_ER_DB_DROP_DELETE = 1009; //不能删除数据库文件导致删除数据库失败 public static final int DB_ER_DB_DROP_RMDIR = 1010; //不能删除数据目录导致删除数据库失败 public static final int DB_ER_CANT_DELETE_FILE = 1011; //删除数据库文件失败 public static final int DB_ER_CANT_FIND_SYSTEM_REC = 1012; //不能读取系统表中的记录 public static final int DB_ER_CHECKREAD = 1020; //记录已被其他用户修改 public static final int DB_ER_DISK_FULL = 1021; //硬盘剩余空间不足,请加大硬盘可用空间 public static final int DB_ER_DUP_KEY = 1022; //关键字重复,更改记录失败 public static final int DB_ER_ERROR_ON_CLOSE = 1023; //关闭时发生错误 public static final int DB_ER_ERROR_ON_READ = 1024; //读文件错误 public static final int DB_ER_ERROR_ON_RENAME = 1025; //更改名字时发生错误 public static final int DB_ER_ERROR_ON_WRITE = 1026; //写文件错误 public static final int DB_ER_KEY_NOT_FOUND = 1032; //记录不存在 public static final int DB_ER_OPEN_AS_READONLY = 1036; //数据表是只读的,不能对它进行修改 public static final int DB_ER_OUTOFMEMORY = 1037; //系统内存不足,请重启数据库或重启服务器 public static final int DB_ER_OUT_OF_SORTMEMORY = 1038; //用于排序的内存不足,请增大排序缓冲区 public static final int DB_ER_CON_COUNT_ERROR = 1040; //已到达数据库的最大连接数,请加大数据库可用连接数 public static final int DB_ER_OUT_OF_RESOURCES = 1041; //系统内存不足 public static final int DB_ER_BAD_HOST_ERROR = 1042; //无效的主机名 public static final int DB_ER_HANDSHAKE_ERROR = 1043; //无效连接 public static final int DB_ER_DBACCESS_DENIED_ERROR = 1044; //当前用户没有访问数据库的权限 public static final int DB_ER_ACCESS_DENIED_ERROR = 1045; //不能连接数据库,用户名或密码错误 public static final int DB_ER_BAD_NULL_ERROR = 1048; //字段不能为空 public static final int DB_ER_BAD_DB_ERROR = 1049; //数据库不存在 public static final int DB_ER_TABLE_EXISTS_ERROR = 1050; //数据表已存在 public static final int DB_ER_BAD_TABLE_ERROR = 1051; //数据表不存在 public static final int DB_ER_BAD_FIELD_ERROR = 1054; //字段不存在 public static final int DB_ER_EMPTY_QUERY = 1065; //无效的SQL语句,SQL语句为空 public static final int DB_ER_IPSOCK_ERROR = 1081; //不能建立Socket连接 public static final int DB_ER_RECORD_FILE_FULL = 1114; //数据表已满,不能容纳任何记录 public static final int DB_ER_TOO_MANY_TABLES = 1116; //打开的数据表太多 public static final int DB_ER_HOST_IS_BLOCKED = 1129; //数据库出现异常,请重启数据库 public static final int DB_ER_HOST_NOT_PRIVILEGED = 1130; //连接数据库失败,没有连接数据库的权限 public static final int DB_ER_PASSWORD_NO_MATCH = 1133; //数据库用户不存在 public static final int DB_ER_NONEXISTING_GRANT = 1141; //当前用户无权访问数据库 public static final int DB_ER_TABLEACCESS_DENIED_ERROR = 1142; //当前用户无权访问数据表 public static final int DB_ER_COLUMNACCESS_DENIED_ERROR = 1143; //当前用户无权访问数据表中的字段 public static final int DB_ER_NO_SUCH_TABLE = 1146; //数据表不存在 public static final int DB_ER_NONEXISTING_TABLE_GRANT = 1147; //未定义用户对数据表的访问权限 public static final int DB_ER_SYNTAX_ERROR = 1149; //SQL语句语法错误 public static final int DB_ER_NET_READ_ERROR = 1158; //网络错误,出现读错误,请检查网络连接状况 public static final int DB_ER_NET_READ_INTERRUPTED = 1159; //网络错误,读超时,请检查网络连接状况 public static final int DB_ER_NET_ERROR_ON_WRITE = 1160; //网络错误,出现写错误,请检查网络连接状况 public static final int DB_ER_NET_WRITE_INTERRUPTED = 1161; //网络错误,写超时,请检查网络连接状况 public static final int DB_ER_DUP_ENTRY = 1062; //字段值重复,入库失败 public static final int DB_ER_DUP_UNIQUE = 1169; //字段值重复,更新记录失败 public static final int DB_ER_CHECK_NO_SUCH_TABLE = 1177; //打开数据表失败 public static final int DB_ER_ERROR_DURING_COMMIT = 1180; //提交事务失败 public static final int DB_ER_ERROR_DURING_ROLLBACK = 1181; //回滚事务失败 public static final int DB_ER_TOO_MANY_USER_CONNECTIONS = 1203; //当前用户和数据库建立的连接已到达数据库的最大连接数,请增大可用的数据库连接数或重启数据库 public static final int DB_ER_LOCK_WAIT_TIMEOUT = 1205; //加锁超时 public static final int DB_ER_NO_PERMISSION_TO_CREATE_USER = 1211; //当前用户没有创建用户的权限 public static final int DB_ER_NO_REFERENCED_ROW = 1216; //外键约束检查失败,更新子表记录失败 public static final int DB_ER_ROW_IS_REFERENCED = 1217; //外键约束检查失败,删除或修改主表记录失败 public static final int DB_ER_USER_LIMIT_REACHED = 1226; //当前用户使用的资源已超过所允许的资源,请重启数据库或重启服务器 public static final int DB_ER_SPECIFIC_ACCESS_DENIED_ERROR = 1227; //权限不足,您无权进行此操作 public static final int DB_ER_NOT_SUPPORTED_YET = 1235; //MySQL版本过低,不具有本功能 private static final MyError[] errormap = { new MyError(DB_ER_CANT_CREATE_TABLE ,"创建表失败"), new MyError(DB_ER_CANT_CREATE_DB ,"创建数据库失败"), new MyError(DB_ER_DB_CREATE_EXISTS ,"数据库已存在,创建数据库失败"), new MyError(DB_ER_DB_DROP_EXISTS ,"数据库不存在,删除数据库失败"), new MyError(DB_ER_DB_DROP_DELETE ,"不能删除数据库文件导致删除数据库失败"), new MyError(DB_ER_DB_DROP_RMDIR ,"不能删除数据目录导致删除数据库失败"), new MyError(DB_ER_CANT_DELETE_FILE ,"删除数据库文件失败"), new MyError(DB_ER_CANT_FIND_SYSTEM_REC ,"不能读取系统表中的记录"), new MyError(DB_ER_CHECKREAD ,"记录已被其他用户修改"), new MyError(DB_ER_DISK_FULL ,"硬盘剩余空间不足,请加大硬盘可用空间"), new MyError(DB_ER_DUP_KEY ,"关键字重复,更改记录失败"), new MyError(DB_ER_ERROR_ON_CLOSE ,"关闭时发生错误"), new MyError(DB_ER_ERROR_ON_READ ,"读文件错误"), new MyError(DB_ER_ERROR_ON_RENAME ,"更改名字时发生错误"), new MyError(DB_ER_ERROR_ON_WRITE ,"写文件错误"), new MyError(DB_ER_KEY_NOT_FOUND ,"记录不存在"), new MyError(DB_ER_OPEN_AS_READONLY ,"数据表是只读的,不能对它进行修改"), new MyError(DB_ER_OUTOFMEMORY ,"系统内存不足,请重启数据库或重启服务器"), new MyError(DB_ER_OUT_OF_SORTMEMORY ,"用于排序的内存不足,请增大排序缓冲区"), new MyError(DB_ER_CON_COUNT_ERROR ,"已到达数据库的最大连接数,请加大数据库可用连接数"), new MyError(DB_ER_OUT_OF_RESOURCES ,"系统内存不足"), new MyError(DB_ER_BAD_HOST_ERROR ,"无效的主机名"), new MyError(DB_ER_HANDSHAKE_ERROR ,"无效连接"), new MyError(DB_ER_DBACCESS_DENIED_ERROR ,"当前用户没有访问数据库的权限"), new MyError(DB_ER_ACCESS_DENIED_ERROR ,"不能连接数据库,用户名或密码错误"), new MyError(DB_ER_BAD_NULL_ERROR ,"字段不能为空"), new MyError(DB_ER_BAD_DB_ERROR ,"数据库不存在"), new MyError(DB_ER_TABLE_EXISTS_ERROR ,"数据表已存在"), new MyError(DB_ER_BAD_TABLE_ERROR ,"数据表不存在"), new MyError(DB_ER_BAD_FIELD_ERROR ,"字段不存在"), new MyError(DB_ER_EMPTY_QUERY ,"无效的SQL语句,SQL语句为空"), new MyError(DB_ER_IPSOCK_ERROR ,"不能建立Socket连接"), new MyError(DB_ER_RECORD_FILE_FULL ,"数据表已满,不能容纳任何记录"), new MyError(DB_ER_TOO_MANY_TABLES ,"打开的数据表太多"), new MyError(DB_ER_HOST_IS_BLOCKED ,"数据库出现异常,请重启数据库"), new MyError(DB_ER_HOST_NOT_PRIVILEGED ,"连接数据库失败,没有连接数据库的权限"), new MyError(DB_ER_PASSWORD_NO_MATCH ,"数据库用户不存在"), new MyError(DB_ER_NONEXISTING_GRANT ,"当前用户无权访问数据库"), new MyError(DB_ER_TABLEACCESS_DENIED_ERROR ,"当前用户无权访问数据表"), new MyError(DB_ER_COLUMNACCESS_DENIED_ERROR ,"当前用户无权访问数据表中的字段"), new MyError(DB_ER_NO_SUCH_TABLE ,"数据表不存在"), new MyError(DB_ER_NONEXISTING_TABLE_GRANT ,"未定义用户对数据表的访问权限"), new MyError(DB_ER_SYNTAX_ERROR ,"SQL语句语法错误"), new MyError(DB_ER_NET_READ_ERROR ,"网络错误,出现读错误,请检查网络连接状况"), new MyError(DB_ER_NET_READ_INTERRUPTED ,"网络错误,读超时,请检查网络连接状况"), new MyError(DB_ER_NET_ERROR_ON_WRITE ,"网络错误,出现写错误,请检查网络连接状况"), new MyError(DB_ER_NET_WRITE_INTERRUPTED ,"网络错误,写超时,请检查网络连接状况"), new MyError(DB_ER_DUP_ENTRY ,"字段值重复,入库失败"), new MyError(DB_ER_DUP_UNIQUE ,"字段值重复,更新记录失败"), new MyError(DB_ER_CHECK_NO_SUCH_TABLE ,"打开数据表失败"), new MyError(DB_ER_ERROR_DURING_COMMIT ,"提交事务失败"), new MyError(DB_ER_ERROR_DURING_ROLLBACK ,"回滚事务失败"), new MyError(DB_ER_TOO_MANY_USER_CONNECTIONS ,"当前用户和数据库建立的连接已到达数据库的最大连接数,请增大可用的数据库连接数或重启数据库"), new MyError(DB_ER_LOCK_WAIT_TIMEOUT ,"加锁超时"), new MyError(DB_ER_NO_PERMISSION_TO_CREATE_USER ,"当前用户没有创建用户的权限"), new MyError(DB_ER_NO_REFERENCED_ROW ,"外键约束检查失败,更新子表记录失败"), new MyError(DB_ER_ROW_IS_REFERENCED ,"外键约束检查失败,删除或修改主表记录失败"), new MyError(DB_ER_USER_LIMIT_REACHED ,"当前用户使用的资源已超过所允许的资源,请重启数据库或重启服务器"), new MyError(DB_ER_SPECIFIC_ACCESS_DENIED_ERROR ,"权限不足,您无权进行此操作"), new MyError(DB_ER_NOT_SUPPORTED_YET ,"MySQL版本过低,不具有本功能"), }; public static String getErrorInfo(int errno) { for(int i=0; i{ if(errno == errormap[i].getErrorNo()) { return errormap[i].getErrorDesc(); } } return ""; } public static void main(String[] args) { for(int i=0; i{ System.out.println(errormap[i].getErrorNo() + ":" + errormap[i].getErrorDesc()); } } }
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
上海柏雅居酒店模拍
清晨美丽的风景
梦清园的靓丽女生
妖艳的食人花(7)
且行且攝------"色"影大連
【做股票的朋友看过来-华尔街的铜牛】
端午节后闲逛
捐款赈灾吴川行 花絮
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有