ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sven.Boden" <list...@pandora.be>
Subject Re: Urgent help for using groupBY
Date Fri, 07 Apr 2006 13:18:50 GMT

Tony,

Your time is probably not my time... I'm located in Belgium, Europe.

You don't need a version number, but you do need an SVN client (on windows I like Tortoise).
If you're not able to build it, let me know off-list and I will build you a version out of
SVN.

Regards,
Sven

>----- Oorspronkelijk bericht -----
>Van: Tony Qian [mailto:daqiqian2@aol.com]
>Verzonden: vrijdag, april 7, 2006 12:28 PM
>Aan: user-java@ibatis.apache.org
>Onderwerp: Re: Urgent help for using groupBY
>
>Sven,
>
>Really appreciate your prompt response, especially at 3:12am.
>
>I have never used SVN and JIRA before. I read the instruction of "how to 
>build from source on Unix". Do I need version number to check out the 
>latest version? If I check out the code according to the instruction, 
>can I use that version of iBATIS + DAOmanager in production?
>
>Sven, thanks again.
>
>If anyone else can also provide me some help on how to build iBATIS from 
>source, I'd really appreciate it.
>
>Tony
>
>Sven.Boden wrote on 4/7/2006, 3:12 AM:
>
> >
> > Tony,
> >
> > For this you would need to have the very latest version of iBATIS, the
> > version from SVN. In JIRA this is IBATIS-260.
> >
> > Regards,
> > Sven
> >
> > >----- Oorspronkelijk bericht -----
> > >Van: DaqiQian2@aol.com [mailto:DaqiQian2@aol.com]
> > >Verzonden: vrijdag, april 7, 2006 06:51 AM
> > >Aan: user-java@ibatis.apache.org
> > >Onderwerp: Urgent help for using groupBY
> > >
> > >All,
> > >
> > >I have following data set from a query:
> > >
> > >member_id    saving_card_id   coupon_id
> > >1                        1                    123
> > >1                        1                    345
> > >1                        1                    678
> > >1                        2                    123
> > >1                        2                    345
> > >1                        2                    678
> > >2                        3                    123
> > >2                        3                     567
> > >2                        3                     345
> > >3                        4                     456
> > >3                        4                    123
> > >3                        4                     567
> > >3                        4                     789
> > >
> > >I need to map above data to a list of MemberData object. MemberData has
> > >member_id and two lists. One list is for list of saving_card_ids and
> > another list
> > >is for coupon ids. Above data need to be mapped as
> > >
> > >for member 1, MemberData ={
> > >                      memberId=1,
> > >                      savingCardList={1,2},
> > >                      couponList ={123, 345, 678}
> > >}
> > >
> > >for member 2 MemberData={
> > >                      memberId=2,
> > >                      savingCardList={3}
> > >                      couponList={123,567,345}
> > >}
> > >
> > >For member 3 MemberData={
> > >                      memberId=3,
> > >                      savingCardList={4},
> > >                      couponList={456,123,567,789}
> > >}
> > >
> > >For same member, each saving card will have same number of coupons.
> > Also, the
> > >couponIds are also same.
> > >
> > >I had following sqlMap:
> > >
> > >  <resultMap id="memberDataMap" class="MemberData" groupBy="memberId">
> > >          <result property="memberId" column="member_id"
> > jdbcType="BIGINT" />
> > >          <result property="savingCardList"
> > >resultMap="member_coupon.savingCardMap" />
> > >          <result property="couponList"
> > resultMap="member_coupon.couponMap" />
> > >  </resultMap>
> > >
> > >  <resultMap id="savingCardMap" class="SavingCard"
> > groupBy="savingCardId">
> > >          <result property="savingCardId" column="saving_card_id"
> > >jdbcType="SMALLINT" />
> > >  </resultMap>
> > >
> > >  <resultMap id="couponMap" class="Coupon" groupBy="couponId" >
> > >            <result property="couponId" column="coupon_id"
> > >jdbcType="INTEGER"/>
> > >   </resultMap>
> > >
> > >Above mapping works correctly for only one member. If more than one
> > member,
> > >all coupons went into the first member's coupons list. the coupon
> > lists for
> > >member 2 and 3 were empty.  If i use groupBy="{couponId,
> > savingCardId) for
> > >couponMap, the couponList of member 1 had 6 entries {123, 345,
> > 678,123, 345, 678).
> > >Two for each coupon which is not desirable.
> > >
> > >I have struggled for more than one day. Any help and suggestions are
> > really
> > >appreciated.
> > >
> > >Tony
> > >
> >
> >
>
>
>
>



Mime
View raw message