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.