Re: auto-generated keys in Oracle

2007-05-16 Thread Jiming Liu
* auto-generated keys in Oracle hi guys, I was trying to use auto-generated key in oracle by iBatis. But it just do not work. I used the feature in Mysql, it works. Is it a bug of iBatis 2.3.0.677? here is my iBatis config part SELECT SEQ_FOO.NEXTVAL AS ID FROM DUAL INSERT INTO f

RE: auto-generated keys in Oracle

2007-05-16 Thread Niels Beekman
Use the keyProperty attribute of selectkey... From: Jiming Liu [mailto:[EMAIL PROTECTED] Sent: woensdag 16 mei 2007 12:28 To: user-java@ibatis.apache.org Subject: auto-generated keys in Oracle hi guys, I was trying to use auto-generated key in oracle by

auto-generated keys in Oracle

2007-05-16 Thread Jiming Liu
hi guys, I was trying to use auto-generated key in oracle by iBatis. But it just do not work. I used the feature in Mysql, it works. Is it a bug of iBatis 2.3.0.677? here is my iBatis config part SELECT SEQ_FOO.NEXTVAL AS ID FROM DUAL INSERT INTO foo (id, name) VALUES(#id#, #name#) It c