批量更新出错

最新推荐文章于 2023-05-13 16:23:08 发布

Emily呀

最新推荐文章于 2023-05-13 16:23:08 发布

阅读量811

点赞数

分类专栏： ❤♥♥项目学习

本文链接：https://blog.csdn.net/zhang18330699274/article/details/79148714

版权

❤♥♥项目学习专栏收录该内容

28 篇文章 0 订阅

订阅专栏

2018-01-24 11:14:25,472 DEBUG [org.springframework.jdbc.support.SQLErrorCodesFactory] - Looking up default SQLErrorCodes for DataSource [{
CreateTime:"2018-01-24 11:13:41",
ActiveCount:1,
PoolingCount:0,
CreateCount:1,
DestroyCount:0,
CloseCount:18,
ConnectCount:19,
Connections:[
]
}]
2018-01-24 11:14:25,477 DEBUG [org.springframework.jdbc.support.SQLErrorCodesFactory] - Database product name cached for DataSource [com.alibaba.druid.pool.DruidDataSource@bf3855e]: name is 'MySQL'
2018-01-24 11:14:25,479 DEBUG [org.springframework.jdbc.support.SQLErrorCodesFactory] - SQL error codes for 'MySQL' found
2018-01-24 11:14:25,479 DEBUG [org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator] - Translating SQLException with SQL state '42000', error code '1064', message [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 zk_resourse
set
resourse_is_push=0
where resourse_id=2
;
' at line 6]; SQL was [] for task [
### 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 zk_resourse
set
resourse_is_push=0
where resourse_id=2
;
' at line 6
### The error may involve com.bluemobi.dao.zk.ZkResourseDao.batchPush-Inline
### The error occurred while setting parameters
### SQL: update zk_resourse set resourse_is_push=? where resourse_id=? ; update zk_resourse set resourse_is_push=? where resourse_id=? ; update zk_resourse set resourse_is_push=? where resourse_id=?