com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.QRTZ_TRIGGERS' doesn't exist
来源:互联网 发布:基于分水岭的分割算法 编辑:程序博客网 时间:2024/06/07 11:43
问题:在数据库 test 数据库中明明有这张表 qrtz_triggers 还是报这个错
原因:这个错报的是在数据库 test 下面没有这个表 【QRTZ_TRIGGERS】,其实数据库中有的是 【qrtz_triggers】。区别在于一个是大写,一个是小写。默认情况下,mysql是区分大小写的,所以为了避免这种问题,就需要把 mysql 的区分大小写的属性给修改了。
解决办法:
- 用root登录,修改 /etc/my.cnf;
- 在[mysqld]节点下,加入一行: lower_case_table_names=1
- 重启MySQL即可;
0 0
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.QRTZ_TRIGGERS' doesn't exist
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hibernate.id_gen' doesn't exist
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bbs2011._catgory' doesn't exist
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table doesn't exist解决方案
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException Table 'xinghe.base_class' doesn't exist
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'itcastoa.user' doesn't exist
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hibernate.person' doesn't exist
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hibernate1.user' doesn't exist
- 异常:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.all_sequences' doesn't exi
- hibernate异常com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'test.user' doesn't
- openfire用户整合 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'xxx.xxx' doesn
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- 异常:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- com.mysql.jdbc.exceptions.MySQLyntaxErrorException:Table'mldn.huiyuan' doesn't exist
- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION xxxx.$ does not exist
- mycat+mysql 报错com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: partition table, insert mus
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Not unique table/alias: 'e'
- 聚合口配置mode lacp-dynamic
- eclispe的resource is out sync with file system报错
- 【转载】yalmip + lpsolve + matlab 求解混合整数线性规划问题(MIP/MILP)
- error: stray ‘\200’ in program解决方法
- ubuntu出现有线已连接却无法上网的解决方法(ubuntu连不上网)
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.QRTZ_TRIGGERS' doesn't exist
- 进程通信之信号量限制共享内存
- JAVA异常架构图及面试题、及其断言
- angularJS directive详解
- cocoapods 安装更新 Operation not permitted - /usr/bin/xcodeproj Operation not permitted - /usr/bin/upda
- 自适应网页设计
- Spring MVC 异步处理请求,提高程序性能
- 博弈论(巴什博奕,威佐夫博弈,尼姆博弈,斐波那契博弈)
- 白盒测试和黑盒测试