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