求解：AS400 [SQL0461]
最近遇到一个SQL错误问题，急需解决，请高手给予正解(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)异常SQL：select c.organizationname as organizationname,u.departmentnamjava.sql.SQLException: ´Ó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_flowa,website_userb,website_organizationc, 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.channelidin (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
页:
[1]