Java 定时任务时SQL 报错
使用按钮调用方法时,SQL能正常执行,通过定时任务调用java方法时,确保SQL异常,表跟视图不存在,求大神解答!谢谢!
18:18:00,289 INFO [STDOUT] 2019-04-12 18:18:00,289 WARN [scheduler_Worker-7] JDBCExceptionReporter M[logExceptions] - SQL Error: 942, SQLState: 42000
18:18:00,290 ERROR [STDERR] 2019-04-12 18:18:00,289 ERROR [scheduler_Worker-7] JDBCExceptionReporter M[logExceptions] - ORA-00942: 表或视图不存在
18:18:00,293 ERROR [STDERR] 2019-04-12 18:18:00,292 ERROR [scheduler_Worker-7] JobRunShell M[run] - Job DEFAULT.tmsOrderWraperJobDetail threw an unhandled Exception:
org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'tmsSchedulingPlan' on target class [class $Proxy483] failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:269)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:343)
at com.synnex.framework.dao.CommonDAOHibernate.executeFindList(CommonDAOHibernate.java:114)
at com.synnex.framework.dao.CommonDAOHibernate.findByNativeSQL(CommonDAOHibernate.java:306)
at com.synnex.framework.dao.CommonDAOHibernate.findByNativeSQL(CommonDAOHibernate.java:295)
at com.synnex.tms.adaptor.TmsOrderWraperAdaptor.tmsconverter(TmsOrderWraperAdaptor.java:150)
at com.synnex.tms.webservice.TmsShipOrderWebServiceImpl.tmsplan(TmsShipOrderWebServiceImpl.java:183)
at com.synnex.tms.adaptor.TmsOrderPlan.tmsSchedulingPlan(TmsOrderPlan.java:25)
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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy483.tmsSchedulingPlan(Unknown Source)
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.MethodInvoker.invoke(MethodInvoker.java:276)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:260)
... 3 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2216)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at com.synnex.framework.dao.CommonDAOHibernate$7.doInHibernate(CommonDAOHibernate.java:315)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
... 27 more
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在