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 >
