Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [99999]; error code [17026];
--- The error occurred in META-INF/ibatis/sqlmap/work/ads.xml.
--- The error occurred while applying a result map.
--- Check the ads.adsReleaseModelResultMap.
--- Check the result mapping for the 'crid' property.
--- Cause: java.sql.SQLException: 鏁板瓧婧㈠嚭; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in META-INF/ibatis/sqlmap/work/ads.xml.
--- The error occurred while applying a result map.
--- Check the ads.adsReleaseModelResultMap.
--- Check the result mapping for the 'crid' property.
--- Cause: java.sql.SQLException: 鏁板瓧婧㈠嚭
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
at com.hehaibo.dp.common.dao.impl.BaseDaoImpl.getList(BaseDaoImpl.java:25)
at com.hehaibo.dp.common.dao.impl.BaseDaoImpl.getPageList(BaseDaoImpl.java:138)
at com.hehaibo.dp.work.dao.impl.AdsProjectReleaseDaoImpl.getAdsReleaseList(AdsProjectReleaseDaoImpl.java:23)
at com.hehaibo.dp.work.service.impl.AdsProjectReleaseServiceImpl.getAdsReleaseList(AdsProjectReleaseServiceImpl.java:22)
at com.hehaibo.dp.work.service.impl.AdsProjectReleaseServiceImpl$$FastClassByCGLIB$$e75d5312.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.hehaibo.dragoon.patrol.spring.DragoonMethodInterceptor.invoke(DragoonMethodInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.hehaibo.dp.work.service.impl.AdsProjectReleaseServiceImpl$$EnhancerByCGLIB$$d9158b66.getAdsReleaseList(<generated>)
at com.hehaibo.dp.web.work.module.action.AdsReleaseAction.doGetPagingAdsRelease(AdsReleaseAction.java:48)
at com.hehaibo.dp.web.work.module.action.AdsReleaseAction$$FastClassByCGLIB$$31759683.invoke(<generated>)
at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
at com.hehaibo.citrus.service.moduleloader.impl.adapter.MethodInvoker.invoke(MethodInvoker.java:72)
at com.hehaibo.citrus.service.moduleloader.impl.adapter.ActionEventAdapter.execute(ActionEventAdapter.java:105)
... 54 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
错误的原因是crid 属性在类中定义的是int类型,但是数据库是NUMBER类型,超过了int类型的范围,所以ibatis不能赋值给crid属性,所以就报以上错误,谨记!