On Mon, Feb 22, 2010 at 12:03 AM, Clinton Begin <clinton.be...@gmail.com>wrote:
> The reason is that the rows aren't uniquely identified. Upon a second
> look, I see that the column I recommended isn't unique. Which columns
> uniquely identify each parent row?
>
>
They'd be unique by a combination of "parentAttributeID" and
"attributeValueID"
That would make a row unique. So your post led me to try this
<association property="attributeValue"
column="{parentValueID=parentValueID,attributeValue.attributeValueID=attributeValueID}"
- but that would only work I suppose if my property was a composite object
which its not.
Looks like I should stick to not using an association for this (and do it
the ibatis2.0 way?):
<!-- flatten -->
<result property="parentValueID" column="parentValueID" jdbcType="CHAR" />
<result property="attributeValue.attributeValueID" column="attributeValueID"
jdbcType="INTEGER"/>
<result column="value" property="attributeValue.value" jdbcType="VARCHAR"/>
