Error using Quartz integration SchedulerFactoryBean

[dhalbrook]

I'm getting this error trying to schedule some simple jobs using a SchedulerFactoryBean. It works correctly when I configure Quartz to use its own DataSource, but chokes when I pass the shared DataSource (which works fine for everything else).

The dataSource is a simple one:

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" depends-on="placeholderConfig">
        <property name="driverClassName">
            <value>oracle.jdbc.driver.OracleDriver</value>
        </property>
        <property name="url">
            <value>$&#123;jdbc.url&#125;</value>
        </property>
        <property name="username">
            <value>$&#123;jdbc.username&#125;</value>
        </property>
        <property name="password">
            <value>$&#123;jdbc.password&#125;</value>
        </property>
        <property name="removeAbandoned">
            <value>true</value>
        </property>
        <property name="validationQuery">
            <value>select 1 from DUAL</value>
        </property>
        <property name="maxActive">
            <value>50</value>
        </property>
    </bean>

It is also used by a LocalSessionFactoryBean and by extension an OpenSessionInViewFilter.

The error is below:

ERROR [main] [2004-09-03 16:55:52,654] [org.springframework.web.context.ContextLoader]- Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulerFactory' defined in res
ource [/WEB-INF/classes/spring-rss.xml] of ServletContext: Initialization of bean failed; nested exception is org.quartz
.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-01002: fetch out of sequence

org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-01002: fetch out of sequence
 [See nested exception: java.sql.SQLException: ORA-01002: fetch out of sequence
]
        at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.obtainLock(StdRowLockSemaphore.java:154)
        at org.quartz.impl.jdbcjobstore.JobStoreCMT.storeJob(JobStoreCMT.java:310)
        at org.quartz.core.QuartzScheduler.addJob(QuartzScheduler.java:646)
        at org.quartz.impl.StdScheduler.addJob(StdScheduler.java:244)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.addJobToScheduler(SchedulerFactoryBean.java:524)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.registerJobsAndTriggers(SchedulerFactoryBean.java:
486)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:404)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowi
reCapableBeanFactory.java:948)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapab
leBeanFactory.java:284)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapab
leBeanFactory.java:204)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListable
BeanFactory.java:203)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:279)
        at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3276)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:3618)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
        at org.apache.catalina.core.StandardService.start(StandardService.java:497)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
* Nested Exception (Underlying Cause) ---------------
java.sql.SQLException: ORA-01002: fetch out of sequence

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
        at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
        at oracle.jdbc.oci8.OCIDBAccess.fetch(OCIDBAccess.java:1410)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
        at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.obtainLock(StdRowLockSemaphore.java:137)
        at org.quartz.impl.jdbcjobstore.JobStoreCMT.storeJob(JobStoreCMT.java:310)
        at org.quartz.core.QuartzScheduler.addJob(QuartzScheduler.java:646)
        at org.quartz.impl.StdScheduler.addJob(StdScheduler.java:244)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.addJobToScheduler(SchedulerFactoryBean.java:524)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.registerJobsAndTriggers(SchedulerFactoryBean.java:
486)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:404)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowi
reCapableBeanFactory.java:948)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapab
leBeanFactory.java:284)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapab
leBeanFactory.java:204)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListable
BeanFactory.java:203)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:279)
        at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3276)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:3618)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
        at org.apache.catalina.core.StandardService.start(StandardService.java:497)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)

Finally, my quartz.properties are:

#============================================================================
# Configure Main Scheduler Properties
#============================================================================

#org.quartz.scheduler.instanceName = TestScheduler
##org.quartz.scheduler.instanceId = AUTO

#============================================================================
# Configure ThreadPool
#============================================================================

org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount = 5
org.quartz.threadPool.threadPriority = 5

#============================================================================
# Configure JobStore
#============================================================================

org.quartz.jobStore.misfireThreshold = 60000
#org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore.class = org.springframework.scheduling.quartz.LocalDataSourceJobStore
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
##org.quartz.jobStore.useProperties = false
#org.quartz.jobStore.dataSource = myDS
##org.quartz.jobStore.tablePrefix = QRTZ_
##org.quartz.jobStore.isClustered = true

#============================================================================
# Configure Datasources
#============================================================================

#org.quartz.dataSource.myDS.driver = 
#org.quartz.dataSource.myDS.URL = 
#org.quartz.dataSource.myDS.user = 
#org.quartz.dataSource.myDS.password =
#org.quartz.dataSource.myDS.maxConnections = 
#org.quartz.dataSource.myDS.validationQuery=

#============================================================================
# Configure Plugins
#============================================================================

##org.quartz.plugin.shutdownHook.class = org.quartz.plugins.management.ShutdownHookPlugin
##org.quartz.plugin.shutdownHook.cleanShutdown = true


org.quartz.plugin.triggHistory.class = org.quartz.plugins.history.LoggingJobHistoryPlugin

Has anyone else run into this problem?

Any help would be greatly appreciated.

[dhalbrook]

I just realized I forgot to post my config:

<bean name="setupJobDetail" class="org.springframework.scheduling.quartz.JobDetailBean">
        <property name="jobClass">
            <value>com.foo.SetupJob</value>
        </property>
        <property name="jobDataAsMap">
            <map>
                <entry key="timeout">
                    <value>5</value>
                </entry>
            </map>
        </property>
    </bean>

    <bean id="simpleTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerBean">
        <property name="jobDetail">
            <!-- see the example of method invoking job above -->
            <ref bean="setupJobDetail"/>
        </property>
        <property name="startDelay">
            <!-- 10 seconds -->
            <value>10000</value>
        </property>
        <property name="repeatInterval">
            <!-- repeat every 50 seconds -->
            <value>50000000000</value>
        </property>
    </bean>

    <bean id="schedulerFactory" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource"/>
        </property>
        <property name="triggers">
            <list>
                <ref local="simpleTrigger"/>
            </list>
        </property>
    </bean>

[dhalbrook]

If I don't pass any triggers to the SchedulerFactoryBean, it starts up correctly. However, on shutdown, I get this error:

Using context class [org.springframework.web.context.support.XmlWebApplicationContext] for root WebApplicationContext
Published root WebApplicationContext [org.springframework.web.context.support.XmlWebApplicationContext: displayName=[Root XmlWebApplicationContext]; startup date=[Fri Sep 03 17:45:17 PDT 2004]; root of ApplicationContext hierarchy; config locations=[/WEB-INF/classes/spring-main.xml,/WEB-INF/classes/spring-dao.xml,/WEB-INF/classes/spring-mail.xml,/WEB-INF/classes/spring-rss.xml]; ] as ServletContext attribute with name [interface org.springframework.web.context.WebApplicationContext.ROOT]
Initializing filter 'openSessionInViewFilter'
Filter 'openSessionInViewFilter' configured successfully
Closing application context [Root XmlWebApplicationContext]
Destroying singletons in factory {org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [sysProps,placeholderConfig,dataSource,sessionFactory,hibernateDAOService,jdbcDAOService,adminDAO,articleDAO,channelDAO,compDAO,execDAO,employeeDAO,extSourceDAO,headlineDAO,mediaDAO,metadataDAO,permissionDAO,tabDAO,topicDAO,userDAO,transactionManager,adminManager,articleManager,channelManager,headlineManager,mediaManager,tabManager,userManager,mailSender,notificationEventListener,notificationTemplate,assignmentNotificationTemplate,submissionNotificationTemplate,articleEventListener,articleFeed,schedulerFactory]; Root of BeanFactory hierarchy}
Closing Hibernate SessionFactory
Shutting down Quartz scheduler
Scheduler QuartzScheduler_$_NON_CLUSTERED shutting down.
Scheduler QuartzScheduler_$_NON_CLUSTERED paused.
Database connection shutdown unsuccessful.
java.sql.SQLException: There is no DataSource named 'dummy'
	at org.quartz.utils.DBConnectionManager.shutdown(DBConnectionManager.java:147)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.shutdown(JobStoreSupport.java:530)
	at org.quartz.impl.jdbcjobstore.JobStoreCMT.shutdown(JobStoreCMT.java:157)
	at org.quartz.core.QuartzScheduler.shutdown(QuartzScheduler.java:471)
	at org.quartz.impl.StdScheduler.shutdown(StdScheduler.java:185)
	at org.springframework.scheduling.quartz.SchedulerFactoryBean.destroy(SchedulerFactoryBean.java:584)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.destroyBean(AbstractAutowireCapableBeanFactory.java:1010)
	at org.springframework.beans.factory.support.AbstractBeanFactory.destroySingleton(AbstractBeanFactory.java:422)
	at org.springframework.beans.factory.support.AbstractBeanFactory.destroySingletons(AbstractBeanFactory.java:408)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.destroySingletons(AbstractAutowireCapableBeanFactory.java:973)
	at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:414)
	at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:180)
	at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:70)
	at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3316)
	at org.apache.catalina.core.StandardContext.stop(StandardContext.java:3682)
	at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:1036)
	at org.apache.catalina.core.StandardHostDeployer.remove(StandardHostDeployer.java:470)
	at org.apache.catalina.core.StandardHost.remove(StandardHost.java:868)
	at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:758)
	at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:738)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:360)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
	at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1221)
	at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1233)
	at org.apache.catalina.core.StandardService.stop(StandardService.java:554)
	at org.apache.catalina.core.StandardServer.stop(StandardServer.java:2225)
	at org.apache.catalina.startup.Catalina$CatalinaShutdownHook.run(Catalina.java:624)
Database connection shutdown unsuccessful.
java.sql.SQLException: There is no DataSource named 'dummy'
	at org.quartz.utils.DBConnectionManager.shutdown(DBConnectionManager.java:147)
	at org.quartz.impl.jdbcjobstore.JobStoreCMT.shutdown(JobStoreCMT.java:160)
	at org.quartz.core.QuartzScheduler.shutdown(QuartzScheduler.java:471)
	at org.quartz.impl.StdScheduler.shutdown(StdScheduler.java:185)
	at org.springframework.scheduling.quartz.SchedulerFactoryBean.destroy(SchedulerFactoryBean.java:584)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.destroyBean(AbstractAutowireCapableBeanFactory.java:1010)
	at org.springframework.beans.factory.support.AbstractBeanFactory.destroySingleton(AbstractBeanFactory.java:422)
	at org.springframework.beans.factory.support.AbstractBeanFactory.destroySingletons(AbstractBeanFactory.java:408)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.destroySingletons(AbstractAutowireCapableBeanFactory.java:973)
	at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:414)
	at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:180)
	at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:70)
	at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3316)
	at org.apache.catalina.core.StandardContext.stop(StandardContext.java:3682)
	at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:1036)
	at org.apache.catalina.core.StandardHostDeployer.remove(StandardHostDeployer.java:470)
	at org.apache.catalina.core.StandardHost.remove(StandardHost.java:868)
	at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:758)
	at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:738)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:360)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
	at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1221)
	at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1233)
	at org.apache.catalina.core.StandardService.stop(StandardService.java:554)
	at org.apache.catalina.core.StandardServer.stop(StandardServer.java:2225)
	at org.apache.catalina.startup.Catalina$CatalinaShutdownHook.run(Catalina.java:624)
Scheduler QuartzScheduler_$_NON_CLUSTERED shutdown complete.

Just thought I'd add this into the equation in case it was helpful. I looked through my code and nothing is named "dummy", so it must be a default setting somewhere...

[croudet]

Try to add the following property to your
scheduler configuration.

<prop key="org.quartz.jobStore.selectWithLockSQL">SELECT * FROM &#123;0&#125;LOCKS UPDLOCK WHERE LOCK_NAME = ?</prop>

[dhalbrook]

Thanks croudet! That seems to fix the first problem (so at least I can schedule and run tasks), but the shutdown problem still remains. At least it's progress!

[croudet]

I have looked a bit to the Quartz code for the shutdown problem.
The StdSchedulerFactory.instantiate() method registers DataSource in the DBManager.

dbMgr = DBConnectionManager.getInstance();
dbMgr.addConnectionProvider(dsNames[i], cp);

but the dataSource we passed using <property name="dataSource">...
is not registered in the dbMgr.
It seems that only dataSources passed with quartz properties
(<prop key="org.quartz.dataSource....) are registered.

I haven't dig enough to see what the shutdown does, but in my case, when the scheduler shuts down, it should not shutdown the dataSource (still in use for DAO). So the current behaviour is fine for me.

[dhalbrook]

I figured out what was causing the fetch out of sequence error. As stated in several places, this is caused when autocommit is set to true and the driver tries to execute a fetch before committing (at least that's what I understand is going on).

I found the simplest way to deal with this, at least when using the Spring-managed datasource, was to wrap my Quartz scheduling code in a transcation template. Duh! Now the commits are managed correctly by my transactionManager, and all is happy.

Hope this helps someone in the same bind.

Sample code is below:

/**
     * Publish out an article event (publish, update, delete)
     *
     * @param action    An action, as defined by constants in NotifyRemoteListenerJob
     * @param articleId
     */
    public void notifyRemoteListeners(final String action, final String articleId, final Date startDate) {
        TransactionTemplate tt = new TransactionTemplate(this.transactionManager);
        try {
            tt.execute(new TransactionCallbackWithoutResult() {
                protected void doInTransactionWithoutResult(TransactionStatus status) {
                    //give job detail a unique name
                    notifyRemoteListenerJobDetail.setName("notifyRemoteListenerJobDetail('" + action + "', " + articleId + ", " + new Date() + ")");

                    Map jobDataMap = notifyRemoteListenerJobDetail.getJobDataMap();
                    jobDataMap.put("action", action);
                    jobDataMap.put("articleId", articleId);
                    SimpleTrigger trigger =
                            new SimpleTrigger("articleEventTrigger('" + action + "', " + articleId + ", " + new Date() + ")",
                                    Scheduler.DEFAULT_GROUP, startDate);
                    try {
                        scheduler.scheduleJob(notifyRemoteListenerJobDetail, trigger);
                    } catch (SchedulerException e) {
                        log.error("notifyRemoteListeners", e);
                    }
                }
            });
        } catch (Exception e) {
            log.error("notifyRemoteListeners", e);
        }
    }

[yoshi]

hello,dhalbrook

Can you post the snippet code about the transactionManager from your config file? I come across the same problem with you. I also met with the DataSource named 'dummy' when my scheduler shutdown. I have done as what you suggeted to do, but it didn't work. Can you give me a hand?

Thanx in advance.

Yoshiyan

[dhalbrook]

Yoshiyan, I'd love to help you, but I haven't figured out the shutdown problem yet. When I get some more free time I'll have a look through the source code for the SchedulerFactoryBean and hopefully we can get a fix for this into the next build of Spring.

--Dolan

[ranjan kumar]

Hi ,

I need to know where to add:
<prop key="org.quartz.jobStore.selectWithLockSQL">SELECT * FROM &#123;0&#125;LOCKS UPDLOCK WHERE LOCK_NAME = ?</prop>.

My qurtz.properties file:


# Using JobStoreTX
## Be sure to run the appropriate script(under docs/dbTables) first to create tables
org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX


# Configuring JDBCJobStore with the Table Prefix
org.quartz.jobStore.tablePrefix = QRTZ_

# Using DriverDelegate
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate

org.quartz.jobStore.isClustered = true
org.quartz.jobStore.clusterCheckinInterval = 20000

#error workaround
org.quartz.plugin.jobInitializer.class = org.quartz.plugins.xml.JobInitializationPlugin
#org.quartz.plugin.jobInitializer.fileName = closed-jobs.xml:open-jobs.xml

#org.quartz.plugin.jobInitializer.overWriteExistin gJobs = false
#org.quartz.plugin.jobInitializer.failOnFileNotFou nd = true

org.quartz.scheduler.wrapJobExecutionInUserTransac tion= true
org.quartz.scheduler.wrapPluginInUserTransaction= true
# Using datasource
org.quartz.jobStore.dataSource = fsccDS

# Define the datasource to use
org.quartz.dataSource.qzDS.driver = oracle.jdbc.driver.OracleDriver
org.quartz.dataSource.qzDS.URL = xx
org.quartz.dataSource.qzDS.user = xxx
org.quartz.dataSource.qzDS.password = boeing777
org.quartz.dataSource.qzDS.maxConnections = 30


-----------------\

My services.xml file:
<bean id="emailreporttrigger"
class="org.springframework.scheduling.quartz.CronT riggerBean">
<property name="jobDetail">
<ref bean="emailreportjob" />
</property>
<property name="cronExpression">
<value>0 0 12 1 * ?</value>
</property>
</bean>

<bean id="emailreportjob"
class="org.springframework.scheduling.quartz.JobDe tailBean">
<property name="jobClass">
<value>
com.ge.oilandgas.dps.fscc.services.EmailReportServ ice
</value>
</property>
<property name="jobDataAsMap">
<map>
<entry key="emailNotifierDAO">
<ref bean="emailnotifierdao" />
</entry>
<entry key="mailSender">
<ref bean="mailsender"/>
</entry>
</map>
</property>
</bean>

<bean
class="org.springframework.scheduling.quartz.Sched ulerFactoryBean">
<property name="triggers">
<list>
<ref bean="emailreporttrigger" />
</list>
</property>
<property name="quartzProperties">

<value>/quartz.properties</value>
</property>
<property name="dataSource">
<ref bean="dataSourceFSCC" />

</property>
<property class="org.quartz.jobStore.selectWithLockSQL">
<value>SELECT * FROM &#123;0&#125;LOCKS UPDLOCK WHERE LOCK_NAME = ?</value>
</property>
</bean>




Problem:::I have the same error as mentioned above:

Error: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-01002: fetch out of sequence
[See nested exception: java.sql.SQLException: ORA-01002: fetch out of sequence
]
Caused by:
x
[See nested exception: java.sql.SQLException: ORA-01002: fetch out of sequence
]


Please reply fast.

Thanks,
Ranjan