Thanks. I will try that, Regards, KV --- On Mon, 7/14/08, Givler, Eric <[EMAIL PROTECTED]> wrote:
From: Givler, Eric <[EMAIL PROTECTED]> Subject: RE: Insert Statement. To: [email protected], [email protected] Date: Monday, July 14, 2008, 7:39 PM In Oracle, it's SYSDATE. However, like Jeff's saying here, I think you're going to have to one of the following: a) set it on the client end before the insert, passing it as a parameter to the db (use a java.sql.Timestamp) b) set it on the insert via one statement, then re-read the record via a select to get it c) save the record via a stored proc with an out variable for the creation date (or possibly an in|out if you are setting it on the client side) Good luck. -----Original Message----- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Mon 7/14/2008 3:58 PM To: [email protected] Cc: Subject: Re: Insert Statement. I don't know oracle, but in DB2 it's like this: insert into foo (createdOn) values (CURRENT DATE) As for returning the value in the bean, no. But if this is needed, why not set the current date in Java before calling the insert? Jeff Butler On Mon, Jul 14, 2008 at 2:51 PM, kiran vuppla <[EMAIL PROTECTED]> wrote: > Can I get some example how to use curr date (keyword) inside insert > statement. Can we able to return/store the same value to Java Bean object as > I want to store in to my java bean? > > > > Thanks > KV > > --- On *Mon, 7/14/08, Jeff Butler <[EMAIL PROTECTED]>* wrote: > > From: Jeff Butler <[EMAIL PROTECTED]> > Subject: Re: Insert Statement. > To: [email protected], [EMAIL PROTECTED] > Date: Monday, July 14, 2008, 2:47 PM > > > 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 >> > >> >> >> > >
