quartz使用sqlserver

最新推荐文章于 2024-05-27 13:33:20 发布

战鸟

最新推荐文章于 2024-05-27 13:33:20 发布

阅读量998

点赞数

分类专栏： Java 文章标签： quartz sqlserver java

by 战鸟

本文链接：https://blog.csdn.net/qsyjrz206/article/details/111010591

版权

Java 专栏收录该内容

14 篇文章

订阅专栏

一、在maven中添加依赖

    <dependency>
      <groupId>org.quartz-scheduler</groupId>
      <artifactId>quartz</artifactId>
      <version>2.3.2</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.5</version>
    </dependency>

二、配置quartz.properties

org.quartz.scheduler.instanceName = TaichuScheduler
org.quartz.scheduler.instanceId = AUTO

org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount = 20
org.quartz.threadPool.threadPriority = 5

org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX

org.quartz.jobStore.isClustered = true
org.quartz.jobStore.clusterCheckinInterval = 15000
org.quartz.jobStore.maxMisfiresToHandleAtATime = 1
org.quartz.jobStore.txIsolationLevelSerializable = true

org.quartz.jobStore.misfireThreshold = 12000
org.quartz.jobStore.tablePrefix = QRTZ_

#specify the jobstore used
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate 
#org.quartz.jobStore.useProperties = false

org.quartz.jobStore.dataSource =quartzDB

org.quartz.dataSource.quartzDB.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
org.quartz.dataSource.quartzDB.URL=jdbc:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=testDB
org.quartz.dataSource.quartzDB.user=myuser
org.quartz.dataSource.quartzDB.password=mypwd
org.quartz.dataSource.quartzDB.maxConnections=10