What kind of database are you using? - Patrick.
-----Original Message----- From: Edwin Lukaweski [mailto:[EMAIL PROTECTED] Sent: Friday, September 15, 2006 9:47 AM To: [email protected]; [EMAIL PROTECTED] Subject: Re: finding unique keys Thanks for the answer. I am stuck with an existing table definition, in a schema, that I cannot modify at this point due to being in production. So, this is the best method I can come up with. also....now you have tweaked my curiosity. In addition to the advice I am seeking, it I could alter the table definition to use some form of auto-increment, how would I retrieve the generated value in iBatis? So.....I now have two questions. thanks, Ediwn ----- Original Message ----- From: "Larry Meadors" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, September 15, 2006 10:14 AM Subject: Re: finding unique keys > 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 >> >
