Java 定时任务时SQL 报错

ToFuelYou 2019-04-12 06:19:20
使用按钮调用方法时,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: 表或视图不存在
...全文
448 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
ToFuelYou 2019-04-15
  • 打赏
  • 举报
回复
已经解决了,谢谢各位了。
解决方案,参考
https://zhidao.baidu.com/question/745113704316403932.html
千丈冰 2019-04-15
  • 打赏
  • 举报
回复
创建的jobs是DBMS_jobs吗?再确认创建的jobs是当前用户下的不?
ToFuelYou 2019-04-15
  • 打赏
  • 举报
回复
不能啊,我手动调这个方法SQL能执行啊,换成定时任务SQL不行,其他的都不修改
幽饮烛 2019-04-13
  • 打赏
  • 举报
回复
ORA-00942: 表或视图不存在

sql 语句有问题或是连错数据库了
ToFuelYou 2019-04-12
  • 打赏
  • 举报
回复
希望有大牛,帮我解解惑,谢谢!分不高。只有这么多分

67,512

社区成员

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器,保护我们的业务核心组件(中间件),以延续它的生命力,而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧