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
- Quartz Spring 报错!自动注解! Couldn't retrieve trigger: ORA-00942: 表或视图不存在
- Quartz Spring 报错!自动注解! Couldn't retrieve trigger: ORA-00942: 表或视图不存在
- spring ORA-00942: 表或视图不存在
- oracle 报错 关于"ORA-00942 表或视图不存在"
- 解決org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: null
- 解決org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: null
- Spring配置Quartz出错解决ORA-00942:表或视图不存在
- job调用过程报错 ORA-00942: 表或视图不存在,权限问题
- ORA-00942: 表或视图不存在 dba_objects
- ORA-00942: 表或视图不存在
- Ora-00942:表或视图不存在
- ORACLE ORA-00942:表或视图不存在
- ora-00942: 表或视图不存在 解决方法
- ORA-00942 表或视图不存在解决办法
- ORA-00942: 表或视图不存在
- ORA-00942: 表或视图不存在解决方法
- ORA-00942: 表或视图不存在
- ORA-00942: 表或视图不存在
- (六)抽象工厂模式
- cocos2dx-v3.0命令行创建工程
- 光流法
- maven如何打包源代码
- 简单库函数的实现
- Quartz Spring 报错!自动注解! Couldn't retrieve trigger: ORA-00942: 表或视图不存在
- 网络流 -- Shooting Contest(二分匹配)
- post===non posted transaction事务类型学习--PCIE学习笔记
- 多播的实现和需要注意的问题
- CentOS下Nexus安装
- Logistic and Softmax Regression (逻辑回归和Softmax回归)
- 【Spark亚太研究院系列丛书】Spark实战高手之路-第3章Spark架构设计与编程模型第1节:为什么Spark是大数据必然的现在和未来?(1)
- 网络编程socket 之TCP三路握手和四路握手
- Zookeeper的安装和配置