Please change Abator automatically generated datatype  from int into long and  
primary key datatype from Interger into Long
---------------------------------------------------------------------------------------------------------------------------

                 Key: IBATIS-548
                 URL: https://issues.apache.org/jira/browse/IBATIS-548
             Project: iBatis for Java
          Issue Type: Improvement
            Reporter: GONG HUAIYU


insert into admin_costcenterid (ID, COMID, COSTCENTERID, REMARKS, ACTIVESTATUS, 
UPDATEBY,
      LASTHIT)
    values (#id:Integer#, #comid:VARCHAR#, #costcenterid:VARCHAR#, 
#remarks:VARCHAR#,
      #activestatus:SMALLINT#, #updateby:VARCHAR#, #lasthit:TIMESTAMP#)
  

  <selectKey resultClass="int" keyProperty="id">
    SELECT LAST_INSERT_ID() AS id            
</selectKey>
                

Change into 
insert into admin_costcenterid (ID, COMID, COSTCENTERID, REMARKS, ACTIVESTATUS, 
UPDATEBY,
      LASTHIT)
    values (#id:Long#, #comid:VARCHAR#, #costcenterid:VARCHAR#, 
#remarks:VARCHAR#,
      #activestatus:SMALLINT#, #updateby:VARCHAR#, #lasthit:TIMESTAMP#)

  <selectKey resultClass="long" keyProperty="id">
    SELECT LAST_INSERT_ID() AS id            
</selectKey>           

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to