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

最新推荐文章于 2026-06-15 14:04:22 发布

原创最新推荐文章于 2026-06-15 14:04:22 发布 · 4.5k 阅读

本内容遵循CC 4.0 BY-SA版权协议

本文深入探讨了如何将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" />
    -->