oracle到神通Oscar,oscar数据库以及oracle数据库quartz调度方式

----oscar数据库下调度方式：org.quartz.scheduler.instanceName=DefaultQuartzScheduler org.quartz.scheduler.rmi.export=falseorg.quartz.scheduler.rmi.proxy=falseorg.quartz.scheduler.wrapJobExecutionInUserTransacti

Xi Zi

400人浏览 · 2021-04-03 08:15:05

Xi Zi · 2021-04-03 08:15:05 发布

----oscar数据库下调度方式：

org.quartz.scheduler.instanceName=DefaultQuartzScheduler org.quartz.scheduler.rmi.export=false

org.quartz.scheduler.rmi.proxy=false

org.quartz.scheduler.wrapJobExecutionInUserTransaction=false

org.quartz.threadPool.class=org.quartz.simpl.SimpleThreadPool

org.quartz.threadPool.threadCount=10

org.quartz.threadPool.threadPriority=5

org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread=true

org.quartz.jobStore.misfireThreshold=60000

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

#org.quartz.jobStore.driverDelegateClass =org.quartz.impl.jdbcjobstore.StdDriverDelegate

#org.quartz.jobStore.driverDelegateClass =org.quartz.impl.jdbcjobstore.oscar.OscarDelegate

org.quartz.jobStore.useProperties=false

org.quartz.jobStore.txIsolationLevelSerializable=true

org.quartz.jobStore.dataSource=myDS

org.quartz.jobStore.tablePrefix=QRTZ_

org.quartz.dataSource.myDS.driver = com.oscar.Driver

org.quartz.dataSource.myDS.URL = jdbc:oscar://15.13.99.16/osrdb

#org.quartz.dataSource.myDS.driver = oracle.jdbc.OracleDriver

#org.quartz.dataSource.myDS.URL = jdbc:oracle:thin:@183.56.131.74:1521:jcs

org.quartz.dataSource.myDS.user = xxx

org.quartz.dataSource.myDS.password = xxx

org.quartz.dataSource.myDS.maxConnections=10

-----oracle数据库下调度方式：

#============================================================================ # Configure Main Scheduler Properties #============================================================================ org.quartz.scheduler.instanceName = My_Quartz org.quartz.scheduler.instanceId = AUTO #============================================================================ # Configure ThreadPool #============================================================================ org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool org.quartz.threadPool.threadCount = 5 org.quartz.threadPool.threadPriority = 5 org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread = true #============================================================================ # Configure JobStore single #============================================================================ #RAM #org.quartz.jobStore.class = org.quartz.simpl.RAMJobStore #\u8FD9\u662F\u9ED8\u8BA4\u7684 #============================================================================ # Configure JobStore Cluster #============================================================================ org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.oracle.OracleDelegate #org.quartz.jobStore.driverDelegateClass=com.jh.jcs.framework.common.util.OracleDelegate org.quartz.jobStore.tablePrefix = QRTZ_ #org.quartz.jobStore.misfireThreshold = 60000 #org.quartz.jobStore.isClustered = true #org.quartz.jobStore.clusterCheckinInterval = 15000 #\u6307\u5B9A\u6570\u636E\u6E90 org.quartz.jobStore.dataSource = myDS #============================================================================ # Configure dataSource #============================================================================ #dataSource--myDS #org.quartz.dataSource.myDS.driver = com.oscar.Driver #org.quartz.dataSource.myDS.URL = jdbc:oscar://219.141.184.173/osrdb org.quartz.dataSource.myDS.driver = oracle.jdbc.OracleDriver org.quartz.dataSource.myDS.URL = jdbc:oracle:thin:@183.56.131.74:1521:jcs org.quartz.dataSource.myDS.user = xxx org.quartz.dataSource.myDS.password = xxx org.quartz.dataSource.myDS.maxConnections = 10 #cluster set org.quartz.jobStore.isClustered = true org.quartz.jobStore.clusterCheckinInterval =20000

腾讯云开发者社区

腾讯云面向开发者汇聚海量精品云计算使用和开发经验，营造开放的云计算技术生态圈。

更多推荐

Springboot+MySQL 实现从数据库获取数据展示到前端

1.运行效果效果图如下：2.创建数据库表数据库名为"springboot",数据库表名为"user"，数据库表里面放了5条数据，字段分别为：“id”，“name”，“age”，“email”。3.新建SpringBoot项目1、选择Spring Initial...

腾讯云开发者社区

数据库实验二数据库的简单查询和连接查询实验

– l）用Transact-SQL语句表示下列操作．在学生选课库中实现其数据查询操作．– ①求数学系学生的学号和姓名。select sno,sname from student where sdept='MA';– ②求选修了课程的学生学号。select distinct sno from sc;– ③求选修C1课程的学生学号和成绩，并要求对查询结果按成绩降序排列，如果成绩相同则按学号升序排列。s

腾讯云开发者社区

Spring Boot Mybatis数据库datasource多数据源配置

application.yaml文件配置spring:datasource:db1:driver-class-name: com.mysql.cj.jdbc.Driverjdbc-url: jdbc:mysql://192.168.0.1:3306/ellassay_dev?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBe