ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: finding unique keys
Date Fri, 15 Sep 2006 14:14:32 GMT
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 <serjann@rogers.com> 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
>

Mime
View raw message