调试易

四月 24, 2013 9:33:52 上午 org.apache.catalina.core.ApplicationContext log
INFO: HTMLManager: list: Listing contexts for virtual host 'localhost'错误提示如下：
2013-04-24 09:35:34,115 [http-8080-4] INFO  com.serp.dao.xt.CompanyDao - 执行查询语句: SELECT * FROM XT_COMPANY_T limit 1 offset 0
2013-04-24 09:35:34,116 [http-8080-4] INFO  com.serp.dao.xt.CompanyDao - 当前查询的字段名为：COMPANY_NAME,COMP_SHORT_NAME,COMP_LOGO,COMP_PHONE,COMP_FAX,COMP_MAIL,COMP_ADDR,COMP_CONT_NAME,
2013-04-24 09:35:34,116 [http-8080-4] INFO  com.serp.dao.xt.CompanyDao - 查询历时(获取连接、查询结果、转换对象、关闭连接)：0.001秒.
2013-04-24 09:35:34,117 [http-8080-4] INFO  com.serp.dao.xt.ModuleDao - 执行查询语句: SELECT * FROM XT_MODULE_T WHERE (MODU_STAT=2 or MODU_STAT=1) ORDER BY MODULE_NAME
2013-04-24 09:35:34,117 [http-8080-4] INFO  com.serp.dao.xt.ModuleDao - 当前查询的字段名为：MODU_NO,MODULE_NAME,MODU_LEVE_NO,MODU_ROAD,MODULE_PRIV_FLAG,MODULE_LOG_FLAG,MODULE_TOP_LEVEL,MODU_SEQ,MODU_STAT,MODU_FORM,MODU_JSP,
2013-04-24 09:35:34,119 [http-8080-4] INFO  com.serp.dao.xt.ModuleDao - 查询历时(获取连接、查询结果、转换对象、关闭连接)：0.003秒.
2013-04-24 09:35:34,120 [http-8080-4] INFO  com.serp.dao.xt.InitDao - 执行预编译查询语句: SELECT INIT_ID,INIT_PWD,INVOICE_NUM  FROM XT_INIT_T WHERE INIT_ID= 1  limit 1 offset 0
2013-04-24 09:35:34,120 [http-8080-4] INFO  com.serp.dao.xt.InitDao - 当前查询的字段名为：INIT_ID,INIT_PWD,INVOICE_NUM,
2013-04-24 09:35:34,122 [http-8080-4] INFO  com.serp.dao.xt.InitDao - 查询历时(获取连接、查询结果、转换对象、关闭连接)：0.003秒.
2013-04-24 09:35:34,123 [http-8080-4] INFO  com.serp.dao.xt.OperateDao - 执行查询语句: SELECT OPERATE_NO,OPERATE_NAME,IF_DEFAULT,GET_DICT_DESC('XT_OPERATE_T','IF_DEFAULT',IF_DEFAULT) STR_IF_DEFAULT  FROM XT_OPERATE_T WHERE  1=1  ORDER BY OPERATE_NO DESC 
2013-04-24 09:35:34,123 [http-8080-4] ERROR com.serp.dao.xt.OperateDao - 查询出错: The user specified as a definer ('root'@'%') does not exist
2013-04-24 09:35:34,124 [http-8080-4] ERROR org.springframework.jdbc.datasource.DataSourceUtils - Could not close JDBC Connection
java.sql.SQLException: Connection is closed.
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:174)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:179)
at org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:286)
at org.springframework.jdbc.datasource.DataSourceUtils.releaseConnection(DataSourceUtils.java:247)
at org.tulip.Dao.closeConnection(Dao.java:125)
at org.tulip.RootDao.queryNormalList(RootDao.java:187)
at org.tulip.RootDao.queryList(RootDao.java:53)
at com.serp.dao.xt.OperateDao.getOperateColl(OperateDao.java:124)
at com.serp.SystemInit.sysInit(SystemInit.java:109)
at com.serp.act.xt.LoginAct.execute(LoginAct.java:47)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
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.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.serp.util.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:291)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
2013-04-24 09:35:34,124 [http-8080-4] ERROR com.serp.SystemInit - 系统初始化信息出错:查询出错!
The user specified as a definer ('root'@'%') does not exist
org.tulip.DaoException: 查询出错!
The user specified as a definer ('root'@'%') does not exist
at org.tulip.RootDao.queryNormalList(RootDao.java:183)
at org.tulip.RootDao.queryList(RootDao.java:53)
at com.serp.dao.xt.OperateDao.getOperateColl(OperateDao.java:124)
at com.serp.SystemInit.sysInit(SystemInit.java:109)
at com.serp.act.xt.LoginAct.execute(LoginAct.java:47)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
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.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.serp.util.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:291)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
MySQL服务器无法连接