Could not load type 'Quartz.Impl.AdoJobStore.PostgreSQLDelegate' from assembly 'Quartz'

[Jeremias Kauppinen]

I'm trying to use npgsql as db provider. I'm getting exception saying that "Could not load type 'Quartz.Impl.AdoJobStore.PostgreSQLDelegate' from assembly 'Quartz'. I have created the database and necessary tables. Any ideas why this would be happening?
Here are the exception details:
http://pastebin.com/xE7r4tzD

Here are my quartz config values
http://pastebin.com/YqcmeJbf

BR,
Jeremias

[Marko Lahma]

By the looks of it, you might still be missing the "inner inner inner"
exception that might shed some more light. There might be a problem
loading the specific version of Posgre .NET driver that Quartz has in
its meta data. This would be fixed by adding required binding
redirects to app.config.

But please take a closer look to the end (bottom) of the stack trace.
There might be a more specific error message there.

-Marko

> --
> You received this message because you are subscribed to the Google Groups
> "Quartz.NET" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to quartznet+...@googlegroups.com.
> To post to this group, send email to quar...@googlegroups.com.
> Visit this group at http://groups.google.com/group/quartznet.
> For more options, visit https://groups.google.com/d/optout.
>

[Uwe Laas]

I may be mistaken but it seems that there is no Postgres Delegate within Quartz, at least not in 2.3.3.0. Cannot find it within the source nor in the binary.

Regards
- Uwe

[Marko Lahma]

Umm.. You are right. I guess that the specialized delegate was removed
as it should no longer be needed with newer Postgre .NET drivers.

-Marko

On 1/6/16, Uwe Laas <ufh.s...@gmail.com> wrote:
> I may be mistaken but it seems that there is no Postgres Delegate within
> Quartz, at least not in 2.3.3.0. Cannot find it within the source nor in
> the binary.
>
> Regards
> - Uwe
>
> On Thursday, October 15, 2015 at 4:53:41 PM UTC+2, Marko Lahma wrote:
>>
>> By the looks of it, you might still be missing the "inner inner inner"
>> exception that might shed some more light. There might be a problem
>> loading the specific version of Posgre .NET driver that Quartz has in
>> its meta data. This would be fixed by adding required binding
>> redirects to app.config.
>>
>> But please take a closer look to the end (bottom) of the stack trace.
>> There might be a more specific error message there.
>>
>> -Marko
>>

>> On 10/15/15, Jeremias Kauppinen <jeremias....@gmail.com <javascript:>>

>> wrote:
>> > I'm trying to use npgsql as db provider. I'm getting exception saying
>> that
>> > "Could not load type 'Quartz.Impl.AdoJobStore.PostgreSQLDelegate' from
>> > assembly 'Quartz'. I have created the database and necessary tables. Any
>> >
>> > ideas why this would be happening?
>> > Here are the exception details:
>> > http://pastebin.com/xE7r4tzD
>> >
>> > Here are my quartz config values
>> > http://pastebin.com/YqcmeJbf
>> >
>> > BR,
>> > Jeremias
>> >
>> > --
>> > You received this message because you are subscribed to the Google
>> Groups
>> > "Quartz.NET" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> an

>> > email to quartznet+...@googlegroups.com <javascript:>.

>> > To post to this group, send email to quar...@googlegroups.com

>> <javascript:>.

>> > Visit this group at http://groups.google.com/group/quartznet.
>> > For more options, visit https://groups.google.com/d/optout.
>> >
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Quartz.NET" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to quartznet+...@googlegroups.com.
> To post to this group, send email to quar...@googlegroups.com.

> Visit this group at https://groups.google.com/group/quartznet.

[Uwe Laas]

So it is recommended to use the StdAdoDelegate? Maybe it would be good to update the docs then, because they say something about poor performance.
I can confirm that StdAdo works just fine with PostgreSQL and would like to point out that Quartz is just a great piece of software!

Regards
- Uwe

[Marko Lahma]

Yes it should be fine. There's no limiting of acquired triggers that
actually might hinder performance a bit with large amount of triggers
waiting to be acquired. I've created an issue about it:
https://github.com/quartznet/quartznet/issues/318 .

So for large set firing triggers using default delegate could be a
problem. It's easy to implement custom delegate if needed while
waiting for built-in support.

-Marko

On 1/6/16, Uwe Laas <ufh.s...@gmail.com> wrote:
> So it is recommended to use the StdAdoDelegate? Maybe it would be good to
> update the docs then, because they say something about poor performance.
> I can confirm that StdAdo works just fine with PostgreSQL and would like to
>
> point out that Quartz is just a great piece of software!
>
> Regards
> - Uwe
>
> Am Mittwoch, 6. Januar 2016 11:53:26 UTC+1 schrieb Marko Lahma:
>>
>> Umm.. You are right. I guess that the specialized delegate was removed
>> as it should no longer be needed with newer Postgre .NET drivers.
>>
>> -Marko
>>

[Uwe Laas]

While we're at it ...
I would like to see a store type as easy to enable as the RAM storage but persistent at the same time; something based on RaptorDB or the like.
Any chance that a contribution from my side would be accepted?

Regards
- Uwe