ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emilio Gutiérrez León <gutie...@hotmail.com>
Subject Overwrite a property in resultMap
Date Mon, 08 Jun 2009 13:34:00 GMT

Hello.

I need to set the value of all properties of "Address" of the person in each job :

<resultMap id="JobPersonMapping" class="JobPerson">
      <result property="job" resultMap="Jobs.JobMapping"/>
      <result property="person" resultMap="Person.PersonMapping" />
      <result property="person.Address" select="Address.Addrees_find" column="{id=PERSON.PERSON_ADDRESS_IDINT}"
/>
</resultMap>

<select id="JobPerson_find" parameterClass="JobPerson" resultMap="JobPersonMapping">
         SELECT *
          FROM JOB,
                  JOB_PERSON,
                  PERSON
         WHERE JOB_PERSON.PERSON_IDINT = PERSON.IDINT
             AND JOB_PERSON.JOB_IDINT = JOB_IDINT
             AND JOB_PERSON.IDINT = #id#
 </select>

<resultMap id="PersonMapping" class="Person">
      <result property="id" column="PERSON_IDINT" />
      <result property="address.id" column="PERSON_ADDRESS_IDINT" />
      ...
</resultMap>

<resultMap id="JobMapping" class="Job">
      <result property="id" column="JOB_IDINT" />
      ...
</resultMap>

<!-- ADDRESS map config file !-->
<select id="Address_find" parameterClass="Address" resultMap="AddreessMapping">
        SELECT *
          FROM ADDRESS
         WHERE ADDRESS_IDINT = #id#
</select>

<resultMap id="AdreessMapping" class="Address">
      <result property="id" column="ADD_IDINT" />
      <result property="street" column="ADD_STREET" />
      ...
</resultMap>

The problem is that "person.Address" only have completed the property "id" because in the
process I believe that first Ibatis set "person.Address" correctly with the result of "Address.AddreessMapping"
and later overwrite the property "person.Address" with the result of resultmap "Person.PersonMapping".
The objetive of this is reuse the sql sentences.

Thanks.
_________________________________________________________________
Descubre todas las formas en que puedes estar en contacto con amigos y familiares.
http://www.microsoft.com/windows/windowslive/default.aspx
Mime
View raw message