Group By for one Parent and many Child types.

[Baskar Viswanathan]

I m new to Ibatis.

I m having trouble with building a map with Ibatis using group by.

If the relation is like 
GrandParent
        Parent
                   Child 

It works fine..Since I group by GrandParent and Parent.


If the relation is like..
Parent
        Child list1(a1, a2)
        Child list2(b1,b2)
        Child list3(c1,c2,c3)

If I group by Parent and all child lists, only one child list is grouped and 
the rest is not.
So it creates a cartisian product.

Then the AUTO mapping doesn't work. I might have to manually do the logic to 
create the maps.

Is there a way in  to make this work?

For example , Use case Customer 

1 Customer has
        2 emails
        3 Addresses
        2 Telephones


thanks for your help..
nathan