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属性,所以就报以上错误,谨记!
分享到:
相关推荐
在ibatis日志信息中打印SQL语句的方法(个人总结)
ibatis16个常用sql语句
通过java程序查看ibatis配置文件中的sql语句(注:无法查看变量值)
ibatis 开发指南 和 iBATIS-SqlMaps两本图书
主要是关于oracle ibatis 的一些sql
webwork+ibatis+sqlserver2000完整实例
[iBATIS]sql转换工具 简单哦~ 项目组自己写的哦~分享给大家了
iBatis最全的动态SQL语句,你需要的都有,资源在于大家共享
ibatis2.0+sqlserver2005环境搭建
iBATIS-SqlMaps-2-Tutorial_cniBATIS-SqlMaps-2-Tutorial_cn.pdf.pdfiBATIS-SqlMaps-2-Tutorial_cn.pdfiBATIS-SqlMaps-2-Tutorial_cn.pdf
因为要下载其它的文件,所以从网站复制了一些其它的资源进行上传。但是这个资源是相当有用的。这里感谢之前总结相关技术的人员。谢谢
Java ibatis ext spring DWR SQL全套PDF 开发java学习资料
ibatis sql生成器 部署成web app 支持多数据库。
ibatis常用sql语句,简单易懂,方便查询,初学者宝典
iBATIS-SqlMaps2入门代码文档
ibatis常用的sql语句,很全的一篇文档。。。
动态sql拼接
ibatis sql 语句的编写 ,包括增删改查,很简单 很实用 ,对初学者是很好的选择
08_ibatis教程_sql主键生成方式.zip 08_ibatis教程_sql主键生成方式.zip
iBATIS-SqlMaps,ibatis映射文件