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

来源:互联网 发布:绝对萌域淘宝店名 编辑:程序博客网 时间:2024/05/25 23:25

 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
原创粉丝点击