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:[EMAIL PROTECTED] >Verzonden: vrijdag, april 7, 2006 12:28 PM >Aan: [email protected] >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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > >Verzonden: vrijdag, april 7, 2006 06:51 AM > > >Aan: [email protected] > > >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 > > > > > > > > > > >
