Nathan,
Ambiguous column names are easily handled. Just
differentiate the names in the query, then you can
assign them explicitly in the resultMaps. Here's an
example with an ambiguous 'name' column:
<sqlMap namespace="Example">
<resultMap id="parentResult" class="com.eg.Parent"
groupBy="parentId">
<result property="parentId" column="parent_id"/>
<result property="name" column="parent_name"/>
<result property="children"
resultMap="Example.childResult"/>
</resultMap>
<resultMap id="childResult" class="com.eg.Child">
<result property="name" column="child_name"/>
<result property="description"
column="description"/>
column="broadcastEndDate"/>
</resultMap>
<select id="getFamilies" resultMap="parentResult">
select
p.id AS parent_id,
p.name AS parent_name,
c.name AS child_name,
c.desc AS description
FROM child c, parent p
WHERE p.id = c.parent_id
</select>
</sqlMap>
In this example both the column and the property names
are ambiguous, but it's gracefully handled. :-)
HTH,
Kris
--- Nathan Maves <[EMAIL PROTECTED]> wrote:
> Great! I will give it a try.
>
> What do you suggest when you have ambiguously
> defined column names in a
> n+1 query?
>
> nathan
> On Feb 9, 2005, at 10:30 AM, Clinton Begin wrote:
>
> > If you can join the data into a single resultset
> with repeating
> > groups, the N+1 solution will work, no matter how
> the collections are
> > arranged.
> >
> > As long as you group by some column in table_a,
> you can separately map
> > 2 collections on the same class.
> >
> > This will work.
> >
> > Try it out!
> >
> > Clinton
> >
> > On Wed, 09 Feb 2005 10:21:54 -0700, Nathan Maves
> > <[EMAIL PROTECTED]> wrote:
> >> I dont think that the current implementation will
> work for this but I
> >> was looking for some best practices on how to do
> it.
> >>
> >> Parent Class A has n number of List properties
> that all come for their
> >> own tables.
> >>
> >> A from table_a
> >> List of B from table_b
> >> List of C from table_c
> >> .
> >> .
> >> .
> >>
> >>
> >> Nathan
> >>
> >>
>
>
___________________________________________________________
ALL-NEW Yahoo! Messenger - all new features - even more fun!
http://uk.messenger.yahoo.com
