com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'XXX' doesn't exist

最新推荐文章于 2023-09-12 13:50:42 发布

BugEveryday

最新推荐文章于 2023-09-12 13:50:42 发布

阅读量7.5k

点赞数 7

分类专栏：报错

本文链接：https://blog.csdn.net/BugEveryday/article/details/84790109

版权

报错专栏收录该内容

13 篇文章 1 订阅

订阅专栏

org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'atcrowdfunding.t_usernum' doesn't exist
### The error may exist in URL [jar:file:/E:/Yang/Desktop/select(1)/atcrowdfunding/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/Atcrowdfunding-main/WEB-INF/lib/Atcrowdfunding-manager-impl-0.0.1-SNAPSHOT.jar!/mybatis/UsernumMapper.xml]
### The error may involve com.hahah.atcrowdfunding.manager.dao.UsernumMapper.selectUsernumByDate-Inline
### The error occurred while setting parameters
### SQL: select id, usernum, time     from t_usernum     where time = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'atcrowdfunding.t_usernum' doesn't exist
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'atcrowdfunding.t_usernum' doesn't exist

异常的原因有很多，其他博客有说明，主要是说表名的大小写可能有问题

我这里再提供一个错误的原因，jdbc.config配置文件是从其他项目拷贝过来的，忘了改数据库了o(╥﹏╥)o脑子瓦特了，