spring boot整合quartz 任务信息存放到SqlServer数据库

最新推荐文章于 2023-12-22 16:53:41 发布

置顶

qq47990166

最新推荐文章于 2023-12-22 16:53:41 发布

阅读量657

点赞数

文章标签：第 1 行: 只有 DECLARE CURSOR 才允许使 spring boot整合quartz quartz整合SqlServer spring boot整合quartz数据落地到SqlSer spring boot quartz SqlServer

本文链接：https://blog.csdn.net/qq47990166/article/details/89517939

版权

本文介绍了如何将Spring Boot应用与Quartz集成，以实现任务调度，并将任务信息存储到SqlServer数据库中。首先，通过添加spring-boot-starter-quartz依赖来引入Quartz。接着，创建了一个TestTask定时任务，并在QuartzConfig中配置了JobDetail和Trigger。然后，执行SqlServer脚本创建所需的表结构。最后，调整yml配置文件，设置job-store-type为jdbc，并解决使用FOR UPDATE子句时的错误问题。

摘要由CSDN通过智能技术生成

第一步：添加依赖

<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-quartz</artifactId>
</dependency>

第二步：写定时任务
public class TestTask extends QuartzJobBean {
@Override
protected void executeInternal(JobExecutionContext jobExecutionContext) throws JobExecutionException {
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
System.out.println("TestQuartz01----" + sdf.format(new Date()));
}
}

@Configuration
public class QuartzConfig {

@Bean
public JobDetail testTask(){
return JobBuilder.newJob(TestTask.class).withIdentity("testTask").storeDurably().build();
}
@Bean
public Trigger testTestTask(){
return TriggerBuilder.newTrigger()
.forJob(testTask())
.withIdentity("testTask")
.withSchedule(CronScheduleBuilder.cronSchedule("*/5 * * * * ?"))
.build();
}
}

第三步：执行SqlServer脚本
--# thanks to George Papastamatopoulos for submitting this ... and Marko Lahma for
--# updating it.
--#
--# In your Quartz properties file, you'll need to set
--# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MSSQLDelegate
--#
--# you shouse enter your DB instance's name on the next line in place of "enter_db_name_here"
--#
--#
--# From a helpful (but anonymous) Quartz user:
--#
--# Regarding this error message:
--#
--# [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
--#
--#
--# I added "SelectMethod=cursor;" to my Connection URL in the config file.
--# It Seems to work, hopefully no side effects.
--#
--# example:
--# "jdbc:microsoft:sqlserver://dbmachine:1433;SelectMethod=cursor";
--#
--# Another user has pointed out that you will probably need to use the
--# JTDS driver
--#

USE [enter_db_name_here]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE [dbo].[QRTZ_TRIGGERS] DROP CONSTRAINT FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TAB