求解决，ibatis级联查询异常，求解决，哪里配置错了吗？？（已经解决）

最新推荐文章于 2021-02-25 17:09:10 发布
最新推荐文章于 2021-02-25 17:09:10 发布
阅读量2k 收藏
点赞数 2
文章标签： ibatis integer date apache include nested
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xiangjiang1105/article/details/7398804
版权 

这是主表 xiuCentItem
<sqlMap namespace="XIU_CENT_ITEM" >
	<resultMap id="ibatorgenerated_BaseResultMap" class="com.pltfm.index.model.XiuCentItem">
		<!-- WARNING - This element is automatically generated by Apache iBATIS 
			ibator, do not modify. This element was generated on Wed Mar 21 19:47:05 
			CST 2012. -->
		<result column="CENT_ITEM_ID" property="centItemId" jdbcType="INTEGER" />
		<result column="ITEM_ID" property="itemId" jdbcType="INTEGER" />
		<result column="PARTNUMBER" property="partnumber" jdbcType="VARCHAR" />
		<result column="ITEM_NAME" property="itemName" jdbcType="VARCHAR" />
		<result column="ITEM_NAME_PRE" property="itemNamePre" jdbcType="VARCHAR" />
		<result column="ITEM_NAME_POST" property="itemNamePost"
			jdbcType="VARCHAR" />
		<result column="TAG_NAME" property="tagName" jdbcType="VARCHAR" />
		<result column="IMG_URL_TIME" property="imgUrlTime" jdbcType="VARCHAR" />
		<result column="BRAND_ID" property="brandId" jdbcType="INTEGER" />
		<result column="BRAND_NAME" property="brandName" jdbcType="VARCHAR" />
		<result column="BRAND_NAME_EN" property="brandNameEn" jdbcType="VARCHAR" />
		<result column="DESC_SHORT" property="descShort" jdbcType="VARCHAR" />
		<result column="STATE_ONSALE" property="stateOnsale" jdbcType="CHAR" />
		<result column="STATE_OFFSHOW" property="stateOffshow"
			jdbcType="CHAR" />
		<result column="ONSALE_TIME" property="onsaleTime" jdbcType="DATE" />
		<result column="FLAG_INSTMT" property="flagInstmt" jdbcType="CHAR" />
		<result column="AUTHOR" property="author" jdbcType="VARCHAR" />
		<result column="FLAG_GLOABL" property="flagGloabl" jdbcType="CHAR" />
		<result column="RMARK" property="rmark" jdbcType="VARCHAR" />
		<result column="ITEM_UPDATE_TIME" property="itemUpdateTime"
			jdbcType="DATE" />
		<result column="IMG_URL_SKU" property="imgUrlSku" jdbcType="VARCHAR" />
		<result column="DATA_STATE" property="dataState" jdbcType="CHAR" />
		<result column="CREATE_TIME" property="createTime" jdbcType="DATE" />
		<result column="UPDATE_TIME" property="updateTime" jdbcType="DATE" />
		<result column="ITEM_COLOR" property="itemColor" jdbcType="VARCHAR" />
		<result column="ITEM_SIZE" property="itemSize" jdbcType="VARCHAR" />
		<result column="ITEM_LIMIT" property="itemLimit" jdbcType="INTEGER" />
		<result column="SALE_PRE_START" property="salePreStart"
			jdbcType="DATE" />
		<result column="SALE_PRE_END" property="salePreEnd" jdbcType="DATE" />
		<result column="SALE_PRE_RECEIVE" property="salePreReceive"
			jdbcType="DATE" />
		<result column="SALE_LIMIT_START" property="saleLimitStart"
			jdbcType="DATE" />
		<result column="SALE_LIMIT_END" property="saleLimitEnd"
			jdbcType="DATE" />
		<result column="IMG_URL_VERSION" property="imgUrlVersion"
			jdbcType="VARCHAR" />
		<result column="PRODUCT_AREA" property="productArea" jdbcType="VARCHAR" />
		<result column="OFFSALE_TIME" property="offsaleTime" jdbcType="DATE" />
	</resultMap>
	<resultMap id="ibatorgenerated_DetailResultMap" extends="ibatorgenerated_BaseResultMap" class="com.pltfm.index.model.XiuCentItem">
		<!--result column="ITEM_ID" property="xiuCentPrice" jdbcType="INTEGER" resultMap="XIU_CENT_PRICE.ibatorgenerated_BaseResultMap"
               select="XIU_CENT_PRICE.ibatorgenerated_selectXiuCentPriceListByItemId"/-->
         <result column="ITEM_ID" property="xiuCentPrice"  select="XIU_CENT_PRICE.ibatorgenerated_selectXiuCentPriceListByItemId"/>
         <result column="ITEM_ID" property="xiuCentClass"  select="XIU_CENT_CLASS.ibatorgenerated_selectXiuCentClassListByItemId"/>
         <result column="ITEM_ID" property="xiuCentAttrList"  select="XIU_CENT_ATTR.ibatorgenerated_selectXiuCentAttrListByItemId"/> </resultMap>
 <select id="searchPageByVo" parameterClass="com.pltfm.index.model.XiuCentItem"
        resultMap="ibatorgenerated_DetailResultMap">
        SELECT
        <include refid="ibatorgenerated_column_name" />
        ,x_so_saletotal
        FROM (
        select
        ROW_NUMBER() OVER(order by CENT_ITEM_ID
        desc) as
        view_row_number,
        tt.* ,xspw.x_so_saletotal from
        XIU_CENT_ITEM tt
        left join x_so_productsale_week xspw on
        tt.partnumber=xspw.x_so_proceductid
        <dynamic prepend="where">
            <include refid="ibatorgenerated_select_column_where_selective" />
        </dynamic>
        ) WHERE view_row_number between #skip# and #max#
    </select>
    <!-- 手动添加 -->
</sqlMap>

这是字表 

<sqlMap namespace="XIU_CENT_PRICE" >
  <resultMap id="ibatorgenerated_BaseResultMap" class="com.pltfm.index.model.XiuCentPrice" >
    <!--
      WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
      This element was generated on Wed Mar 21 19:47:05 CST 2012.
    -->
    <result column="CENT_PRICE_ID" property="centPriceId" jdbcType="INTEGER" />
    <result column="ITEM_ID" property="itemId" jdbcType="INTEGER" />
    <result column="PARTNUMBER" property="partnumber" jdbcType="VARCHAR" />
    <result column="PRICE_XIU" property="priceXiu" jdbcType="INTEGER" />
    <result column="PRICE_MKT" property="priceMkt" jdbcType="INTEGER" />
    <result column="PRICE_ACTIVITY" property="priceActivity" jdbcType="INTEGER" />
    <result column="TYPE_ACTIVITY" property="typeActivity" jdbcType="CHAR" />
    <result column="DATA_STATE" property="dataState" jdbcType="CHAR" />
    <result column="CREATE_TIME" property="createTime" jdbcType="DATE" />
    <result column="UPDATE_TIME" property="updateTime" jdbcType="DATE" />
  </resultMap>
    <select id="ibatorgenerated_selectXiuCentPriceListByItemId" parameterClass="java.lang.Integer"  resultMap="ibatorgenerated_BaseResultMap">
    select 
        <include refid="ibatorgenerated_column_name"  />
        from XIU_CENT_PRICE
        where ITEM_ID = #value# and rownum=1
    </select>
</sqlMap>



	public class XiuCentItem implements Serializable {
    /**
     * This field was generated by Apache iBATIS ibator. This field corresponds
     * to the database column XIU_CENT_ITEM.CENT_ITEM_ID
     * 
     * @ibatorgenerated Wed Mar 21 19:47:05 CST 2012
     */
    private Integer centItemId;

    /**
     * This field was generated by Apache iBATIS ibator. This field corresponds
     * to the database column XIU_CENT_ITEM.ITEM_ID
     * 
     * @ibatorgenerated Wed Mar 21 19:47:05 CST 2012
     */
    private Integer itemId;


        private List<XiuCentAttr> xiuCentAttrList = new ArrayList<XiuCentAttr>();
	private XiuCentClass xiuCentClass;
	private XiuCentPrice xiuCentPrice;
	private XiuCentItem xiuCentItem;

虽然去掉  
resultMap="XIU_CENT_PRICE.ibatorgenerated_BaseResultMap"

不会报异常，但是取得的xiuCentPrice 对象中的属性为空

还是要去掉那个

<result column="ITEM_ID" property="xiuCentPrice" jdbcType="INTEGER" resultMap="XIU_CENT_PRICE.ibatorgenerated_BaseResultMap"  select="XIU_CENT_PRICE.ibatorgenerated_selectXiuCentPriceListByItemId"/> 中的这个

resultMap="XIU_CENT_PRICE.ibatorgenerated_BaseResultMap"


 

 <sqlMap namespace="XIU_CENT_ATTR" >
  <resultMap id="ibatorgenerated_BaseResultMap" class="com.pltfm.index.model.XiuCentAttr" >
    <!--
      WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
      This element was generated on Wed Mar 21 19:47:05 CST 2012.
    -->
    <result column="CENT_ATTR_ID" property="centAttrId" jdbcType="INTEGER" />
    <result column="ITEM_ID" property="itemId" jdbcType="INTEGER" />
    <result column="ATTR_ID" property="attrId" jdbcType="INTEGER" />
    <result column="ATTR_NAME" property="attrName" jdbcType="VARCHAR" />
    <result column="ATTR_VALUE" property="attrValue" jdbcType="VARCHAR" />
    <result column="PARTNUMBER" property="partnumber" jdbcType="VARCHAR" />
    <result column="DATA_STATE" property="dataState" jdbcType="CHAR" />
    <result column="CREATE_TIME" property="createTime" jdbcType="DATE" />
    <result column="UPDATE_TIME" property="updateTime" jdbcType="DATE" />
  </resultMap>
<select id="ibatorgenerated_selectXiuCentAttrListByItemId" resultMap="ibatorgenerated_BaseResultMap"
		parameterClass="java.lang.Integer">
		select
		<include refid="ibatorgenerated_column_name" />
		from XIU_CENT_ATTR
		where ITEM_ID = #value#
	</select>
</sqlMap>



Cause: com.ibatis.sqlmap.client.SqlMapException: Error getting nested result map values for 'xiuCentPrice'.  Cause: java.sql.SQLException: 列名无效

    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.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
    at com.pltfm.index.dao.XiuCentItemDAOImpl.selectPageByVo(XiuCentItemDAOImpl.java:190)
    at com.pltfm.index.manager.XiuCentItemManager.searchXiuCentItemDetailByVO(XiuCentItemManager.java:57)
    at com.pltfm.index.service.XiuCentItemService.searchXiuCentItemDetailByVO(XiuCentItemService.java:42)
    at com.pltm.index.service.XiuCentItemServerTest.testSearchXiuCentItemDetailByVO(XiuCentItemServerTest.java:88)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
    at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:49)
    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: com.ibatis.sqlmap.client.SqlMapException: Error getting nested result map values for 'xiuCentPrice'.  Cause: java.sql.SQLException: 列名无效
    at com.ibatis.sqlmap.engine.mapping.result.ResultMap.setNestedResultMappingValue(ResultMap.java:467)
    at com.ibatis.sqlmap.engine.mapping.result.ResultMap.applyNestedResultMap(ResultMap.java:395)
    at com.ibatis.sqlmap.engine.mapping.result.ResultMap.setResultObjectValues(ResultMap.java:380)
    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)
    ... 33 more
Caused by: java.sql.SQLException: 列名无效
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
    at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3319)
    at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1926)
    at oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java:1563)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.ibatis.common.jdbc.logging.ResultSetLogProxy.invoke(ResultSetLogProxy.java:47)
    at $Proxy8.getInt(Unknown Source)
    at com.ibatis.sqlmap.engine.type.IntegerTypeHandler.getResult(IntegerTypeHandler.java:35)
    at com.ibatis.sqlmap.engine.mapping.result.ResultMap.getPrimitiveResultMappingValue(ResultMap.java:619)
    at com.ibatis.sqlmap.engine.mapping.result.ResultMap.getResults(ResultMap.java:345)
    at com.ibatis.sqlmap.engine.mapping.result.ResultMap.setNestedResultMappingValue(ResultMap.java:454)
    ... 41 more
xiangjiang1105
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mybatis错误解析mapper.xml注释错误分析
weixin_39265427的博客
05-14 1666
先上错误日志 Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: — The error occurred in com/imodule/product/dao/sqlmap/test.xml. — The error occurred while applying a parameter map. — Check the claimcalc.sfCalcTerminalDpst-InlineParameterMap. — Che
ibatis执行动态sql报错
Howard6的博客
12-14 1001
com.ibatis.common.jdbc.exception.NestedSQLException:    --- The error occurred in com/ictehi/grainplat/sqlMap/sainout.xml.   --- The error occurred while applying a result map.   --- Check the find
ibatis执行过程
luozirong的专栏
07-31 596
1.初始化SqlMapClient对象，主要设置DataSource，读取ibatis的xml配置文件将里面的信息转化为一个个数据对象 2.调用SqlMapClientTemplate的对应的方法比如queryForObject 3.调用SqlMapSessionImpl().queryForObject()方法 4.调用 SqlMapExecutorDelegate的queryForObj
MySQL 事务RUNNING状态引发的Transaction timed out: deadline问题
热门推荐
csdn's blog
06-30 2万+
前言： 朋友说简单的查询导致Transaction timed out: deadline问题，怀疑是数据库表锁了，1，应用故障描述Deadline问题： --- The error occurred in META-INF/ibatis/ITEM_sqlmap.xml. --- The error occurred while executing query. --- Check...
postgres修改字段错误：cached plan must not change result type
seashoreliu的专栏
08-18 9171
--数据库错误日志  2013-07-24 15:11:35.895 CST,"db_test","db_test",17526,"192.168.100.221:40188",51ed7b10.4476,1555,"BIND",2013-07-23 02:33:52 CST,236/820620,0,ERROR,0A000,"cached plan must not cha
iBATIS 级联iBATIS 级联
08-25
iBATIS 级联iBATIS 级联iBATIS 级联
Mybatis报错: org.apache.ibatis.exceptions.PersistenceException解决办法
09-09
在使用Mybatis框架时，你可能会遇到`org.apache.ibatis.exceptions.PersistenceException`这样的异常。这个异常通常表示在执行数据库查询操作时遇到了问题。本篇将详细分析这个问题并提供解决方法。 ### 问题概述 ...
通过ibatis解决sql注入问题
08-29
iBatis解决SQL注入问题 iBatis是一个流行的持久层框架，广泛应用于Java企业级开发中。然而，在使用iBatis时，开发人员经常面临着SQL注入问题。SQL注入是一种常见的安全威胁，可能会导致数据泄露、数据篡改、系统...
在Spring使用iBatis及配置讲解
08-26
SqlMapClientTemplate 是 Spring 解决 iBatis 会话管理和异常处理问题的方案，它包裹了一个 SqlMapClient 来透明的打开和关闭会话，还捕获抛出的 SQLException。 要想在程序里使用 SqlMapClientTemplate，需要在 ...
java恶心_一个恶心的错误
weixin_39696665的博客
02-25 119
com.ibatis.common.jdbc.exception.NestedSQLException:--- The error occurred in ./map/Guest.xml.--- The error occurred while applying a result map.--- Check the Guest.listGuest.--- Check the result mapp...
ibatis一个很不灵活的地方
SAN_YUN的专栏
08-23 159
最近一直都不爽ibtais，用起来一点都不敏捷。今天发现一处非常不灵活的地方。比如一个DO我有两条SQL，其中一条SQL比另外一条SQL多一个last_like_datetime。我想共用一个resultMap居然会报错：   &lt;resultMap id="RM-ALBUM" class="TA-ALBUM"&gt; &lt;result property=...
ibatis源码学习(三)参数和结果的映射原理
自由的天空
03-18 231
在[url=http://learnworld.iteye.com/blog/1447284]ibatis整体设计和核心流程[/url]一文中，我们提到了ibatis框架中sql的执行过程，sql执行前后有两个重要步骤: 参数对象映射到sql执行参数，sql执行结果映射到结果对象。本文将深入分析ibatis框架中参数和结果的映射原理。 [size=medium][b]问题[/...
ibatis查询异常记录
点滴
08-12 795
查询列表时报如下异常
ibatis的错误及解决办法
haiyan2012的专栏
04-24 1万+
异常1： The content of element type "sqlMapConfig" is incomplete, it must match "(properties?,settings?,typeAlias*,typeHandler*,transactionManager?,sqlMap+)+". 解析： （1）The content of element type “sqlM
如何解决Mybatis报错org.apache.ibatis.exceptions.PersistenceException？
最新发布
12-29
根据提供的引用内容，解决Mybatis报错org.apache.ibatis.exceptions.PersistenceException的方法如下： 1. 检查配置文件：首先，确保你的Mybatis配置文件正确无误。检查是否存在语法错误、路径错误或其他配置错误。...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值