ADO.NET与Quartz.NET

本文介绍了ADO.NET与Quartz.NET的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我使用Quartz.NET与数据库，即ADO.NET。问题是，创建我的工作的时候，他们没有被保​​存到数据库中的。我有没有配置好了吧？我使用SQL Server的防爆preSS和路径到我的数据库是克里斯\ sqlex press.Quartz.dbo'。

配置文件中的相关部分：

quartz.jobStore.type = Quartz.Impl.AdoJobStore.JobStoreTX，石英 quartz.jobStore.dataSource =默认 quartz.jobStore.table preFIX = QRTZ_ quartz.jobStore.clustered =真 quartz.jobStore.lockHandler.type = Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore，石英 quartz.jobStore.driverDelegateType = Quartz.Impl.AdoJobStore.SqlServerDelegate，石英 quartz.dataSource.default.connectionString = 服务器=本地主机;数据库=石英; Trusted_Connection = TRUE;; quartz.dataSource.default.provider = SqlServer的-20 quartz.jobStore.useProperties =真

计划initilisation和就业增加：

ISchedulerFactory schedService =新StdSchedulerFactory（）; IScheduler sched的= schedService.GetScheduler（）; 的JobDetail的JobDetail =新的JobDetail（1，1的typeof（copyJob））; jobDetail.JobDataMap [initialPath] = initpath; jobDetail.JobDataMap [TARGETPATH​​] = TARGETPATH​​; jobDetail.JobDataMap [正则表达式] =正则表达式; CronTrigger触发=新CronTrigger（trigger1中，组1，1，1，TextBox4.Text）; sched.AddJob（的JobDetail，真正的）; 日期时间FT = sched.ScheduleJob（触发）; FT = TimeZoneInfo.ConvertTimeFromUtc（英尺，trigger.TimeZone）; 回复于（的String.Format（{0}已计划在运行：{1}，并根据前pression重复：{2}，jobDetail.FullName，ft.ToString（R）， trigger.CronEx pressionString））;

解决方案

右键，工作了的人需要帮助。我的连接字符串是错误的，我只好到C服务器的信息很难$ C $例13在Quartz.NET例子。这是一个伟大的框架：）

I'm using Quartz.NET with a database, i.e. ADO.NET. Problem is, when my jobs are created, they are not being saved to the database at all. Have I configured everything right? I am using SQL Server Express, and the path to my database is 'chris\sqlexpress.Quartz.dbo'.

Relevant parts of config file:

quartz.jobStore.type = Quartz.Impl.AdoJobStore.JobStoreTX, Quartz quartz.jobStore.dataSource = default quartz.jobStore.tablePrefix = QRTZ_ quartz.jobStore.clustered = true quartz.jobStore.lockHandler.type = Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz quartz.jobStore.driverDelegateType = Quartz.Impl.AdoJobStore.SqlServerDelegate, Quartz quartz.dataSource.default.connectionString = Server=localhost;Database=Quartz;Trusted_Connection=True;"; quartz.dataSource.default.provider = SqlServer-20 quartz.jobStore.useProperties = true

Scheduler initilisation and job addition:

ISchedulerFactory schedService = new StdSchedulerFactory(); IScheduler sched = schedService.GetScheduler(); JobDetail jobDetail = new JobDetail("1", "1", typeof(copyJob)); jobDetail.JobDataMap["initialPath"] = initpath; jobDetail.JobDataMap["targetPath"] = targetpath; jobDetail.JobDataMap["regex"] = regex; CronTrigger trigger = new CronTrigger("trigger1", "group1", "1", "1", TextBox4.Text); sched.AddJob(jobDetail, true); DateTime ft = sched.ScheduleJob(trigger); ft = TimeZoneInfo.ConvertTimeFromUtc(ft, trigger.TimeZone); Response.Write(string.Format("{0} has been scheduled to run at: {1} and repeat based on expression: {2}", jobDetail.FullName, ft.ToString("r"), trigger.CronExpressionString));

解决方案

Right, worked it out for anyone that needs help. My connection string was wrong, and I had to hard code the server information in as in Example 13 in the Quartz.NET examples. It's a great framework :)