And you are sure you are using the insert() method of the SQL Map Client? Larry
On 11/3/07, Odelya Glick <[EMAIL PROTECTED]> wrote: > I tried it. > > Now it looks like this: > <insert id="insertCondolence" parameterClass="condolence"> > <selectKey keyProperty="id" resultClass="int"> > SELECT obituary_seq.NEXTVAL AS ID FROM DUAL > </selectKey> > INSERT INTO JPCONDOLENCE(ID, STATUS, OBIT_ID, CREATED_DATE, > AUTHOR_NAME, COUNTRY, AUTHOR_EMAIL, BODY, CITY) > > VALUES(#id#,#status#,#obitId#,#createdDate#,#authorName#,#country#,#authorEm > ail#,#body#,#city#) > </insert> > > But still I get 0 as id. > > Just to mention, when I run query: > <select id="getNextSequence" resultClass="string"> > SELECT obituary_seq.NEXTVAL AS ID FROM DUAL > </select> > I do get the NextSequence from DB. > > P.S. Is the above way to get the next sequence equals concerning database > performances? > > Thank you, > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Larry Meadors > Sent: Thursday, November 01, 2007 6:37 PM > To: [email protected] > Subject: Re: Problem with insertKey > > Try > > SELECT obituary_seq.NEXTVAL AS id FROM dual > > instead (id, not value). > > Larry > > > On 11/1/07, Odelya Glick <[EMAIL PROTECTED]> wrote: > > Well, > > > > I changed it, but it always puts value 0. > > > > The sequence is declared like this: > > > > CREATE SEQUENCE obituary_seq > > INCREMENT BY 3 > > START WITH 100 > > NOMAXVALUE > > MINVALUE 100 > > NOCYCLE > > CACHE 20 > > NOORDER > > > > What could be the problem? > > > > Many thanks, > > > > Odelya > > > > > > -----Original Message----- > > From: Jean-Francois Poilpret [mailto:[EMAIL PROTECTED] > > Sent: Thursday, November 01, 2007 4:40 PM > > To: [email protected] > > Subject: RE: Problem with insertKey > > > > An Oracle sequence cannot map to a String, so your condolence class should > > have the following properties: > > int id; (or long) > > String status; > > > > Cheers > > > > Jean-Francois > > > > -----Original Message----- > > From: Odelya Glick [mailto:[EMAIL PROTECTED] > > Sent: Friday, November 02, 2007 9:21 AM > > To: [email protected] > > Subject: Problem with insertKey > > > > > > Hi, > > > > I am trying to receive primary key with: > > <insert id="insertCondolence" parameterClass="condolence"> > > <selectKey keyProperty="id" resultClass="int"> > > SELECT obituary_seq.NEXTVAL AS value FROM dual > > </selectKey> > > INSERT INTO CONDOLENCE(ID, STATUS) > > VALUES(#id#,#status#) > > </insert> > > > > The condolence class has 2 properties: > > String id; > > String status; > > > > But it always inserts a record with the right status value, but id value > is > > always null!! > > > > Why? > > > > Thanks > > Odelya > > web-programmer > > 050-2052075 > > > > > > > > > > > > > > > > > > > **************************************************************************** > > ******** > > This footnote confirms that this email message has been scanned by > > PineApp Mail-SeCure for the presence of malicious code, vandals & computer > > viruses. > > > **************************************************************************** > > ******** > > > > > > > > > > > > > > > > **************************************************************************** > ******** > This footnote confirms that this email message has been scanned by > PineApp Mail-SeCure for the presence of malicious code, vandals & computer > viruses. > **************************************************************************** > ******** > > > > >
