spring4.1.6 + quartz2.2.3 手动添加job报错，请高手支援~~

1223111 2017-02-15 11:38:09
spring 配置如下


   <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

		<property name="driverClassName" value="${jdbc.driverClassName}"></property>

		<property name="url" value="${jdbc.url}"></property>

		<property name="username" value="${jdbc.username}"></property>

		<property name="password" value="${jdbc.password}"></property>

		

		<property name="maxActive" value="${maxActive}"></property>

		<property name="maxWait" value="${maxWait}"></property>

		<property name="maxIdle" value="${maxIdle}"></property>

		<property name="minIdle" value="${minIdle}"></property>

		<property name="defaultAutoCommit" value="${defaultAutoCommit}"></property>

		<property name="removeAbandoned" value="${removeAbandoned}"></property>

		<property name="removeAbandonedTimeout" value="${removeAbandonedTimeout}"></property>

		<property name="logAbandoned" value="${logAbandoned}"></property>

		<property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}"></property>

	</bean>



<bean id="sessionFactory"

		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">

		<property name="dataSource" ref="dataSource" />

		<property name="hibernateProperties">

			<value>

				hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

				hibernate.hbm2ddl.auto=update

				hibernate.show_sql=false

				hibernate.format_sql=true

				hibernate.cache.use_second_level_cache=false

				hibernate.cache.use_query_cache=false

				hibernate.jdbc.fetch_size=50

				hibernate.jdbc.batch_size=50

				hibernate.connection.autocommit=true

				hibernate.connection.release_mode=auto

				hibernate.current_session_context_class=org.springframework.orm.hibernate4.SpringSessionContext

				javax.persistence.validation.mode=none

				hibernate.temp.use_jdbc_metadata_defaults=false

			</value>

		</property>



		<property name="packagesToScan" value="com.entity" /> 

	</bean>



  <bean id="transactionManager"

		class="org.springframework.orm.hibernate4.HibernateTransactionManager">

		<property name="sessionFactory" ref="sessionFactory" />

	</bean>



<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>



        <bean id="schedulerFactoryBean" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">  

	         <property name="dataSource" ref="dataSource" />

        </bean>


执行到停止触发器代码就会报错，原因就是数据库死锁，为什么spring管理的事务不提交？


  Scheduler scheduler = schedulerFactory.getScheduler();

			JobKey jobKey = JobKey.jobKey(job.getJobName(), job.getJobGroup());

			TriggerKey triggerKey = TriggerKey.triggerKey(job.getJobName(), job.getJobGroup());

			JobDetail jobDetail = scheduler.getJobDetail(jobKey);

			//存在，先删除再创建一个

			if (null != jobDetail) {

				scheduler.pauseTrigger(triggerKey);//停止触发器

				scheduler.unscheduleJob(triggerKey);//移除触发器

				scheduler.deleteJob(jobKey);//删除任务

			}


报错信息如下：

...全文
259 3 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
1223111 2017-02-15
  • 打赏
  • 举报
 回复
++++++++
1223111 2017-02-15
  • 打赏
  • 举报
 回复
main - 2017-02-15 10:54:10,264 - INFO - org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor - main - 2017-02-15 10:54:10,287 - INFO - org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl - main - 2017-02-15 10:54:10,287 - INFO - org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.2.3 created. - main - 2017-02-15 10:54:10,297 - INFO - org.springframework.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). - main - 2017-02-15 10:54:10,300 - INFO - org.springframework.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. - main - 2017-02-15 10:54:10,301 - INFO - org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.2.3) 'schedulerFactoryBean' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is not clustered. - main - 2017-02-15 10:54:10,301 - INFO - org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'schedulerFactoryBean' initialized from an externally provided properties instance. - main - 2017-02-15 10:54:10,301 - INFO - org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.2.3 - main - 2017-02-15 10:54:10,303 - INFO - org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@52e93037 - main - 2017-02-15 10:54:10,337 - INFO - org.springframework.orm.hibernate4.HibernateTransactionManager - Using DataSource [org.apache.commons.dbcp.BasicDataSource@fd2d8e0] of Hibernate SessionFactory for HibernateTransactionManager - main - 2017-02-15 10:54:56,710 - DEBUG - org.quartz.impl.jdbcjobstore.StdRowLockSemaphore - Lock 'TRIGGER_ACCESS' is desired by: main - main - 2017-02-15 10:54:56,711 - DEBUG - org.quartz.impl.jdbcjobstore.StdRowLockSemaphore - Lock 'TRIGGER_ACCESS' is being obtained: main - main - 2017-02-15 10:54:56,715 - DEBUG - org.quartz.impl.jdbcjobstore.StdRowLockSemaphore - Lock 'TRIGGER_ACCESS' was not obtained by: main - will try again. - main - 2017-02-15 10:54:57,718 - DEBUG - org.quartz.impl.jdbcjobstore.StdRowLockSemaphore - Lock 'TRIGGER_ACCESS' is being obtained: main - main - 2017-02-15 10:54:57,725 - DEBUG - org.quartz.impl.jdbcjobstore.StdRowLockSemaphore - Lock 'TRIGGER_ACCESS' was not obtained by: main - will try again. - main - 2017-02-15 10:54:58,726 - DEBUG - org.quartz.impl.jdbcjobstore.StdRowLockSemaphore - Lock 'TRIGGER_ACCESS' is being obtained: main - main - 2017-02-15 10:54:58,729 - DEBUG - org.quartz.impl.jdbcjobstore.StdRowLockSemaphore - Lock 'TRIGGER_ACCESS' was not obtained by: main - org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-01002: 提取违反顺序 [See nested exception: java.sql.SQLException: ORA-01002: 提取违反顺序 ] at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157) at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113) at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:238) at org.quartz.impl.jdbcjobstore.JobStoreSupport.pauseTrigger(JobStoreSupport.java:2159) at org.quartz.core.QuartzScheduler.pauseTrigger(QuartzScheduler.java:1231) at org.quartz.impl.StdScheduler.pauseTrigger(StdScheduler.java:351) at com.study.quartz.JobSecheduler.triggerJob(JobSecheduler.java:79) at com.study.quartz.JobSecheduler.init(JobSecheduler.java:60) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:349) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:300) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: java.sql.SQLException: ORA-01002: 提取违反顺序 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2400) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96) ... 52 more
1223111 2017-02-15
  • 打赏
  • 举报
 回复
没有人才看到么
springboot+Quartz(任务调度)
1、引入pom <!-- quartz --> <dependency> <groupId>org.quartz-scheduler</groupId> <artifactId>quartz</artifactId> <...2.2.3</version>
Quartz框架 之 自学杂记（一）
spring框架中也整合了此框架，org.springframework.scheduling.quartz主要API Job：作业，任务具体实现 JobDetail：作业细节，制定作业名等 Trigger：触发器，定义作业触发时间 scheduler：任务调度器 配置maven
springboot 对象 空指针_SpringBoot集成Quartz(解决@Autowired空指针Null问题即依赖注入的属性为null)...
Quartz的4个核心概念：1、Job表示一个工作，要执行的具体内容。此接口中只有一个方法void execute(JobExecutionContext context)2、JobDetailJobDetail表示一个具体的可执行的调度程序，Job是这个可执行程调度程序所...
Linux服务器部署xxl-job
Linux服务器部署xxl-job
SpringBoot集成Quartz(解决@Autowired空指针Null问题即依赖注入的属性为null)
使用spring-boot作为基础框架，其理念为零配置文件，所有的配置都是基于注解和暴露bean的方式。 Quartz的4个核心概念： 1、Job表示一个工作，要执行的具体内容。此接口中只有一个方法void execute...
Web 开发

81,122

社区成员

341,744

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章