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 clinton.begin@gmail.com
 designates 72.14.204.197 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references;
        b=pF9fGibwZi9EQjep8fhtfH46M2oHcPunXrcIt1+zF7iuW0qpYOyuDVDyrHrE4PWAFn1JMZkKml9AoGfKcl81JGJhlDdHxnbVUDoXpIaaG1CtOqC6++RAo0D1xmHI+TJy8Nv8KAlu8/WM88DWfmrKR7zIZGPY08jHpjM84003gqo=
Message-ID: <16178eb10509300922r14db2e4s23ba04c66ed9fb98@mail.gmail.com>
Date: Fri, 30 Sep 2005 10:22:24 -0600
From: Clinton Begin <clinton.begin@gmail.com>
Reply-To: Clinton Begin <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: Mapping 3 way join tables
In-Reply-To: <7169.216.239.124.38.1128037225.squirrel@webmail.sonic.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4293_18102470.1128097344298"
References: <7169.216.239.124.38.1128037225.squirrel@webmail.sonic.net>

------=_Part_4293_18102470.1128097344298
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Can you clarify the cardinality of the relationships between the A,B,C data
model, and also clarify the exact object graph you want to map it to?

I'm sure there's a way to derive it from the information you've provided,
but it's easier to just ask.

Clinton


On 9/29/05, reubenf@sonic.net <reubenf@sonic.net> wrote:
>
> Hello,
>
> I have tables A, B and C, which are related via table A_B_C:
>
> A:
> a_id
>
> B:
> b_id
>
> C:
> c_id
>
> A_B_C:
> a_id
> b_id
> c_id
>
> I have beans representing A, B & C, but I would like to avoid having a
> bean representing A_B_C. That is, A (the owner) would ideally have
> instances of B & C, ideally mapped in a hashmap as follows:
>
> {B -> C[]}
>
> How can I express this with resultMaps? Is it possible? It would seem to
> imply that I need a setter method:
>
> A#setBCRelationship(B b, C c)
>
> ...but this does not seem permissible with Ibatis. Anybody have a
> workaround?
>
> Thanks
> Reuben
>
>
>
>
>

------=_Part_4293_18102470.1128097344298
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br>Can you clarify the cardinality of the relationships between the
A,B,C data model, and also clarify the exact object graph you want to
map it to?<br>
<br>
I'm sure there's a way to derive it from the information you've provided, b=
ut it's easier to just ask.<br>
<br>
Clinton<br>
<br>
<br><div><span class=3D"gmail_quote">On 9/29/05, <b class=3D"gmail_senderna=
me"><a href=3D"mailto:reubenf@sonic.net">reubenf@sonic.net</a></b> &lt;<a h=
ref=3D"mailto:reubenf@sonic.net">reubenf@sonic.net</a>&gt; wrote:</span><bl=
ockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204=
, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br><br>I have tables A, B and C, which are related via table A_B_C:<=
br><br>A:<br>a_id<br><br>B:<br>b_id<br><br>C:<br>c_id<br><br>A_B_C:<br>a_id=
<br>b_id<br>c_id<br><br>I have beans representing A, B &amp; C, but I would=
 like to avoid having a
<br>bean representing A_B_C. That is, A (the owner) would ideally have<br>i=
nstances of B &amp; C, ideally mapped in a hashmap as follows:<br><br>{B -&=
gt; C[]}<br><br>How can I express this with resultMaps? Is it possible? It =
would seem to
<br>imply that I need a setter method:<br><br>A#setBCRelationship(B b, C c)=
<br><br>...but this does not seem permissible with Ibatis. Anybody have a w=
orkaround?<br><br>Thanks<br>Reuben<br><br><br><br><br></blockquote></div>
<br>

------=_Part_4293_18102470.1128097344298--