error：for SQL []; SQL state [null]; error code [0]-优快云博客

本文链接：https://blog.youkuaiyun.com/iteye_1712/article/details/82520941

本文介绍了一种在使用Spring框架结合Quartz实现定时任务时出现的异常情况及其解决办法。异常出现在尝试将null值赋给int类型的字段时。通过调整字段类型为Integer，成功解决了该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'autoHistorySuperviseSubmitForwardOrAssignIssueLog' on target class [class com.tianque.job.realization.AutoSuperviseRedCardTask] failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in sqlmaps/issueLogNew.xml.
--- The error occurred while applying a result map.
--- Check the issueLogNew.issueLogResult.
--- The error happened while setting a property on the result object.
--- Cause: com.ibatis.common.beans.ProbeException: Could not set property 'timeLimit' to value 'null' for com.tianque.domain.IssueLogNew. Cause: java.lang.IllegalArgumentException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmaps/issueLogNew.xml.
--- The error occurred while applying a result map.
--- Check the issueLogNew.issueLogResult.
--- The error happened while setting a property on the result object.
………

解决方案：我的domain中timeLimit 设定为 private int timeLimit;查询的结果中timeLimit如果是null,则不能赋值给int类型的timeLime,所以把int类型改为integer即可。