[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

本文探讨了在使用Spring框架进行数据库操作时遇到的BadSqlGrammarException异常,具体表现为SQL语法错误,涉及AuthenTransferMapper的insert方法。通过分析异常堆栈信息,明确了错误发生在设置参数阶段。
1557

被折叠的 条评论
为什么被折叠?



