执行insert时候控制台打印[org/springframework/jdbc/support/sql-error-codes.xml]

xiaogc_a

于 2018-12-29 13:50:37 发布

阅读量3k

点赞数

分类专栏：异常 mybatis 文章标签：异常 mybatis insert

本文链接：https://blog.csdn.net/xiaogc_a/article/details/85337704

版权

异常同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

mybatis

3 篇文章 0 订阅

订阅专栏

[http-nio-1123-exec-4] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]

一直保存不了数据，打印的这些信息很难排查，
因为我们把异常信息catch掉了，将异常堆栈信息输出就一目了然；

org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit,offset ) VALUES( 1078860117702610944,null,916962304294,null,null,'chen001'' at line 1
### The error may involve com.xxx.xxx.dao.mapper.AuthenTransferMapper.insert-Inline
### The error occurred while setting parameters