ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From soussou97 <dbousse...@yahoo.fr>
Subject Re: Multiple Joins
Date Fri, 10 Nov 2006 11:44:37 GMT

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<Product> prodList;

Category with properties
Integer catid;
String catname;

Product with properties
Integer prodid;
String prodname;

whereas the standard implementation is :

Category with properties
Integer catid;
String catname;
List<Product> prodList;

Product with properties
Integer prodid;
String prodname;

I am obliged to add the javabean below to fetch in the base ?

CategorisedProductList with properties
Category cat;
List<Product> prodList;

I think that it is heavy ! there are not other solutions more flexible ?

regards







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 <dboussebha@yahoo.fr> 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#a7275428
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message