Cool, how do you do that? On Jan 2, 2008 5:59 PM, Nathan Maves <[EMAIL PROTECTED]> wrote:
> This is correct with mysql. You can also specify the selectKey to be a > "pre" or "post" then the placement of the code is not crucial. > > Nathan > > > On Jan 2, 2008 3:54 PM, Justin Stanczak < [EMAIL PROTECTED]> wrote: > > > I'm currently using this to return the inserted objects generated key. > > These are auto increment columns and I was wondering if this is correct. I > > notice if I put the selectKey before the insert it returns the wrong key, is > > this correct? Just wanted to verify. > > > > <insert id="insertRole" parameterClass="Role"> > > INSERT INTO SAVVYLMS.SVV_ROLE (SVV_NAME,SVV_TYPE_ID,SVV_DESC) VALUES > > (#name#,#type#,#description#); > > <selectKey keyProperty="id" resultClass="long"> > > SELECT LAST_INSERT_ID(); > > </selectKey> > > </insert> > > > > -- > > "All that is necessary for the triumph of evil is that good men do > > nothing." Edmund Burke > > > -- "All that is necessary for the triumph of evil is that good men do nothing." Edmund Burke
