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.
****************************************************************************
********
