Hi,

I can not believe this, that the parameterMaps are based on sequance instead
of names. I'm using 1.6.2 and oracle, it seems to be so. I have a
definination here:

  <parameterMaps>
    <parameterMap id ="UpdateMap" class ="Process">
      <parameter property ="Id" column="ID"/>
      <parameter property="Name" column="NAME" />
      <parameter property="Owner" column="OWNER" />
      <parameter property="EMail" column="EMAIL"/>
      <parameter property="Comments" column="COMMENTS"/>
      <parameter property="Workflow.Id" column="PARENTID"/>
      <parameter property="IsDeleted" column="ISDELETED"/>
    </parameterMap>
  </parameterMaps>

and sql is this

    <insert id="Insert" parameterClass="Process" parameterMap="UpdateMap">
      INSERT INTO process
        (ID, NAME, OWNER, EMAIL, COMMENTS, OVERLAYS, PARENTID, ISDELETED)
      VALUES
        (?, ?, ?, ?, ?, ?, ?, ?)
    </insert>

if I switch the sequance of ISDELETE and PARENTID, in either sql or the
parameterMap, then it always generates error. (ISDELETED is varchar2(1))

Anyone encountered this?

Regards,
T.M.

Reply via email to