Springmvc+quartz Cluster +sqlserver

Exception information

Failure Obtaining DB Row Lock: line 1th: Only the DECLARE CURSOR is allowed to use the FOR UPDATE clause.

Only the DECLARE CURSOR is allowed to use the FOR UPDATE clause

Modify method

<prop key="org.quartz.jobStore.selectWithLockSQL">SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?</prop>

Cluster configuration background

quartz:1.8.4
Spring:3.0.5.release

Configuration

<bean id= "Testquartz" class= "Com.test.quartz.TestQuartz"/>
<bean id= "Timingschedulejobdetail" class= " Frameworkx.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean ">

Gzxh_fxy AUTO !--thread pool configuration--> Org.quartz.simpl.SimpleThreadPool 5 1 !--jobstore configuration--> Org.quartz.impl.jdbcjobstore.JobStoreTX !--cluster configuration--> 15000 1 " How much time!--suspend Line--> select * FROM {0}locks UPDLOCK WHERE lock_name =? Qrtz_ Note: Testquartz need to inherit serializable rewrite Methodinvokingjobdetailfactorybean reference article: Https://www.cnblogs.com/chjun2000/ archive/2012/07/22/2604129.htmlhttp://mushme.iteye.com/blog/1874370 (rewrite Methodinvokingjobdetailfactorybean)

Springmvc+quartz Cluster +sqlserver