ibatis uncategorized SQLException for SQL []SQL state [99999] error code [17026]

hehaibo

浏览: 416736 次
性别:
来自: 长沙

最近访客更多访客>>

sikewang

picc2

tairan_0729

xujiaolin

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

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属性，所以就报以上错误，谨记！

分享到：