ADO.NET与Quartz.NET [英] ADO.NET with 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 :)

这篇关于ADO.NET与Quartz.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！