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.