ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: N+1 with a twist?
Date Fri, 11 Feb 2005 19:50:05 GMT
How about 3 levels deep?

A from request
	List of B from products
	List of C from approvals
		User object from users (where user's id maps to a column in the 
approvals table)


Nathan

On Feb 9, 2005, at 10:30 AM, Clinton Begin wrote:

> If you can join the data into a single resultset with repeating
> groups, the N+1 solution will work, no matter how the collections are
> arranged.
>
> As long as you group by some column in table_a, you can separately map
> 2 collections on the same class.
>
> This will work.
>
> Try it out!
>
> Clinton
>
> On Wed, 09 Feb 2005 10:21:54 -0700, Nathan Maves 
> <Nathan.Maves@sun.com> wrote:
>> I dont think that the current implementation will work for this but I
>> was looking for some best practices on how to do it.
>>
>> Parent Class A has n number of List properties that all come for their
>> own tables.
>>
>> A from table_a
>>         List of B from table_b
>>         List of C from table_c
>>         .
>>         .
>>         .
>>
>>
>> Nathan
>>
>>


Mime
View raw message