程序在linux服务器上报Mysql表不存在的问题
来源:互联网 发布:淘宝店品牌授权怎么弄 编辑:程序博客网 时间:2024/06/05 03:45
程序中报错内容:
--- 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.CodeDaoImpl.selectFromTbCode(CodeDaoImpl.java:65)
at com.xxxx.yyyyy.tableManager.code.service.CodeServiceImpl.selectFromTbCode(CodeServiceImpl.java:38)
at com.xxxx.yyyyy.content.action.AppTimeAction.init(AppTimeAction.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.hipikids.filter.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:26)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.cs.arp.core.utils.UserSessionFilter.doFilter(UserSessionFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Table 'eshop.TB_CODE' doesn't exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:794)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
... 46 more
且数据库存在该表。
原因:mysql linux环境下区分表名的大小写
解决方法:
在/etc/mysql/my.conf中的[mysqld]下面加上lower_case_table_names=1这句(1表示不区分大小写,0区分大小写),保存重新启动mysql。
- 程序在linux服务器上报Mysql表不存在的问题
- soapui 在linux服务器上报错解决方法
- OracleDatabase安装在Linux上报错pdksh的问题
- OracleDatabase安装在Linux上报错pdksh的问题
- 项目在总是报mysql表不存在的问题
- RMI 程序能在 Windows 上运行,却在 Linux 上报错的一个原因
- mySQL放在linux服务器 .NET程序放在windows服务器引起的错误
- 使用redis 编程C/S程序时候 在WIN SERVER2008 服务器机器上报错 CLR20r3 的错误
- asp在本地正常,在服务器上报无法识别的属性“targetFramework”,我改了版本显示文件不存在404,从微软官网下载.net包就正常了
- mysql数据库中的表不存在,可以查看的问题
- iscsi发起程序实例不存在的问题
- thinkphp做的项目在Linux服务器上运行,报错“模板不存在”
- Linux socket 获取温度上报服务器
- excel导出的功能发布到服务器上报错问题,终于解决了!!
- 搭建项目的MySql问题 table不存在的问题
- 关于文件转换代码和openoffice服务在不同的linux上报错conversion failed: could not load input document的问题
- 解决启动MySQLAdministrator.exe出现服务器配置文件不存在的问题
- Android程序Crash时的异常上报
- SQL SERVER 2005 安全设置
- flex ColumnChart的横坐标标签45度要点及注意事项
- Struts2中iterator标签遍历map总结
- TEST
- JVM内存管理:深入Java内存区域与OOM
- 程序在linux服务器上报Mysql表不存在的问题
- 多校联合第七场1003Swordsman(判断简单多边形是否是轴对称图形)
- SQL中的UNION语句(学过的又忘记了,摘下来记着)
- Windows系统技巧
- sql之statement
- android-ContentResolver
- oracle导入数据库
- 使用大纲模式编辑论文标题的秘诀-花1小时学习,未来省100小时!
- testset