finding unique keys

[Edwin Lukaweski]

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