Haha, problems are repeating ;-). If I get this right, we just had this 2 days ago, had we not?
Take a look in this thread: http://www.nabble.com/Having-two-N-plus-1-groups-p18361780.html I'll go with RowHandler and check if it works with collection-types somehow. Cheers Heinrich mailjoe wrote:
Good point Larry! My domain objects look like this: Restaurant --> waitersTeam --> John, Tim, Cindy --> managersTeam --> Mary, Steven I have SQL Maps for both the waitersTeam and the managersTeam. Now, I want to fetch Restaurant objects with a single query based on INNER JOIN. The result map for the Restaurant reuses the SQL Maps for waitersTeam and managersTeam like this: <result property="waiters" column="RESTAURANT.WAITERS_TEAM_ID" resultMap="waitersTeam.result" /> The groupBy attribute is set to “id, waitersTeamId, managersTeamId”. The problem is that I end up with: Restaurant --> waitersTeam --> John, Tim, Cindy, John, Tim, Cindy --> managersTeam --> Mary, Steven, Mary, Steven Any idea how to fix the bug? Larry Meadors wrote:FWIW, I got as far as "COMPLEX", "A_GROUP", and "B_GROUP" before I stopped reading. ;-) I'm not saying no one else will read or answer you, just that I think if you can make this a more concrete example, instead of a tuple calculus exercise, then you might get more (and better) responses. Larry On Fri, Jul 11, 2008 at 8:02 AM, mailjoe <[EMAIL PROTECTED]> wrote:Hi, We have a ComplexObject made of one instance of aGroup and one instance of bGroup. The aGroup is made of a collection of A instances. The bGroup is made of a colleciton of B instances. We have one SQL Map for aGroup, and another one for bGroup. If aGroup contains m A's and bGroup contains n B's, the query given below returns m*n items in the aGroup and bGroup properties: <resultMap class="ComplexObject" id="result" groupBy="id, aGroupId, bGroupId"> <result property="id" column="COMPLEX.OBJECT_ID" /> <result property="aGroup" column="COMPLEX.A_GROUP_ID" resultMap="aGroup.result" /> <result property="bGroup" column="COMPLEX.B_GROUP_ID" resultMap="bGroup.result" /> </resultMap> <select id="getById" resultMap="result"> SELECT * FROM COMPLEX INNER JOIN A_GROUP ON A_GROUP_ID = A_GROUP.ID INNER JOIN A ON A.GROUP_ID = A_GROUP_ID INNER JOIN B_GROUP ON B_GROUP_ID = B_GROUP.ID INNER JOIN B ON B.GROUP_ID = B_GROUP_ID WHERE COMPLEX.ID = #value# </select> Any idea how to fix this bug? Thanks! -- View this message in context: http://www.nabble.com/Duplicates-when-trying-to-avoid-N%2B1-selects-tp18404580p18404580.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
