Well put, I couldn't agree more: http://opensource.atlassian.com/confluence/oss/display/IBATIS/Frequently+Asked+Questions
Thanks in advance! :-) Larry On 10/20/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
This should be in the docs. I wasn't sure if it was supported, so I tried it and it worked. Because it's not obvious that multiple groupBy attributes will work, it should be documented. -----Original Message----- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 6:21 AM To: user-java@ibatis.apache.org Subject: Re: Multiple Joins This really isn't that difficult. Join your three tables in the query, then do a groupBy on the nested result maps. Have you tried it? <resultMap id="t1" class="T1Class" groupBy="t1key"> ... <result column="t2Objects" resultMap="t2"/> </resultMap> <resultMap id="t2" class="T2Class" groupBy="t2key"> ... <result column="t3Objects" resultMap="t3"/> </resultMap> <resultMap id="t3" class="T3Class"> ... </resultMap> You can carry this on for as many tables as you need. Jeff Butler On 10/20/06, soussou97 <[EMAIL PROTECTED]> wrote: > > Hi Larry; > > I see already this example it shows a simple example with only one join but > a multiple Joins (with for example 3 tables : T1 => 1..* T2 => 1..*T3). > > > Larry Meadors-2 wrote: > > > > Try: > > > > http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem > > > > - or (same page, shorter link) - > > > > http://tinyurl.com/ydbn4c > > > > Also, please spend some time looking at the WIKI, almost every new > > user question is covered there. > > > > Larry > > > > > > On 10/19/06, soussou97 <[EMAIL PROTECTED]> wrote: > >> > >> Hi; > >> > >> I Search an example of code source with mutltiple joins implying lists : > >> > >> T1 => 1..*T2 => 1..*T3 => 1..1 T4 or any exemple with several tables and > >> java beans and list of objects. > >> > >> Regards; > >> -- > >> View this message in context: > >> http://www.nabble.com/Multiple-Joins-tf2472615.html#a6894554 > >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >> > >> > > > > > > -- > View this message in context: http://www.nabble.com/Multiple-Joins-tf2472615.html#a6911430 > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >
