Hi,
I am trying to use the Quartz plugin for Grails to schedule a job in a web app I am working on. Using the RAMstore worked fine, but I need the job to persist in our SQLServer database, which has caused problems...
I have changed the jdbcStore variable in QuartzConfig.groovy to true, set def volatility = false in the job file, and used the SQLServer code to generate the required tables in the database, but keep getting an error:
org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]
Have an idea it might be something to do with the quartz plugin not being configured for a SQLServer database, but haven't found much on the web about it(mostly the full java implementation of quartz rather than grails), and experimenting with config files hasn't helped.
Does anyone know how to get this working? And which of the various Quartz config files grails actually uses?
Thanks for your help