Quartz.NET-2.3.3 各种 数据库配置 类别大全

本文深入探讨了如何将Quartz.NET-2.3.3与MongoDB数据库结合使用,提供了详细的配置示例和步骤说明,包括SqlServer、PostgreNpgsql-10、Oracle、MySQL、SQLite等数据库的配置,帮助开发者轻松实现任务调度与数据存储的高效整合。

下面是Quartz.NET-2.3.3 原生支持的.数据库类别
MongoDB 需要增加Quartz.NET MongoDB 类的引用.
Quartz.NET MongoDB 目前支持的 Quartz.NET 版本比较低.

 <!--SqlServer
    <add key="quartz.dataSource.myDS.connectionString" value="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Quartz.NET.mdf;Initial Catalog=SportsStore;Integrated Security=True" />
    <add key="quartz.dataSource.myDS.connectionString" value="data source=MONOMATRIX\SQLEXPRESS;initial catalog=quartznet;user id=sa;password=*****;multipleactiveresultsets=True;" />
    <add key="quartz.dataSource.myDS.provider" value="SqlServer-20" />-->

    <add key="quartz.dataSource.myDS.connectionString" value="data source=.\SQLEXPRESS;initial catalog=quartznet;user id=sa;password=*****;multipleactiveresultsets=True;" />
    <add key="quartz.dataSource.myDS.provider" value="SqlServer-20" />
    <!--<add key="quartz.dataSource.myDS.provider" value="SqlServer-351" /> SQLServerCe 这好几种,不知道为啥,应该是对应不同的数据库.
    <add key="quartz.dataSource.myDS.provider" value="SqlServer-352" />     SQLServerCe
    <add key="quartz.dataSource.myDS.provider" value="SqlServer-400" />     SQLServerCe -->

    <!--SQLServerCe 
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.SqlServerDelegate, Quartz" />
    <add key="quartz.dataSource.myDS.provider" value="SqlServerCe-351" />-->

    <!--Postgre Npgsql-10
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.PostgreSQLDelegate, Quartz" />
    <add key="quartz.dataSource.myDS.provider" value="Npgsql-10" />-->

    <!--其它数据库配置见此类
    Oracle
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.OracleDelegate, Quartz"/>
    <add key="quartz.dataSource.myDS.provider" value="OracleODPManaged-1123-40"  />

    Oracle
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.OracleDelegate, Quartz"/>
    <add key="quartz.dataSource.myDS.provider" value="OracleODPManaged-1211-40" />


    Oracle 
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.OracleDelegate, Quartz"/>
    <add key="quartz.dataSource.myDS.provider" value="OracleODP-20" />


    MySQL
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.MySQLDelegate, Quartz"/>
    <add key="quartz.dataSource.myDS.provider" value="MySql-50" />


    MySQL
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.MySQLDelegate, Quartz"/>
    <add key="quartz.dataSource.myDS.provider" value="MySql-51" />


    MySQL
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.MySQLDelegate, Quartz"/>
    <add key="quartz.dataSource.myDS.provider" value="MySql-65" />

    MySQL
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.MySQLDelegate, Quartz"/>
    <add key="quartz.dataSource.myDS.provider" value="MySql-10" />


    MySQL
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.MySQLDelegate, Quartz"/>
    <add key="quartz.dataSource.myDS.provider" value="MySql-109" />

    SQLite
    <add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.SQLiteDelegate, Quartz"/>
    <add key="quartz.dataSource.myDS.provider" value="SQLite-10" />
    -->
mvn install:install-file \ -Dfile=/path/to/actual/ruoyi-framework-3.8.9.jar \ -DgroupId=com.ruoyi \ -DartifactId=ruoyi-framework \ -Dversion=3.8.9 \ -Dpackaging=jar 出现报错: [ERROR] [ERROR] Some problems were encountered while processing the POMs: [WARNING] &#39;parent.relativePath&#39; of POM io.github.bovane:ruoyi-framework:3.8.0 (/home/xitongguanliyuan/ruoyi/RuoYi-flowable/ruoyi-admin/pom.xml) points at com.ruoyi:ruoyi instead of io.github.bovane:ruoyi, please verify your project structure @ line 5, column 13 [FATAL] &#39;dependencies.dependency.[io.github.bovane:ruoyi-framework:3.8.0]&#39; for io.github.bovane:ruoyi-framework:3.8.0 is referencing itself. @ line 33, column 21 @ [ERROR] The build could not read 1 project -> [Help 1] [ERROR] [ERROR] The project io.github.bovane:ruoyi-framework:3.8.0 (/home/xitongguanliyuan/ruoyi/RuoYi-flowable/ruoyi-admin/pom.xml) has 1 error [ERROR] &#39;dependencies.dependency.[io.github.bovane:ruoyi-framework:3.8.0]&#39; for io.github.bovane:ruoyi-framework:3.8.0 is referencing itself. @ line 33, column 21 [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException xitongguanliyuan@fcsh:~/ruoyi/RuoYi-flowable/ruoyi-admin$ sudo apt update Hit:1 http://ftp.sjtu.edu.cn/ubuntu noble InRelease Hit:2 http://ftp.sjtu.edu.cn/ubuntu noble-updates InRelease Hit:3 http://ftp.sjtu.edu.cn/ubuntu noble-backports InRelease Hit:4 http://repo.mysql.com/apt/ubuntu noble InRelease Hit:5 http://security.ubuntu.com/ubuntu noble-security InRelease Ign:6 https://packages.adoptium.net/artifactory/ubuntu noble InRelease Err:7 https://packages.adoptium.net/artifactory/ubuntu noble Release 404 Not Found [IP: 104.18.21.66 443] Hit:8 https://deb.nodesource.com/node_18.x nodistro InRelease Reading package lists... Done E: The repository &#39;https://packages.adoptium.net/artifactory/ubuntu noble Release&#39; does not have a Release file. N: Updating from such a repository can&#39;t be done securely, and is therefore disabled by default. N: See apt-secure(8) manpage for repository creation and user configuration details. xitongguanliyuan@fcsh:~/ruoyi/RuoYi-flowable/ruoyi-admin$ mvn -v Apache Maven 3.9.11 (3e54c93a704957b63ee3494413a2b544fd3d825b) Maven home: /opt/maven Java version: 1.8.0_462, vendor: Private Build, runtime: /usr/lib/jvm/java-8-openjdk-amd64/jre Default locale: en_US, platform encoding: UTF-8 OS name: "linux", version: "6.8.0-85-generic", arch: "amd64", family: "unix" 修正父模块的版本为3.8.0,子模块满足官网库中版本,父模块不满足 子模块代码如下: xitongguanliyuan@fcsh:~/ruoyi/RuoYi-flowable/ruoyi-admin$ cat pom.xml <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <parent> <artifactId>ruoyi</artifactId> <groupId>io.github.bovane</groupId> <version>3.8.0</version> </parent> <modelVersion>4.0.0</modelVersion> <artifactId>ruoyi-framework</artifactId> <version>3.8.0</version> <description> framework框架核心 </description> <dependencies> <!-- SpringBoot Web容器 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!-- SpringBoot 拦截器 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-aop</artifactId> </dependency> <dependency> <groupId>io.github.bovane</groupId> <artifactId>ruoyi-framework</artifactId> <version>3.8.0</version> </dependency> <!-- 阿里数据库连接池 --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> </dependency> <!-- 验证码 --> <dependency> <groupId>com.github.penggle</groupId> <artifactId>kaptcha</artifactId> <exclusions> <exclusion> <artifactId>javax.servlet-api</artifactId> <groupId>javax.servlet</groupId> </exclusion> </exclusions> </dependency> <!-- 获取系统信息 --> <dependency> <groupId>com.github.oshi</groupId> <artifactId>oshi-core</artifactId> </dependency> <!-- 系统模块--> <dependency> <groupId>io.github.bovane</groupId> <artifactId>ruoyi-system</artifactId> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <version>2.5.15</version> <configuration> <fork>true</fork> <!-- 如果没有该配置,devtools不会生效 --> </configuration> <executions> <execution> <goals> <goal>repackage</goal> </goals> </execution> </executions> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-war-plugin</artifactId> <version>3.1.0</version> <configuration> <failOnMissingWebXml>false</failOnMissingWebXml> <warName>${project.artifactId}</warName> </configuration> </plugin> </plugins> <finalName>${project.artifactId}</finalName> </build> <!-- 正确的仓库配置 --> <repositories> <!-- 阿里云公共仓库 --> <repository> <id>aliyun-public</id> <name>Aliyun Public Repository</name> <url>https://maven.aliyun.com/repository/public</url> <layout>default</layout> <snapshots> <enabled>true</enabled> <updatePolicy>always</updatePolicy> </snapshots> </repository> <!-- 阿里云中央仓库镜像 --> <repository> <id>aliyun-central</id> <name>Aliyun Central Repository</name> <url>https://maven.aliyun.com/repository/central</url> <layout>default</layout> <snapshots> <enabled>false</enabled> </snapshots> </repository> </repositories> <pluginRepositories> <!-- 插件仓库配置 --> <pluginRepository> <id>aliyun-plugin</id> <name>Aliyun Plugin Repository</name> <url>https://maven.aliyun.com/repository/public</url> <layout>default</layout> <snapshots> <enabled>true</enabled> <updatePolicy>always</updatePolicy> </snapshots> </pluginRepository> </pluginRepositories> </project> 父模块代码如下: xitongguanliyuan@fcsh:~/ruoyi/RuoYi-flowable$ cat pom.xml <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.ruoyi</groupId> <artifactId>ruoyi</artifactId> <version>3.8.9</version> <name>ruoyi</name> <url>http://www.ruoyi.vip</url> <description>若依管理系统</description> <properties> <ruoyi.version>3.8.9</ruoyi.version> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding> <java.version>1.8</java.version> <maven-jar-plugin.version>3.1.1</maven-jar-plugin.version> <spring-boot.version>2.5.15</spring-boot.version> <druid.version>1.2.23</druid.version> <bitwalker.version>1.21</bitwalker.version> <swagger.version>3.0.0</swagger.version> <kaptcha.version>2.3.3</kaptcha.version> <pagehelper.boot.version>1.4.7</pagehelper.boot.version> <fastjson.version>2.0.53</fastjson.version> <oshi.version>6.6.5</oshi.version> <commons.io.version>2.13.0</commons.io.version> <poi.version>4.1.2</poi.version> <velocity.version>2.3</velocity.version> <jwt.version>0.9.1</jwt.version> <!-- override dependency version --> <tomcat.version>9.0.102</tomcat.version> <logback.version>1.2.13</logback.version> <spring-security.version>5.7.12</spring-security.version> <spring-framework.version>5.3.39</spring-framework.version> <flowable.version>6.8.0</flowable.version> </properties> <!-- 依赖声明 --> <dependencyManagement> <dependencies> <!-- 覆盖SpringFramework的依赖配置--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-framework-bom</artifactId> <version>${spring-framework.version}</version> <type>pom</type> <scope>import</scope> </dependency> <!-- 覆盖SpringSecurity的依赖配置--> <dependency> <groupId>org.springframework.security</groupId> <artifactId>spring-security-bom</artifactId> <version>${spring-security.version}</version> <type>pom</type> <scope>import</scope> </dependency> <!-- SpringBoot的依赖配置--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-dependencies</artifactId> <version>${spring-boot.version}</version> <type>pom</type> <scope>import</scope> </dependency> <!-- 覆盖logback的依赖配置--> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-core</artifactId> <version>${logback.version}</version> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>${logback.version}</version> </dependency> <!-- 覆盖tomcat的依赖配置--> <dependency> <groupId>org.apache.tomcat.embed</groupId> <artifactId>tomcat-embed-core</artifactId> <version>${tomcat.version}</version> </dependency> <dependency> <groupId>org.apache.tomcat.embed</groupId> <artifactId>tomcat-embed-el</artifactId> <version>${tomcat.version}</version> </dependency> <dependency> <groupId>org.apache.tomcat.embed</groupId> <artifactId>tomcat-embed-websocket</artifactId> <version>${tomcat.version}</version> </dependency> <!-- 阿里数据库连接池 --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>${druid.version}</version> </dependency> <!-- 解析客户端操作系统、浏览器等 --> <dependency> <groupId>eu.bitwalker</groupId> <artifactId>UserAgentUtils</artifactId> <version>${bitwalker.version}</version> </dependency> <!-- pagehelper 分页插件 --> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>${pagehelper.boot.version}</version> </dependency> <!-- 获取系统信息 --> <dependency> <groupId>com.github.oshi</groupId> <artifactId>oshi-core</artifactId> <version>${oshi.version}</version> </dependency> <!-- Swagger3依赖 --> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-boot-starter</artifactId> <version>${swagger.version}</version> <exclusions> <exclusion> <groupId>io.swagger</groupId> <artifactId>swagger-models</artifactId> </exclusion> </exclusions> </dependency> <!-- io常用工具类 --> <dependency> <groupId>commons-io</groupId> <artifactId>commons-io</artifactId> <version>${commons.io.version}</version> </dependency> <!-- excel工具 --> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>${poi.version}</version> </dependency> <!-- velocity代码生成使用模板 --> <dependency> <groupId>org.apache.velocity</groupId> <artifactId>velocity-engine-core</artifactId> <version>${velocity.version}</version> </dependency> <!-- 阿里JSON解析器 --> <dependency> <groupId>com.alibaba.fastjson2</groupId> <artifactId>fastjson2</artifactId> <version>${fastjson.version}</version> </dependency> <!-- Token生成与解析--> <dependency> <groupId>io.jsonwebtoken</groupId> <artifactId>jjwt</artifactId> <version>${jwt.version}</version> </dependency> <!-- 验证码 --> <dependency> <groupId>pro.fessional</groupId> <artifactId>kaptcha</artifactId> <version>${kaptcha.version}</version> </dependency> <!-- 定时任务--> <dependency> <groupId>com.ruoyi</groupId> <artifactId>ruoyi-quartz</artifactId> <version>${ruoyi.version}</version> </dependency> <!-- 代码生成--> <dependency> <groupId>com.ruoyi</groupId> <artifactId>ruoyi-generator</artifactId> <version>${ruoyi.version}</version> </dependency> <!-- 核心模块--> <dependency> <groupId>com.ruoyi</groupId> <artifactId>ruoyi-framework</artifactId> <version>${ruoyi.version}</version> </dependency> <!-- 系统模块--> <dependency> <groupId>com.ruoyi</groupId> <artifactId>ruoyi-system</artifactId> <version>${ruoyi.version}</version> </dependency> <!-- 通用工具--> <dependency> <groupId>com.ruoyi</groupId> <artifactId>ruoyi-common</artifactId> <version>${ruoyi.version}</version> </dependency> <dependency> <groupId>com.ruoyi</groupId> <artifactId>ruoyi-flowable</artifactId> <version>${ruoyi.version}</version> </dependency> <dependency> <groupId>org.flowable</groupId> <artifactId>flowable-spring-boot-starter</artifactId> <version>${flowable.version}</version> </dependency> <dependency> <groupId>io.swagger</groupId> <artifactId>swagger-annotations</artifactId> <version>1.5.21</version> <scope>compile</scope> </dependency> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.4.0</version> </dependency> </dependencies> </dependencyManagement> <modules> <module>ruoyi-admin</module> <module>ruoyi-framework</module> <module>ruoyi-system</module> <module>ruoyi-quartz</module> <module>ruoyi-generator</module> <module>ruoyi-common</module> <module>ruoyi-flowable</module> </modules> <packaging>pom</packaging> <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>3.1</version> <configuration> <source>${java.version}</source> <target>${java.version}</target> <encoding>${project.build.sourceEncoding}</encoding> </configuration> </plugin> </plugins> </build> <repositories> <repository> <id>public</id> <name>aliyun nexus</name> <url>https://maven.aliyun.com/repository/public</url> <releases> <enabled>true</enabled> </releases> </repository> </repositories> <pluginRepositories> <pluginRepository> <id>public</id> <name>aliyun nexus</name> <url>https://maven.aliyun.com/repository/public</url> <releases> <enabled>true</enabled> </releases> <snapshots> <enabled>false</enabled> </snapshots> </pluginRepository> </pluginRepositories> </project>
最新发布
10-17
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值