操作错误提示信息:
Error!
com.stbook.struts.BeanActionException
调用Bean的相应Action方法出错: ('viewCategory'). Cause: java.lang.reflect.InvocationTargetException
Stack
com.stbook.struts.BeanActionException: 调用Bean的相应Action方法出错: ('viewCategory'). Cause: java.lang.reflect.InvocationTargetException
Caused by: java.lang.reflect.InvocationTargetException
at com.stbook.struts.BeanAction.execute(BeanAction.java:138)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:170)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:750)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor986.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.stbook.struts.BeanAction.execute(BeanAction.java:136)
... 33 more
Caused by: com.ibatis.dao.client.DaoException: Failed to queryForList - id [getProductListByCategory], parameterObject [{offset=0, sortType=productId, sortMode=desc, rows=30, categoryId=0141%}]. Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/stbook/yzweb/persistence/sqlmapdao/sql/Product.xml.
--- The error occurred while applying a result map.
--- Check the Product.productResult.
--- Check the result mapping for the 'createDate' property.
--- Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/stbook/yzweb/persistence/sqlmapdao/sql/Product.xml.
--- The error occurred while applying a result map.
--- Check the Product.productResult.
--- Check the result mapping for the 'createDate' property.
--- Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:194)
at com.stbook.yzweb.persistence.sqlmapdao.BaseSqlMapDao.queryForPager(BaseSqlMapDao.java:39)
at com.stbook.yzweb.persistence.sqlmapdao.ProductSqlMapDao.getProductListByCategory(ProductSqlMapDao.java:59)
at sun.reflect.GeneratedMethodAccessor215.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:61)
at com.sun.proxy.$Proxy14.getProductListByCategory(Unknown Source)
at com.stbook.yzweb.service.CatalogService.getProductListByCategory(CatalogService.java:171)
at com.stbook.yzweb.presentation.CatalogBean.viewCategory(CatalogBean.java:77)
... 37 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/stbook/yzweb/persistence/sqlmapdao/sql/Product.xml.
--- The error occurred while applying a result map.
--- Check the Product.productResult.
--- Check the result mapping for the 'createDate' property.
--- Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:154)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:99)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:341)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:326)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:77)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:54)
at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:192)
... 46 more
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at com.mysql.jdbc.ResultSet.getNativeTimestamp(ResultSet.java:3918)
at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:5561)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5219)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5257)
at com.ibatis.sqlmap.engine.type.DateTypeHandler.getResult(DateTypeHandler.java:28)
at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getPrimitiveResultMappingValue(BasicResultMap.java:345)
at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(BasicResultMap.java:118)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:278)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:127)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:174)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:142)
... 52 more
Caused by:
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor986.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.stbook.struts.BeanAction.execute(BeanAction.java:136)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:170)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:750)
Caused by: com.ibatis.dao.client.DaoException: Failed to queryForList - id [getProductListByCategory], parameterObject [{offset=0, sortType=productId, sortMode=desc, rows=30, categoryId=0141%}]. Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/stbook/yzweb/persistence/sqlmapdao/sql/Product.xml.
--- The error occurred while applying a result map.
--- Check the Product.productResult.
--- Check the result mapping for the 'createDate' property.
--- Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/stbook/yzweb/persistence/sqlmapdao/sql/Product.xml.
--- The error occurred while applying a result map.
--- Check the Product.productResult.
--- Check the result mapping for the 'createDate' property.
--- Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:194)
at com.stbook.yzweb.persistence.sqlmapdao.BaseSqlMapDao.queryForPager(BaseSqlMapDao.java:39)
at com.stbook.yzweb.persistence.sqlmapdao.ProductSqlMapDao.getProductListByCategory(ProductSqlMapDao.java:59)
at sun.reflect.GeneratedMethodAccessor215.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:61)
at com.sun.proxy.$Proxy14.getProductListByCategory(Unknown Source)
at com.stbook.yzweb.service.CatalogService.getProductListByCategory(CatalogService.java:171)
at com.stbook.yzweb.presentation.CatalogBean.viewCategory(CatalogBean.java:77)
... 37 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/stbook/yzweb/persistence/sqlmapdao/sql/Product.xml.
--- The error occurred while applying a result map.
--- Check the Product.productResult.
--- Check the result mapping for the 'createDate' property.
--- Cause: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:154)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:99)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:341)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:326)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:77)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:54)
at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:192)
... 46 more
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at com.mysql.jdbc.ResultSet.getNativeTimestamp(ResultSet.java:3918)
at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:5561)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5219)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5257)
at com.ibatis.sqlmap.engine.type.DateTypeHandler.getResult(DateTypeHandler.java:28)
at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getPrimitiveResultMappingValue(BasicResultMap.java:345)
at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(BasicResultMap.java:118)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:278)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:127)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:174)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:142)
... 52 more
|
|