标签： ibatisIBATISiBatisJ2EEj2eejavaJavaJAVA
2012-06-04 12:25 5248人阅读 收藏 举报
在使用Ibatis时候经常会出现如下错误：
- 2012-05-30 18:50:56:INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
- 2012-05-30 18:50:56:INFO org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
- 2012-05-30 18:51:22:ERROR com.wpn.web.dao.Impl.UserBaseInfoDao - 分页查询用户的账户记录明细出错!
-
- org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
- --- The error occurred in com/wpn/web/dao/Impl/userBaseInfo.xml.
- --- The error occurred while applying a result map.
- --- Check the userBaseInfo.userOrderInfoMap.
- --- The error happened while setting a property on the result object.
- --- Cause: net.sf.cglib.beans.BulkBeanException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
- --- The error occurred in com/wpn/web/dao/Impl/userBaseInfo.xml.
- --- The error occurred while applying a result map.
- --- Check the userBaseInfo.userOrderInfoMap.
- --- The error happened while setting a property on the result object.
- --- Cause: net.sf.cglib.beans.BulkBeanException
- Caused by:
- com.ibatis.common.jdbc.exception.NestedSQLException:
- --- The error occurred in com/wpn/web/dao/Impl/userBaseInfo.xml.
- --- The error occurred while applying a result map.
- --- Check the userBaseInfo.userOrderInfoMap.
- --- The error happened while setting a property on the result object.
- --- Cause: net.sf.cglib.beans.BulkBeanException
- at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:204)
- at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
- at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
- at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:126)
- at org.springframework.orm.ibatis.SqlMapClientTemplate$4.doInSqlMapClient(SqlMapClientTemplate.java:285)
- at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:193)
- at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:219)
- at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:283)
- at com.wpn.web.dao.Impl.UserBaseInfoDao.queryOrderInfos(UserBaseInfoDao.java:746)
- at com.wpn.web.action.mytmq.QueryAccountLogsAction.processMessage(QueryAccountLogsAction.java:59)
- at com.wpn.web.servlet.MessageSrevlet.doPost(MessageSrevlet.java:66)
- at com.wpn.web.servlet.MessageSrevlet.doGet(MessageSrevlet.java:33)
- 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 com.wpn.web.filter.CharsetFilter.doFilter(CharsetFilter.java:46)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- at com.wpn.web.filter.XssFilter.doFilter(XssFilter.java:20)
- 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:128)
- 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:293)
- at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
- at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:574)
- at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527)
- at java.lang.Thread.run(Unknown Source)
- Caused by: net.sf.cglib.beans.BulkBeanException
- at com.wpn.web.domain.mytmq.UserOrderInfo
BulkBeanByCGLIB
62ede60c.setPropertyValues(<generated>) - at com.ibatis.sqlmap.engine.accessplan.EnhancedPropertyAccessPlan.setProperties(EnhancedPropertyAccessPlan.java:33)
- at com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:112)
- at com.ibatis.sqlmap.engine.mapping.result.ResultMap.setResultObjectValues(ResultMap.java:371)
- at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:64)
- at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:385)
- at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:300)
- at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:189)
- at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
- at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
- ... 31 more
- Caused by: java.lang.NullPointerException
- ... 41 more
是由于 在查询数据库 有些为number字段 为空了，在进行转换时候出现了异常。
附上默认值即可。
分类：
