Problems configuring StdAdoDelegate

[benkaboo]

Hi Folks,

I've been trawling this message board and have seen lots of people who
seem to have successfully configured quartz.net with sqlServer
2000/05, but for the life of me I can't seem to get past this tricky
problem.

I've read the tutorials, I've trawled the groups, but when I run the
first example from the lastest RC3 (configured to use the ADO jobstore
instead I get an error dump (included below).

The crux of it seems to be

"Quartz.Impl.AdoJobStore.StdAdoDelegate, Quartz' could not be
instantiated. ---> System.ArgumentException: Cannot instantiate type
which has no empty constructor"

What am I missing ?

If someone could post an example .config file of a successful
installation that would be great (just blank out the passwords and
server names :-)

Or if you can immediatly see my folly, please feel free to point out
where I've gone wrong.

Thank you for your consideration, I'm hoping this post helps someone
else out in the future as well :-)

Select example to run:
[1] Example1 SimpleExample
[2] Example2 SimpleTriggerExample
[3] Example3 CronTriggerExample
[4] Example4 JobStateExample
[5] Example5 MisfireExample
[6] Example6 JobExceptionExample
[7] Example7 InterruptExample
[8] Example8 CalendarExample
[9] Example9 ListenerExample
[10] Example10 PlugInExample
[11] Example11 LoadExample
[12] Example12 RemoteServerExample
[13] Example12 RemoteClientExample
[14] Example13 ClusterExample
[15] Example14 PriorityExample
[16] example15 XmlConfigurationExample

> 1
16:31:28:125 [INFO] Quartz.Examples.Example1.SimpleExample - -------
Initializi
ng ----------------------
16:31:28:172 [INFO] Quartz.Util.DBConnectionManager - Registering
datasource 'm
yDS' with db provider: 'Quartz.Impl.AdoJobStore.Common.DbProvider'
Error running example: JobStore of type
'Quartz.Impl.AdoJobStore.StdAdoDelegate,
Quartz' could not be instantiated.
Quartz.SchedulerException: JobStore of type
'Quartz.Impl.AdoJobStore.StdAdoDeleg
ate, Quartz' could not be instantiated. ---> System.ArgumentException:
Cannot in
stantiate type which has no empty constructor
Parameter name: StdAdoDelegate
at Quartz.Util.ObjectUtils.InstantiateType(Type t) in C:\Documents
and Settin
gs\bmaslen\Desktop\Quartz.NET-1.0-RC3\src\Quartz\Util
\ObjectUtils.cs:line 117
at Quartz.Impl.StdSchedulerFactory.Instantiate() in C:\Documents
and Settings
\bmaslen\Desktop\Quartz.NET-1.0-RC3\src\Quartz\Impl
\StdSchedulerFactory.cs:line
573
--- End of inner exception stack trace ---
at Quartz.Impl.StdSchedulerFactory.Instantiate() in C:\Documents
and Settings
\bmaslen\Desktop\Quartz.NET-1.0-RC3\src\Quartz\Impl
\StdSchedulerFactory.cs:line
580
at Quartz.Impl.StdSchedulerFactory.GetScheduler() in C:\Documents
and Setting
s\bmaslen\Desktop\Quartz.NET-1.0-RC3\src\Quartz\Impl
\StdSchedulerFactory.cs:line
1022
at Quartz.Examples.Example1.SimpleExample.Run() in C:\Documents and
Settings\
bmaslen\Desktop\Quartz.NET-1.0-RC3\src\Quartz.Examples
\example1\SimpleExample.cs
:line 51
at Quartz.Examples.ConsoleMain.Main(String[] args) in C:\Documents
and Settin
gs\bmaslen\Desktop\Quartz.NET-1.0-RC3\src\Quartz.Examples
\ConsoleMain.cs:line 49
[See nested exception: System.ArgumentException: Cannot instantiate
type which
has no empty constructor
Parameter name: StdAdoDelegate
at Quartz.Util.ObjectUtils.InstantiateType(Type t) in C:\Documents
and Settin
gs\bmaslen\Desktop\Quartz.NET-1.0-RC3\src\Quartz\Util
\ObjectUtils.cs:line 117
at Quartz.Impl.StdSchedulerFactory.Instantiate() in C:\Documents
and Settings
\bmaslen\Desktop\Quartz.NET-1.0-RC3\src\Quartz\Impl
\StdSchedulerFactory.cs:line
573]

[Marko Lahma]

Hi,

Seems that you're trying to instantiate ADO.NET delegate as job store.
The relevant correct keys and values for your case probably are:

properties["quartz.jobStore.type"] =
"Quartz.Impl.AdoJobStore.JobStoreTX, Quartz";
properties["quartz.jobStore.dataSource"] = "default";
properties["quartz.jobStore.lockHandler.type"] =
"Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz";
properties["quartz.dataSource.default.connectionString"] =
"Server=(local);Database=quartz;Trusted_Connection=True;";
properties["quartz.dataSource.default.provider"] = "SqlServer-20";

You need to change connection string of course.

Hope this helps,

-Marko

[benkaboo]

Thank you very much this has resolved my issue.

I've since re-examined the docs/tutorials and started to glimpse what
I was missing.

Thanks again for being so patient and helpful :-)

On Sep 19, 5:25 pm, "Marko Lahma" <marko.la...@gmail.com> wrote:
> Hi,
>
> Seems that you're trying to instantiate ADO.NET delegate as job store.
> The relevant correct keys and values for your case probably are:
>
> properties["quartz.jobStore.type"] =
> "Quartz.Impl.AdoJobStore.JobStoreTX, Quartz";
> properties["quartz.jobStore.dataSource"] = "default";
> properties["quartz.jobStore.lockHandler.type"] =
> "Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz";
> properties["quartz.dataSource.default.connectionString"] =
> "Server=(local);Database=quartz;Trusted_Connection=True;";
> properties["quartz.dataSource.default.provider"] = "SqlServer-20";
>
> You need to change connection string of course.
>
> Hope this helps,
>
> -Marko
>