Return-Path: 
 <user-java-return-18802-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 9757 invoked from network); 23 Feb 2010 03:59:33 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 23 Feb 2010 03:59:33 -0000
Received: (qmail 56183 invoked by uid 500); 23 Feb 2010 03:59:32 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 56103 invoked by uid 500); 23 Feb 2010 03:59:32 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 56095 invoked by uid 99); 23 Feb 2010 03:59:32 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Feb 2010 03:59:32 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of guyr-ml1@burntmail.com
 designates 70.87.63.122 as permitted sender)
Received: from [70.87.63.122] (HELO mx02.burntmail.com) (70.87.63.122)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Feb 2010 03:59:24 +0000
Received: from pool-96-241-216-77.washdc.fios.verizon.net ([96.241.216.77]
 helo=[127.0.0.1])
	by mx02.burntmail.com with esmtpa (Exim 4.63)
	(envelope-from <guyr-ml1@burntmail.com>)
	id 1NjlvL-0002kD-UH
	for user-java@ibatis.apache.org; Mon, 22 Feb 2010 21:59:04 -0600
Message-ID: <4B835284.1020407@burntmail.com>
Date: Mon, 22 Feb 2010 22:59:00 -0500
From: Guy Rouillier <guyr-ml1@burntmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: performance issue for id as association
References: <4B804443.8000801@centrum.cz> <4B807852.8010106@burntmail.com>
 <4B8115ED.7020500@centrum.cz> <4B822260.2010306@burntmail.com>
 <4B8233BF.20306@centrum.cz>
In-Reply-To: <4B8233BF.20306@centrum.cz>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 100222-1, 02/22/2010), Outbound message
X-Antivirus-Status: Clean

On 2/22/2010 2:35 AM, Jakub Vondrak wrote:

>> The separate BillItemId class is unnecessary.
>>
> Yes it is unnecessary for iBatis. The reason why this class exists is
> that the model was created to suite Hibernate several years ago.
>
> I'm trying to convert data layer to iBatis and retain a compatible
> model. Then I would like to compare performance and ease of use.

Ok, this works:

<resultMap id="BillItemNestedMap" type="com.ibatisdemo.db.Bill" >
     <id column="bill_id" property="id" jdbcType="INTEGER" />
     <collection column="bi_item_order" property="billItems" 
javaType="ArrayList" ofType="com.ibatisdemo.db.BillItem">
        <id column="bill_id" property="idBill" jdbcType="INTEGER" />
        <id column="bi_item_order" property="itemOrder" 
jdbcType="INTEGER" />
        <result column="bi_sku" property="sku" jdbcType="VARCHAR" />
        <result column="bi_name" property="name" jdbcType="VARCHAR" />
        <association column="bi_item_order" property="billItemKey" 
javaType="com.ibatisdemo.db.BillItemKey">
           <id column="bill_id" property="idBill"/>
           <id column="bi_item_order" property="itemOrder" />
        </association>
     </collection>
</resultMap>


The two columns from BillItemKey are also in BillItem because I used 
Ibator to generate the classes.

-- 
Guy Rouillier

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org