通过Adobe JobStore存储作业面临的问题

Question

我已从AdoJobStore成功连接到Oracle DB。但是当我尝试添加一个作业时，我得到了以下异常。

异常源：Quartz异常方法：Void StoreJob（Quartz.Impl.AdoJobStore.ConnectionAndTransactionHolder，Quartz.IJobDetail，布尔值）异常堆栈跟踪：位于Quartz。Impl。阿多乔布商店。Jobstore支持。c:\Work\OpenSource\Quartz中的StoreJob（ConnectionAndTransactionHolder conn，IJobDetail newJob，Boolean replaceExisting）。NET\quartznet\src\Quartz\Impl\AdoJobStore\jobstore支持。cs:Quartz的922线。Impl。阿多乔布商店。Jobstore支持。

下面是我安排作业的代码。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Quartz;
using Quartz.Impl;
using System.IO;

namespace TestScheduling
{
    class TestScheduleJob : ITaskScheduler
    {
        IScheduler sched;
        public void Run()
        {
            try
            {
                JobDataMap jobdata = new JobDataMap();
                jobdata.Add("mtid", "value");
                IJobDetail job = JobBuilder.Create<TestJob>().WithIdentity("job1", "group1").UsingJobData(jobdata).RequestRecovery(true).Build();
                DateTimeOffset dt = new DateTimeOffset(DateTime.Now.AddSeconds(10));
                ISimpleTrigger trig = (ISimpleTrigger)TriggerBuilder.Create().StartAt(dt).WithSimpleSchedule(x => x.WithIntervalInSeconds(10).WithRepeatCount(5)).Build();
                ISchedulerFactory sf = new StdSchedulerFactory();
                sched = sf.GetScheduler();
                sched.ScheduleJob(job, trig);
                sched.Start();
            }
            catch (Exception e)
            {
                StreamWriter streamWriter = new StreamWriter(new FileStream("C:\\test_schedule_job_error.txt", FileMode.Append));
                String exceptionEntry = "Exception Source:\n" + e.Source + "\n" + "Exception Method:\n" + e.TargetSite + "\n" + "Exception StackTrace:\n" + e.StackTrace + "\n" + "Exception Message:\n" + e.Message;
                streamWriter.WriteLine(exceptionEntry);
                streamWriter.Close();
                throw e;
            }
            finally
            {
            }
        }
        public void Stop()
        {
            if (sched != null)
            {
                sched.Shutdown();
            }
        }
    }
}

请帮忙！！！

Answer 1

您应该使用Oracle委托而不是StdAdobe委托。在配置中使用

properties["quartz.jobStore.driverDelegateType"] = "Quartz.Impl.AdoJobStore.OracleDelegate, Quartz";