ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edwin Lukaweski" <serj...@rogers.com>
Subject finding unique keys
Date Fri, 15 Sep 2006 14:10:15 GMT
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

Mime
View raw message