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

推荐：Spring配置Quartz出错解决ORA-00942:表或视图不存在

网上说把数据源的名字修改一下，还有一种方式：单独建一个spring配置文件，在<beans>里加一个属性： default-autowire="no" 

 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进行自动装配，访问了数据库。 

 Couldn't retrieve trigger: ORA-00942: 表或视图不存在 Caused by:  org.quartz.JobPersistenceException : Couldn't retrieve trigger: ORA-00942: 表或视图不存在  [See nested exception: