mybatis批量更新报错问题解决

最新推荐文章于 2024-08-16 09:30:00 发布

走码观花

最新推荐文章于 2024-08-16 09:30:00 发布

阅读量6.9k

点赞数 3

文章标签： mybatic批量更新 mybatis批量更新报错问题解决

本文链接：https://blog.csdn.net/qq_25838503/article/details/52400072

版权

在会员营销项目中遇到Mybatis批量update问题，使用foreach实现时出现异常。问题在于缺少`allowMultiQueries=true`参数，添加后才能正确执行批量更新。详细解决方案见某大神博客。

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

最近在做一个会员营销项目，其中有业务涉及到批量update问题，我用mybatic foreach实现批量update，但sql一直没问题，但是偏偏报以下奇葩问题：

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 'update `am_counpons_details`
	         SET `cd_custId` = '555' 
	         WHERE ' at line 6
### The error may involve com.smi.am.dao.AmCounponsDetailsMapper.batchUpdatePackageIdByCouponsIds-Inline
### The error occurred while setting parameters
### SQL: update `am_counpons_details`           SET `cd_custId` = ?            WHERE `cd_detailId` = ?            ;    update `am_counpons_details`           SET `cd_custId` = ?            WHERE `cd_detailId` = ?            ;
### 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 'update `am_counpons_details`
	         SET `cd_custId` = '555' 
	         WHERE ' at line 6
; bad SQL grammar []; nested exception is 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 'update `am_counpons_details`
	         SET `cd_custId` = '555' 
	         WHERE ' at line 6
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
	at org.mybatis.spring.SqlSe