quartz 数据库断连

Question

问题遇到的现象和发生背景

quartz + springmvc
定义Job

public class TestJob implements StatefulJob {
    private JobManageService jobManageService = (JobManageService) SpringContextUtil.getBean("jobManageService");
    @Override
    public void execute(JobExecutionContext context) throws JobExecutionException {
        System.out.println("--TestJob开始");

执行任务后，再执行其他的quartz相关操作

scheduler.rescheduleJob(triggerKey, trigger);

运行结果及报错内容

Failure obtaining db row lock: Connection is closed. [See nested exception: java.sql.SQLException: Connection is closed.]
    at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:158)

Answer 1

https://blog.csdn.net/weixin_46146197/article/details/124911587?spm=1001.2014.3001.5502