Ahh - the truth comes out! Only one <selectKey> is allowed. Genrally, the current date is a special keyword you can use in an insert statement so you shouldn't need a select key just for that.
Jeff Butler On Mon, Jul 14, 2008 at 2:33 PM, kiran vuppla <[EMAIL PROTECTED]> wrote: > Actually I am using *two* <selectKey> statements inside <insert> > statement. But I see only one <selectKey> is working all the time. When I > comment any *one*, the *other* is returning the result. *Can we not use > two <selectKey> tags inside a <insert>?* > > > > <insert id="insertSession" parameterClass="Session"> > *<selectKey resultClass="int" keyProperty="id"> > select SESSIONID_SEQUENCE.NEXTVAL as id from dual > </selectKey> > <selectKey resultClass="java.sql.Date" keyProperty="createdOn"> > select sysdate as createdOn from DUAL > </selectKey>* > insert into ppsession (SESSIONID, NAME, DESCRIPTION, CREATEDON, > CREATEDBY, SESSIONSTATE) VALUES > (#id#, #name#, #description#, #createdOn#, #createdBy#, #state#) > </insert> > > > > Thanks, > KV > > --- On *Mon, 7/14/08, Larry Meadors <[EMAIL PROTECTED]>* wrote: > > From: Larry Meadors <[EMAIL PROTECTED]> > Subject: Re: Insert Statement. > To: [email protected], [EMAIL PROTECTED] > Date: Monday, July 14, 2008, 8:54 AM > > Are you calling insert() or update()? > > Larry > > On Mon, Jul 14, 2008 at 7:27 AM, kiran vuppla > <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I am having a insert statement and in which I am trying to insert values > > that I recieve from <selectKey> result. But I see that it is not > inserting > > the value. Please let me know if it is correct way to do it? > > > > > > > > In the below It is inserting null values for "#date#" which I > get from > > <selectKey> statement. > > > > > > > > <insert id="insertValues" > parameterClass="Session"> > > > > <selectKey resultClass="java.sql.Date" type="pre" > keyProperty="date"> > > > > select sysdate from dual > > > > </selectKey> > > > > insert into SessionTbl (name, date, address, city, zip) values (#name#, > > #date#, #address#, #city#, #zip#) > > > > </insert> > > > > > > > > Thanks > > > > KV > > > > >
