-1

I have .net 4.5.2 application with quartz.net 3.0.4. I am trying to use adojobstore with mysql as database My configuration is

<add key="quartz.scheduler.instanceName" value="DBScheduler" />
<add key="quartz.threadPool.type" value="Quartz.Simpl.SimpleThreadPool, Quartz" />
<add key="quartz.threadPool.threadCount" value="100" />
<add key="quartz.threadPool.threadPriority" value="2" />
<add key="quartz.scheduler.dbFailureRetryInterval" value="6000000000" />
<add key="quartz.jobStore.driverDelegateType" value="Quartz.Impl.AdoJobStore.SqlServerDelegate, Quartz" />
<add key="quartz.jobStore.tablePrefix" value="QRTZ_" />
<add key="quartz.jobStore.misfireThreshold" value="600000" />
<add key="quartz.jobStore.type" value="Quartz.Impl.AdoJobStore.JobStoreTX, Quartz" />
<add key="quartz.jobStore.dataSource" value="myDS" />
<add key="quartz.dataSource.myDS.connectionString" value="Server=localhost;Port=3306;database=quartznet;Uid=root;pwd=root;allow user variables=true;CharSet=utf8;" />
<add key="quartz.dataSource.myDS.provider" value="MySql-51" />

I am always getting error Could not Initialize DataSource: myDS Inner Exception: There is no metadata information for provider 'MySql-51' Parameter name: providerName

Please help me identify the problem

I have even tried <add key="quartz.dataSource.myDS.provider" value="MySql" />

Kamran Shahid
  • 3,954
  • 5
  • 48
  • 93
  • 1
    Why this is marked negative. I am 100% sure that other might also face this problem and this post will be helpful. Stackoverflow needed to introduce a mandatory comment for negative marking. – Kamran Shahid Mar 08 '18 at 19:29

1 Answers1

2

As discussed in the GitHub issue (please indicate that you are cross-posting when asking questions), the documentation was not up to date.

Documentation has been updated to not have the version postfix for the providers. So you should replace "Mysql-51" with "MySql".

Marko Lahma
  • 6,586
  • 25
  • 29