Return-Path: 
 <user-java-return-5541-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 90841 invoked from network); 14 Jan 2006 14:41:40 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 14 Jan 2006 14:41:40 -0000
Received: (qmail 56317 invoked by uid 500); 14 Jan 2006 14:41:38 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 56302 invoked by uid 500); 14 Jan 2006 14:41:37 -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 56291 invoked by uid 99); 14 Jan 2006 14:41:37 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 14 Jan 2006 06:41:37 -0800
X-ASF-Spam-Status: No, hits=1.3 required=10.0
	tests=RCVD_NUMERIC_HELO
X-Spam-Check-By: apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
Received: from [66.171.59.140] (HELO smtp.vzavenue.net) (66.171.59.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 14 Jan 2006 06:41:36 -0800
Received: from 131.227.171.66.subscriber.vzavenue.net (HELO [66.171.227.131])
 ([66.171.227.131])
  by smtp.vzavenue.net with ESMTP; 14 Jan 2006 09:41:15 -0500
X-REPUTATION: None
X-REMOTE-IP: 66.171.227.131
X-BrightmailFiltered: true
X-Brightmail-Tracker: AAAAAA==
X-IronPort-AV: i="3.99,367,1131339600";
   d="scan'208"; a="2725654:sNHT14732343"
Message-ID: <43C90D89.50702@laposte.net>
Date: Sat, 14 Jan 2006 09:41:13 -0500
From: Yannick Le Teigner <yannick.leteigner@laposte.net>
User-Agent: Thunderbird 1.5 (X11/20051201)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: ResultMap, N+1
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi,

I have a problem with a resultMap.

My iBatis is:

  <resultMap id="subcategoriesMap" class="Subcategory" groupBy="id">
    <result property="id" column="id" />
    <result property="categoryId" column="cid" />
    <result property="category" column="cname" />
    <result property="name" column="sname" />
    <result property="acc" resultMap="Billing.account"/>
  </resultMap>

  <resultMap id="account" class="LedgerAccount">
    <result property="id" column="aid"/>
    <result property="name" column="aname"/>
    <result property="number" column="anumber"/>
  </resultMap>

  <select id="getLedgerAccountSubcategories" resultMap="subcategoriesMap">
    SELECT ledger_account_subcategories.id as id, 
ledger_account_categories.id as cid, ledger_account_categories.name as 
cname, ledger_account_subcategories.name as sname, ledger_accounts.id as 
aid, ledger_accounts.name as aname, ledger_accounts.number as anumber
    FROM ledger_account_subcategories
    LEFT JOIN ledger_account_categories ON 
category_id=ledger_account_categories.id
    LEFT JOIN ledger_accounts_to_subcategories ON 
ledger_account_subcategories.id=subcategory_id
    LEFT JOIN ledger_accounts ON account_id=ledger_accounts.id;
  </select>

The query returns below results:

 id | cid |         cname          |    sname    | aid |          
aname           | anumber
----+-----+------------------------+-------------+-----+--------------------------+---------
  2 |   4 | Produits Exeptionnels  | Subventions |  12 | Cpte Associ� - 
C. PERRIN |   45614
  2 |   4 | Produits Exeptionnels  | Subventions |  22 | Cpte 
MCC                 |   41101
  3 |   3 | Charges Financi�res    | Taxes       |     
|                          |       
  4 |   1 | Revenues               | Ventes      |     
|                          |       
  5 |   2 | Charges d'Exploitation | Lab         |     
|                          |       


The problem is that the main object (Subcategory) gets correctly created 
(4 times), and that the LedgerAccount "sub-object" gets also correctly 
created for Subcategory #1 (with id=2), but it does not get associated 
with its parent Subcategory.

Here are some traces:

Subcategory Constructor
id = 2
setAcc: null
setAcc: []
  new account
  new account

Subcategory Constructor
id = 3
setAcc: null
setAcc: []

Subcategory Constructor
id = 4
setAcc: null
setAcc: []

Subcategory Constructor
id = 5
setAcc: null
setAcc: []


You can see that for each object is created correctly, but that the 
LedgerAccount created for the 1st object is created -after- the call to 
Subcategory.setAcc(), and does not get associated with it.
acc is defined as a List in Subcategory.


Thanks for any help!
Yannick