ResultLogCleaner meets an unexpected exception,
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.alibaba.druid.sql.parser.EOFParserException: EOF
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: delete from t_case_changelog where cVersion = ? and caseNo in
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.alibaba.druid.sql.parser.EOFParserException: EOF
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.alibaba.druid.sql.parser.EOFParserException: EOF
报错详情如上,请问有人遇到过类似的错误吗,可能的造成原因又是什么呢。
if(!CollectionUtils.isEmpty(casesNotExisted))
{
logger.info("current cVersion:" + cVersion);
// 分批处理,100为标准
int numberOfHundred = casesNotExisted.size() / 100;
List<String> tempCaseNotExisted;
for(int i = 0;i < numberOfHundred;i++)
{
tempCaseNotExisted = casesNotExisted.subList(i * 100, (i + 1) * 100);
count += caseLogDao.deleteCaseNotExisted(tableName, tempCaseNotExisted, cVersion);
logger.info("end to delete " + (i + 1) + " hundred cases");
}
tempCaseNotExisted = casesNotExisted.subList(numberOfHundred * 100, casesNotExisted.size());
if(!CollectionUtils.isEmpty(tempCaseNotExisted))
{
logger.info(tempCaseNotExisted.size() + " cases will be deleted at last.");
count += caseLogDao.deleteCaseNotExisted(tableName, tempCaseNotExisted, cVersion);
}
logger.info(count + " records has been deleted.");
}
根据错误日志,出错应该在for循环里面