数据库连接问题

zhaoxz

sql = select SM_SQD,SM_SQD.fSXR as fSXR,SM_SQD.fFSSJ as fFSSJ,SM_SQD.fSQDW as fSQDW,SM_SQD.fSQR as fSQR,SM_SQD.fSQDWBM as fSQDWBM,SM_SQD.fReadFlag as fReadFlag,SM_SQD.fDXCFGS as fDXCFGS,SM_SQD.fFSCGS as fFSCGS,SM_SQD.version as version, SM_SQD.fLTCGS as fLTCGS, SM_SQD.fYDCGS as fYDCGS, SM_SQD.fDXCGS as fDXCGS from SM_SQD SM_SQD  where  SM_SQD.fReadFlag = 0  and  SM_SQD.fDXHZHM is not null and SM_SQD.fDXHZHM <>''
2015-07-02 11:23:51 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="true" process="/sms/report/process/sendReprot/sendReprotProcess" activity="mainActivity" action-flag="__action_0__" executor="PSN01" execute-context="" name="SendTotalAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"></parameters></action>
java.lang.reflect.InvocationTargetException
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:592)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select SM_SQD,SM_SQD.fSXR as fSXR,SM_SQD.fFSSJ as fFSSJ,SM_SQD.fSQDW as fSQDW,SM_SQD.fSQR as fSQR,SM_SQD.fSQDWBM as fSQDWBM,SM_SQD.fReadFlag as fReadFlag,SM_SQD.fDXCFGS as fDXCFGS,SM_SQD.fFSCGS as fFSCGS,SM_SQD.version as version, SM_SQD.fLTCGS as fLTCGS, SM_SQD.fYDCGS as fYDCGS, SM_SQD.fDXCGS as fDXCGS from SM_SQD SM_SQD  where  SM_SQD.fReadFlag = 0  and  SM_SQD.fDXHZHM is not null and SM_SQD.fDXHZHM <>''
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.KSQL.select(Unknown Source)
at Report.splitDateOrSave(Report.java:128)
at Report.SendTotal(Report.java:51)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150055; 提示: 在模块"/sms"下获取数据库连接出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.Transaction.getConnection(Unknown Source)
at com.justep.system.data.Transaction.getConnection(Unknown Source)
at com.justep.model.ModelUtils.getConnection(Unknown Source)
... 32 more
Caused by: javax.naming.NameNotFoundException: Name orcl is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:152)
at javax.naming.InitialContext.lookup(InitialContext.java:351)
at com.justep.system.data.Transaction.getConnectionWithJndi(Unknown Source)
... 35 more
[ERROR] 2015-07-02 11:23:51,664 com.justep.report.controller.DataController - 报表数据获取失败

jishuang

Name orcl is not bound in this Context

没有配置数据源名为orcl的数据源
如果配置了，需要重启一下tomcat

zhaoxz

配置数据源后正常了。