Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of contactme42@gmail.com designates
 64.233.162.204 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding;
        b=XxVUmP09w58AhZiWyroCkO22s7apDoim5kRVJyHNTw8Vr+Hp6CgBX83nZRp8cFF6Rg6WDtvUG5keCG6IU3QgKJdiNw7P9cE/PIqqhwtpft0PzdSweS4aK/mAt13YjkmmavkvlCptMbP4FXxvzmSq+9vCviWrKIyK2VlaGSqv/Lk=
Message-ID: <437DC7C3.4030406@gmail.com>
Date: Fri, 18 Nov 2005 23:23:31 +1100
From: Medium <contactme42@gmail.com>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: Reusing resultmap for nested object
References: <437ABEBA.3060506@gmail.com>
	 <f3534c960511160901q7cb64cd8o12ded677d160f97c@mail.gmail.com>
	 <437C657B.6070703@gmail.com>
 <c593b8750511170959w133e8664off50eb1f58185e76@mail.gmail.com>
In-Reply-To: <c593b8750511170959w133e8664off50eb1f58185e76@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Jeff,

Thanks for the clarification. I have filed a jira request (IBATIS-225)

Anyone who may find this useful, please vote for it.

Huy

Jeff Butler wrote:

> I believe this is because reusing result maps is a feature of the 
> "groupBy" function, and iBATIS assumes the property will be a 
> Collection of some kind.  So, the real answer is that you can reuse 
> result maps if your properties are collections.  Otherwise not.
>  
> I'm not sure if this is an oversight or "by design" - but it probably 
> should be fixed/enhanced.  You could file a JIRA request to help us 
> remember.
>  
> Jeff Butler
>  
> On 11/17/05, *Medium* <contactme42@gmail.com 
> <mailto:contactme42@gmail.com>> wrote:
>
>     I tried this, but get the following error. I am using the java version
>     2.1.6.589 (Sorry about the long trace). Hoping someone can shed some
>     light on this.
>
>     Thanks.
>
>     Huy
>
>
>     My map is below:
>
>
>     <sqlMap namespace="Pick">
>     <resultMap id="pickResultMap" class="package.domain.Pick">
>        <result column="pick_id" property="pickId"/>
>        <result column="pick_ref" property="pickRef"/>
>     </resultMap>
>     <resultMap id="pickJoined" class="package.domain.Pick"
>     extends="pickResultMap">
>        <result property="sale" resultMap="Sale.Sale"/>
>     </resultMap>
>     </sqlMap>
>
>     <sqlMap namespace="Sale">
>     <typeAlias alias="Sale" type=" openlink.domain.Sale"/>
>     <resultMap id="Sale" class="Sale">
>        <result column="sale_id" property="saleId"/>
>     </resultMap>
>     </sqlMap>
>
>     org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient
>     operation): encountered SQLException [
>     --- The error occurred in openlink/dao/ibatis/maps/Pick.xml.
>     --- The error occurred while applying a result map.
>     --- Check the Pick.pickJoined.
>     --- The error happened while setting a property on the result object.
>     --- Cause: com.ibatis.sqlmap.client.SqlMapException: Error
>     instantiating
>     collection property for mapping 'sale'.  Cause:
>     java.lang.ClassCastException
>     Caused by: java.lang.ClassCastException]; nested exception is
>     com.ibatis.common.jdbc.exception.NestedSQLException:
>     --- The error occurred in openlink/dao/ibatis/maps/Pick.xml.
>     --- The error occurred while applying a result map.
>     --- Check the Pick.pickJoined.
>     --- The error happened while setting a property on the result object.
>     --- Cause: com.ibatis.sqlmap.client.SqlMapException: Error
>     instantiating
>     collection property for mapping 'sale'.  Cause:
>     java.lang.ClassCastException
>     Caused by: java.lang.ClassCastException
>     com.ibatis.common.jdbc.exception.NestedSQLException:
>     --- The error occurred in openlink/dao/ibatis/maps/Pick.xml.
>     --- The error occurred while applying a result map.
>     --- Check the Pick.pickJoined.
>     --- The error happened while setting a property on the result object.
>     --- Cause: com.ibatis.sqlmap.client.SqlMapException: Error
>     instantiating
>     collection property for mapping 'sale'.  Cause:
>     java.lang.ClassCastException
>     Caused by: java.lang.ClassCastException
>     Caused by: com.ibatis.sqlmap.client.SqlMapException: Error
>     instantiating
>     collection property for mapping 'sale'.  Cause:
>     java.lang.ClassCastException
>     Caused by: java.lang.ClassCastException
>        at
>     com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188)
>        at
>
>
>
>     Gilles Bayon wrote:
>
>     > This syntax
>     > <resultMap id="product">
>     > <result property="id" column="PRD_ID"/>
>     > <result property="description" column="PRD_DESCRIPTION"/>
>     > <result property="category" resultMap="category">
>     > </resultMap>
>     >
>     > is supported .
>     >
>     >
>     > On 11/16/05, *Medium* < contactme42@gmail.com
>     <mailto:contactme42@gmail.com>
>     > <mailto:contactme42@gmail.com <mailto:contactme42@gmail.com>>>
>     wrote:
>     >
>     >     Hi,
>     >
>     >     Is there a way to reuse a resultmap for a nested object ?
>     >
>     >     I know how to map it as specified by the docs but its
>     getting a bit
>     >     unwieldly with all the repetition.
>     >
>     >     Docs:
>     >     <resultMap>
>     >     <result property="id" column="PRD_ID"/>
>     >     <result property="description" column="PRD_DESCRIPTION"/>
>     >     <result property="category.id <http://category.id>"
>     column="CAT_ID" />
>     >     <result property="category.description"
>     column="CAT_DESCRIPTION" />
>     >     </resultMap>
>     >
>     >     Goal:
>     >     <resultMap id="product">
>     >     <result property="id" column="PRD_ID"/>
>     >     <result property="description" column="PRD_DESCRIPTION"/>
>     >     <result property="category" resultMap="category">
>     >     </resultMap>
>     >
>     >     <resultMap id="category">
>     >     <result property="id" column="CAT_ID"/>
>     >     <result property="description" column="CAT_DESCRIPTION"/>
>     >     </resultMap>
>     >
>     >     Any help would be greatly appreciated. A simple yah or nah would
>     >     do fine
>     >     as well.
>     >
>     >     Thanks
>     >
>     >     Huy
>     >
>     >
>
>