登录
当前位置： 首页 > 知识库问答 >
问题：

组织。石英ScheduleException:作业和触发器注册失败

於宾白
2023-03-14

我在使用quartz scheduler运行web应用程序时遇到以下错误。

我使用两个数据库连接和石英，我想使用德比，所以我给德比事务管理器在我的配置文件。

此配置文件中的问题是什么，quartz调度程序如何尝试访问数据库。

我的配置文件如下所示：

<context:annotation-config />
<context:component-scan base-package="com.chase.index" />

<ehcache:annotation-driven cache-manager="cacheManager" />
<bean id="cacheManager"
    class="org.springframework.cache.ehcache.EhCacheManagerFactoryBean">
    <property name="configLocation" value="/WEB-INF/ehcache.xml" />
</bean>

<bean
    class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="prefix">
        <value>/resources/pages/</value>
    </property>
    <property name="suffix">
        <value>.jsp</value>
    </property>
</bean>

<!-- Hibernate properties -->
<bean id="propertyConfigurer"
    class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
    p:location="/WEB-INF/jdbc.properties">
</bean>

<!-- Datasource setup by Spring -->
<jee:jndi-lookup id="dataSource" jndi-name="jdbc/example"
    cache="true" resource-ref="true" lookup-on-startup="false"
    proxy-interface="javax.sql.DataSource" />

<!-- <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" 
    p:driverClassName="${jdbc.driverClassName}" p:url="${jdbc.databaseurl}" p:username="${jdbc.username}" 
    p:password="${jdbc.password}"> </bean> -->

<bean id="customerSessionFactory"
    class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"></property>
    <!-- <property name="configurationClass" value="org.hibernate.cfg.AnnotationConfiguration" 
        /> -->
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.DB2Dialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.format_sql">false</prop>
            <prop key="hibernate.generate_statistics">false</prop>
            <prop key="hibernate.connection.release_mode">after_transaction</prop>
        </props>
    </property>
    <property name="packagesToScan">
        <list>
            <value>com.chase.index</value>
        </list>
    </property>
</bean>


<jee:jndi-lookup id="derbyDataSource" jndi-name="jdbc/derbyDataSource"
    cache="true" resource-ref="true" lookup-on-startup="false"
    proxy-interface="javax.sql.DataSource" />

<bean id="derbySessionFactory"
    class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    <property name="dataSource" ref="derbyDataSource"></property>
    <!-- <property name="configurationClass" value="org.hibernate.cfg.AnnotationConfiguration" 
        /> -->
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.DerbyDialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.format_sql">false</prop>
            <prop key="hibernate.generate_statistics">false</prop>
            <prop key="hibernate.connection.release_mode">after_transaction</prop>
        </props>
    </property>
    <property name="packagesToScan">
        <list>
            <value>com.chase.index</value>
        </list>
    </property>
</bean>

<util:map id="dataSourceMap">
    <entry key="customerSessionFactory" value-ref="customerSessionFactory" />
    <entry key="derbySessionFactory" value-ref="derbySessionFactory" />
</util:map>

<bean id="paramTransactionManager"
    class="org.springframework.orm.hibernate4.HibernateTransactionManager">
    <property name="sessionFactory" ref="derbySessionFactory" />
</bean>

<bean id="transactionManager"
    class="org.springframework.orm.hibernate4.HibernateTransactionManager">
    <property name="sessionFactory" ref="customerSessionFactory"></property>
</bean>

<bean
    class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />

<!-- <bean id="runMeJob" class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean"> 
    <property name="targetObject" ref="runMeTask" /> <property name="targetMethod" 
    value="printMe" /> </bean> -->

<bean id="runMeTask" class="com.chase.index.scheduler.SyncDBDataTask" />

<bean name="runMeJob"
    class="org.springframework.scheduling.quartz.JobDetailFactoryBean">

    <property name="jobClass" value="com.chase.index.scheduler.SyncDBDataJob" />

    <property name="jobDataAsMap">
        <map>
            <entry key="runMeTask" value-ref="runMeTask" />
        </map>
    </property>
</bean>

<!-- <bean id="simpleTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerBean"> 
    <property name="jobDetail" ref="runMeJob" /> <property name="repeatInterval" 
    value="5000" /> <property name="startDelay" value="1000" /> </bean> -->

<bean id="cronTrigger"
    class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">

    <property name="jobDetail" ref="runMeJob" />
    <property name="cronExpression" value="0/5 * * * * ?" />

</bean>


<bean class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
    <property name="autoStartup" value="true" />
    <property name="waitForJobsToCompleteOnShutdown" value="true" />
    <property name="transactionManager" ref="paramTransactionManager" />
    <property name="jobDetails">
        <list>
            <ref bean="runMeJob" />
        </list>
    </property>

    <property name="triggers">
        <list>
            <ref bean="cronTrigger" />
        </list>
    </property>
</bean>
<tx:annotation-driven />

共有3个答案

吴飞语
2023-03-14

我最近在JBoss EAP 7.3上部署应用程序时遇到了类似的异常。

ERROR XXXXXX.systemupdate.internal.ApplicationStateInitializer - [User:unknown] Error in determineAndSetApplicationState: 
 XXXXXX.common.beans.NoSuchBeanException: The requested bean(s) of type 'org.springframework.scheduling.quartz.SchedulerFactoryBean' could not be found.
    at XXXXXX.spring.SpringBeanFactoryAdapter.getBeansOfType(SpringBeanFactoryAdapter.java:77)
    at XXXXXX.common.beans.BeanLocator.getBeansOfType(BeanLocator.java:113)
    at XXXXXX.systemupdate.internal.SystemUpdateContributorController.startSchedulerJobs(SystemUpdateContributorController.java:376)
    at XXXXXX.systemupdate.internal.SystemUpdateContributorController.setApplicationStateToReady(SystemUpdateContributorController.java:369)
    at XXXXXX.systemupdate.internal.ApplicationStateInitializer.determineAndSetApplicationState(ApplicationStateInitializer.java:62)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1912)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1854)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:602)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:524)
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:944)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:144)
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:782)
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:774)
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:339)
    at org.springframework.boot.web.servlet.support.SpringBootServletInitializer.run(SpringBootServletInitializer.java:173)
    at org.springframework.boot.web.servlet.support.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:153)
    at org.springframework.boot.web.servlet.support.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:95)
    at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:174)
    at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:204)
    at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:186)
    at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:42)
    at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
    at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1504)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1504)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1504)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1504)
    at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:252)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:96)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:78)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
    at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1982)
    at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
    at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
    at java.lang.Thread.run(Thread.java:748)
    at org.jboss.threads.JBossThread.run(JBossThread.java:485)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'clusterSchedulerFactoryBean' defined in class path resource [XXX.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerException: Registration of jobs and triggers failed: oracle/sql/BLOB
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1786)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:602)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:524)
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:671)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:659)
    at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1300)
    at XXXXXX.spring.SpringBeanFactoryAdapter.getBeansOfType(SpringBeanFactoryAdapter.java:74)
    ... 49 more
Caused by: org.quartz.SchedulerException: Registration of jobs and triggers failed: oracle/sql/BLOB
    at org.springframework.scheduling.quartz.SchedulerAccessor.registerJobsAndTriggers(SchedulerAccessor.java:265)
    at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:505)
    at XXXXXX.scheduling.QuartzConfig.afterPropertiesSet(QuartzConfig.java:45)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1845)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782)
    ... 59 more

调试（spring正在吞咽异常）揭示了根本原因

  at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
  at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1982)
  at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
  at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
  at java.lang.Thread.run(Thread.java:748)
  at org.jboss.threads.JBossThread.run(JBossThread.java:485)
Caused by: java.lang.ClassNotFoundException: oracle.sql.BLOB from [Module "deployment.XXXX.war" from Service Module Loader]
  at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:255)
  at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:410)
  at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398)
  at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:116)

结果是我忘记了将oracle驱动程序注册为全局模块，在

<global-modules>
  <module name="com.oracle" slot="main"/>
</global-modules>

唐腾
2023-03-14

如果你有石英Api 2，那么你必须关心以下步骤：

  • 将JobDetailBean替换为JobDetailFactoryBean
  • 将CronTriggerBean替换为CronTriggerFactoryBean

您还需要执行以下操作：

如果在bean初始化过程中出现耐久性错误，则使用

>

  • 在JobBean中。

    • 魏宸
    2023-03-14

    您的问题的根本原因是java.sql.SQLSynTaxError异常：Table/View'QRTZ_JOB_DETAILS'不存在

    检查连接到的数据库架构中是否存在表QRTZ\u JOB\u DETAILS。还要验证访问此架构的凭据是否可以访问此表。

     类似资料：
    • 组织。石英JobPersistenceException:触发器引用的作业（DEFAULT.tryJob）不存在

      我的xml文件 和我的财产档案 和我的主方法类文件 当运行这个主方法时，它总是抛出异常 但在xml文件中默认组不使用，那么为什么在我更改作业组名称时它总是抛出异常默认其工作，但在组名称标记中放入任何名称其抛出异常为什么

    • Spring石英触发程序作业

      我有一个Sprint Boot-Java8应用程序，它有一个quartz作业，我在启动时配置该作业并设置一个时间表。该作业按照计划自动运行,这与您对quartz作业的期望一样。然而，现在我希望能够允许用户通过点击前端上的一个按钮手动触发这些作业，而不会扰乱该作业的正常调度。这是我所有的相关档案。 但每次运行应用程序并点击控制器的方法时，都会在控制台中出现以下错误： 我到底做错了什么？如何使此作业按

    • 如何用相应的触发器手动触发石英作业

      我们使用quartz调度器创建一个带有触发器名称和触发器组的触发器，它将在15分钟的间隔被触发。 我们希望在任何时间点手动触发时间表。因此，我们所做的就是获取与我们创建的计划相关联的作业的触发键细节，并尝试使用以下API触发作业。 用上面提到的API激发作业时（即尝试手动激发作业）的Quartz日志： 能不能有人请让我知道我们如何才能使时间表是触发与原来的工作相关联的触发器。

    • 石英触发器不能立即触发

      我想用quartz scheduler使用jdbc数据存储立即执行作业~。然而，即使我使用now（）或调用triggerjob进行调度，在调度和触发器fire之间也有20-30秒的延迟。 我尝试用一个简单的触发器执行作业： 并且我还尝试用调度程序触发： 下面是显示延迟的侦听器日志。

    • 删除石英中的触发器

      问题内容： 有没有一种方法可以删除带有特定作业的预定触发器？似乎删除触发器的唯一方法是删除整个作业，然后重新注册该作业并触发。 我有一份可能有100多个触发器的作业，我真的不想删除该作业，而只需要删除1个触发器就重新注册所有触发器。 另外，是否有一种方法可以在配置触发器后立即停止调度程序执行作业？ 谢谢 问题答案： 尝试 这接受触发器和组名作为参数，并且只会删除指定的触发器，而不是作业。 Quar

    • 石英调度触发器卡住了

      在使用Quartz Scheduler 1.8.6版的应用程序中，当作业未完成时，我们遇到了一个触发器卡住的问题。 例如，我们有ssh调用或数据库查询的作业。如果这些作业挂起（因为ssh调用没有终止，或者select语句有一个表锁），那么我将无法再触发这些作业。触发器被卡住，直到我强制重新启动调度程序。 我已经试过了。中断（触发器）和调度程序。重新调度触发器（）。我试着移除触发器并重新创建它。我已

    相关问答

    石英调度触发器卡住了需要在石英调度程序启动时触发作业石英：跳过以相同的触发时间计划的重复作业触发石英。JobStoretX.触发器由两个节点同时触发动态作业调度石英

    相关文章

    触发动态作业MySQL触发器 Update触发Insert失败石英性能python的企业调度程序（如石英）如何创建和组织配置并注册Grunt任务

    相关阅读

    SQL Server触发器PL/SQL触发器进程组，会话和作业控制MySQL查看触发器MySQL创建触发器

    相关工具

    滴石Mac 开发配置手册网络发言防和谐器放置英雄稳定宝石放置

    相关文档

    企业微信使用手册ThinkCMF6 开发手册FreeBSD 开发手册XORM 操作手册GitBook 开发者手册
    快捷导航： 新手教程 算法原理 架构设计 Java进阶 数据库进阶 大厂专栏 面试经验 编程笔记 编程问答 所有专题 文档资料 工具软件 电子书籍 小牛导航
    在线工具： 房贷计算器 个税计算器 Linux命令查询 Json格式化 正则表达式 颜色转换 AES加解密 SHA1加密 MD5加密 毒鸡汤 字数统计 随机密码生成 进制转换 Base64编解码 励志句子
    Copyright © 2019-2024 小牛知识库@xnip.cn. All Rights Reserved.