程序在linux服务器上报Mysql表不存在的问题

最新推荐文章于 2022-09-26 08:52:19 发布

lzz313

最新推荐文章于 2022-09-26 08:52:19 发布

阅读量2.7k

点赞数

分类专栏： Java技术数据库技术文章标签： mysql linux 服务器 table query 数据库

本文链接：https://blog.csdn.net/lzz313/article/details/6657080

版权

程序运行时出现错误，提示'TB_CODE'表不存在，实际数据库中存在该表。问题源于Linux环境下MySQL默认区分表名大小写。解决办法是在/etc/mysql/my.conf配置文件的[mysqld]部分添加'lower_case_table_names=1'，设置为不区分大小写，然后重启MySQL服务。

摘要由CSDN通过智能技术生成

程序中报错内容：

--- The error occurred while applying a parameter map.
--- Check the selectTbCode-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Table 'eshop.TB_CODE' doesn't exist
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the selectTbCode-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Table 'xxx.TB_XXX' doesn't exist
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
at com.xxxx.yyyyy.tableManager.code.dao.CodeD