ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <larry.mead...@gmail.com>
Subject Re: problem creating a resultmap with multiple 1:M relationship
Date Thu, 06 Mar 2008 05:31:46 GMT
That won't work, you'll need to do 2 selects, or use a RowHandler.

Larry


On Wed, Mar 5, 2008 at 10:26 PM, ashishvk <ashishvishwas_k@infosys.com> wrote:
>
>  hi all,
>
>  i have entity relationship as follows:
>
>  P 1:m c1,c2 where p is parent and c1,c2 are child tables.
>  My problem is that when i have 2 records in c1 and 1 record in c2 for p, the
>  record in c2 gets added to c2list twice (which i want to avoid)
>
>
>  <result property="c1List" resultMap="c1DAO.getc1Result"/>
>  <result property="c2List" resultMap="c2DAO.getc2Result"/>
>
>  i am using outer joins in my query.
>
>  thanks
>
>
>
>  --
>  View this message in context: http://www.nabble.com/problem-creating-a-resultmap-with-multiple-1%3AM-relationship-tp15866758p15866758.html
>  Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

Mime
View raw message