Quartz Spring 报错!自动注解! Couldn't retrieve trigger: ORA-00942: 表或视图不存在

 Couldn't retrieve trigger: ORA-00942: 表或视图不存在

Caused by:  org.quartz.JobPersistenceException : Couldn't retrieve trigger: ORA-00942: 表或视图不存在
 [See nested exception:  java.sql.SQLSyntaxErrorException : ORA-00942: 表或视图不存在
]
       at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger( JobStoreSupport.java:1533 )
       at org.quartz.impl.jdbcjobstore.JobStoreSupport$12.execute( JobStoreSupport.java:1522 )
       at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock( JobStoreCMT.java:245 )
       at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeWithoutLock( JobStoreSupport.java:3723 )
       at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger( JobStoreSupport.java:1519 )
       at org.quartz.core.QuartzScheduler.getTrigger(  QuartzScheduler.java:1530 )
       at org.quartz.impl.StdScheduler.getTrigger(  StdScheduler.java:508 )
       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:597 )
       at org.springframework.util.ReflectionUtils.invokeMethod( ReflectionUtils.java:196 )
       ... 29 more
Caused by:  java.sql.SQLSyntaxErrorException : ORA-00942: 表或视图不存在

       at oracle.jdbc.driver.SQLStateMapping.newSQLException( SQLStateMapping.java:91 )
       at oracle.jdbc.driver.DatabaseError.newSQLException(  DatabaseError.java:112 )
       at oracle.jdbc.driver.DatabaseError.throwSqlException( DatabaseError.java:173 )
       at oracle.jdbc.driver.T4CTTIoer.processError(  T4CTTIoer.java:455 )
       at oracle.jdbc.driver.T4CTTIoer.processError(  T4CTTIoer.java:413 )
       at oracle.jdbc.driver.T4C8Oall.receive(  T4C8Oall.java:1030 )
       at oracle.jdbc.driver.T4CPreparedStatement.doOall8( T4CPreparedStatement.java:194 )
       at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe( T4CPreparedStatement.java:785 )
       at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe( T4CPreparedStatement.java:860 )
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout( OracleStatement.java:1186 )
       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal( OraclePreparedStatement.java:3381 )
       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery( OraclePreparedStatement.java:3425 )
       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery( OraclePreparedStatementWrapper.java:1490 )
       at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery( DelegatingPreparedStatement.java:96 )
       at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery( DelegatingPreparedStatement.java:96 )
       at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger( StdJDBCDelegate.java:1761 )
       at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger( JobStoreSupport.java:1531 )
       ... 40 more

修改方法
    <bean id="SpringJobSchedulerFactoryBean"  lazy-init="false" autowire="no" class="org.springframework.scheduling.quartz.SchedulerFactoryBean"> 

 改为 autowire="no"    Spring进行自动装配,访问了数据库。


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值