最近遇到一个SQL错误问题,急需解决,请高手给予正解
(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
异常SQL:select c.organizationname as organizationname,u.departmentnamjava.sql.SQLException: [SQL0461] ´ÓC010090017µ½C010090018µÄCAST²»ÊÜÖ§³Ö¡£
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:643)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:614)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:862)
at com.ibm.as400.access.AS400JDBCStatement.executeQuery(AS400JDBCStatement.java:1883)
at com.hnww.db.DbManage.executeQuery(DbManage.java:160)
at com.hnww.db.DbManage.executeQuery(DbManage.java:141)
at org.apache.jsp.AppLoginList_jsp._jspService(AppLoginList_jsp.java:131)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.rune,a.userid,b.username,d.chnlname as chnlname ,a.ip,a.viewdate,c.PARENTID as parentid2,u.superdeptid as superdeptid from t_site_flow a,website_user b,website_organization c, WCMCHANNEL d,website_department u where lower(a.userid)=lower(b.userid) and u.departmentid=b.departmentid and u.organizationid=b.organizationid and c.organizationid=b.organizationid and a.viewdate>='2010-09-01' and a.viewdate<='2010-09-04' and a.channelid in (9001,9007,9006,9005,9010,9011,9002) and b.organizationid in ('41580236-3') and a.channelid =d.channelid order by c.organizationname,u.departmentname,d.chnlname
分享到:
相关推荐
matlab数理统计和数据分析及优化求解:43扩展参考:求解非线性方程组 fsolve.zip
matlab数理统计和数据分析及优化求解:36 matlab有约束多元变量多目标规划问题求解.zip
matlab数理统计和数据分析及优化求解:4 matlab排序最值标准差方差.zip
求解:matlab+yalmip+gurobi作为求解器) 内容:考虑源荷两侧不确定性的含风电的低碳调度,引入模糊机会约束,程序包括储能、风光、火电机组及水电机组,解决了目标函数含有分类特征的约束问题、非线性约束 目标的...
matlab数理统计和数据分析及优化求解:46 杜芬方程解仿真解曲线.zip
matlab数理统计和数据分析及优化求解:42扩展参考: 高维方程组求解的牛顿迭代法.zip
matlab数理统计和数据分析及优化求解:40 扩展参考: matlab欧拉Euler法求解微分方程组.zip
matlab数理统计和数据分析及优化求解:39 扩展参考:matlab寻找素数.zip
matlab数理统计和数据分析及优化求解:37 matlab有约束条件多元变量函数最小值解法.zip
matlab数理统计和数据分析及优化求解:介绍10种优化求解的方法、求解最小二乘问题、解线性规划问题、 求解最大利润问题、 投资问题、定位问题.zip
matlab数理统计和数据分析及优化求解:41 扩展参考:matlab平衡方程用于图像.zip
matlab数理统计和数据分析及优化求解:45 直方图拟合.zip
matlab数理统计和数据分析及优化求解:25-33程序.zip
matlab数理统计和数据分析及优化求解:9 matlab假设检验.zip