I am trying to use Abator to do the equivalent of the following SQL
statement, which as you can see is changing the "EMP_ID".  "EMP_ID" and
"SERIAL_NUM" together comprise the primary key.

"UPDATE    ATADMIN.IAT_ASSET
SET EMP_ID =  ? , 
BUDGET_UNIT =  ? ,  
ASSET_COMMENT =  ? ,  
DECOMM_REQ_FLG =  ? 
WHERE   
(      ( ATADMIN.IAT_ASSET.EMP_ID =  ?  ) 
AND ( ATADMIN.IAT_ASSET.SERIAL_NUM =  ?  )    )";

   The only two methods Abator created in the "IatAssetDAO" are the following
two, which do not provide me any way to change the value of the primary key
because it is used in the where clause.  Please advise-- am I out of luck or is
there a way to coax Abator into doing this update.

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table ATADMIN.IAT_ASSET
     *
     * @abatorgenerated Fri Sep 07 17:08:13 EDT 2007
     */
    int updateByPrimaryKey(IatAsset record);

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table ATADMIN.IAT_ASSET
     *
     * @abatorgenerated Fri Sep 07 17:08:13 EDT 2007
     */
    int updateByPrimaryKeySelective(IatAsset record);



    


Reply via email to