I am not sure what you are asking.
A bean like this would work fine:
Integer catid;
String catname;
List prodList;
Larry
On 11/10/06, soussou97 <[EMAIL PROTECTED]> wrote:
Hi Larry;
I would like to come back on this subject.
The solution that you propose need to change the javabean as in th
Hi Larry;
I would like to come back on this subject.
The solution that you propose need to change the javabean as in the link :
CategorisedProductList with properties
Category cat;
List prodList;
Category with properties
Integer catid;
String catname;
Product with properties
Integer prodid;
St
Hi Jeff;
How define the javabean CategorisedProductList with two composite objects :
Java Beans:
CollectionCategory with properties
Integer colid;
String colname;
Category with properties
Integer catid;
String catname;
Product with properties
Integer prodid;
String prodname;
CollectionCateg
o 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 Join
r 20, 2006 6:21
AMTo: user-java@ibatis.apache.orgSubject: 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?
...
...
...
You
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?
...
...
...
You can carry this on for as many tables as you need.
Jeff Butler
On 10/20/06, soussou97 <[EMAIL PROTECTED]> wrote:
Hi Lar
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+sel
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
