批量插入,mybatis报缺失关键字

### The error may involve com.ssm.promotion.core.dao.xxxx.insertBatch-Inline
### The error occurred while setting parameters
### SQL: INSERT ALL SELECT * FROM dual
### Cause: java.sql.SQLSyntaxErrorException: ORA-00905: 缺失关键字

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00905: 缺失关键字

 

原因:批量添加的参数list集合为空

解决:在批量添加之前进行判断

posted @ 2024-05-08 11:02  tianjifei123  阅读(169)  评论(0)    收藏  举报