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

来源：互联网发布：易语言编程系统全书编辑：程序博客网时间：2024/05/30 07:13

推荐：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:

阅读全文

0 0