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.