Hi, all! I’ve been a Hangfire enthusiast now for about two years. During a large span of that time, I fretted a whole lot because the SQL Server storage implementation uses Entity Framework, which is not compatible with the RDBMS I had available at the time (SQL Server 2005). I decided to take a different approach and develop one that doesn’t use Entity Framework, and since I’ve had a whole lot of experience with Fluent NHibernate as an OR/M, I went through a few attempts with that.
After a few crashes-and-burns, HERE IT IS!
Nuget: https://www.nuget.org/packages/Hangfire.FluentNHibernateStorage/
Github: https://github.com/xavierjefferson/Hangfire.FluentNHibernateStorage
This version has been tested with MSSQL, MySQL, and PostgreSQL. There is provision, also, for Oracle, DB/2, and Firebird. This code was forked from the MySQL implementation developed by arnoldsgudas.
Please go ahead. Kick the tires and pass along any fitting recommendations.
First of all, I recommend to review the code side-by-side with SQL Server storage implementation, because mysql storage may contain errors on its own, which you inherit along with your own
For example, it is known to use a wrong data type for score column, which leads to precision losses, so delayed jobs miss the scheduled time.
Believe it or not, I already found that bug with the score column because when Hangfire utilizes it, it’s of type double (not float). I’m sure this thing isn’t perfect, but it’s a start. Thanks!
1 Like
Is there any news about Oracle support?
any feedback from some well tested real case?
thanks in advance
I did testing on Oracle and even got some feedback from a gentleman in Spain who put it to use with Oracle.
… I used the managed drivers for Oracle. Be sure to check the documentation as there’s specific configuration to use those.
1 Like
Nice! at this point, I ask my self what’s need for Entity Framework version
Thanks for this sample I tried using it with oracle and I am able to see jobs are running as per schedule in sample code but I see many exceptions in log file - (0x80004005): ORA-08177: can’t serialize access for this transaction "
More information is in below link
Hello, I will be re-opening my Hangfire.Oracle extension. I posted a discussion on here regarding my findings with Hangfire and ASP.
Net. Here’s the link:
Oracle Extension