Doh - and I have that doc sitting on my desk - good tip!
<selectKey resultClass="int" keyProperty="id">
Select sequence.nextval as id from dual
</selectKey>
Diran
Bruyn Bill wrote:
See "Auto Generated Keys" on page 15 of the SqlMaps doc.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 17, 2006 7:38 AM
To: [email protected]
Subject: Re: Using sequences
This is an apt question for me as well. I access my dao from the
service layer to retrieve this, and then pass it back. I
struck me as
not very efficient, but logically it works ok because all my
DAO calls
come from the same layer... So, is there a better way?
Diran
Paul Carr wrote:
Hi Guys, whats the best way to insert a row with ibatis
when your key
column is generated from a sequence on the DB ?
Would I edit the sql in the sql map ? or is there a clever
way to do
it?
