One question: Why not just let the database do it and have it tell you
the generated key?
Larry
On 9/15/06, Edwin Lukaweski <[EMAIL PROTECTED]> wrote:
Hi:
I have a situation for which I need some advice while using iBatis.
What I would like to do is:
1) generate a unique UUID style value in my Java program
2) lock a table, say tabxx
3) SELECT on the table to see if the UUID exists as a key
4) if so, add 1 to the key and go to step 3
5) if the key does NOT exist, insert the record
6) unlock the table
Can anyone get me advice as to how to do this with iBatis?
Thanks, very musch, in advance
Edwin
