RE: Problem with insertKey

[Jean-Francois Poilpret]

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: user-java@ibatis.apache.org
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