Ah... this is very interesting! Much thanks, and if you know of a good book that might address many of these problems with other alternate solutions, please, do let me know.
Jeff > UPDATE account set balance = ? where column_version_num = ? ; > > I call stment.setString (1, model.getNewBalance()); > stment.setString (2, model.getVersionNumber()); > > If I get a SQLException on this update, then I know that someone else > beat me to the $5. > > The key concept is the WHERE clause will only update the row IFF > the sequence number has not been changed by someone else (meaning > I had stale data).
smime.p7s
Description: S/MIME Cryptographic Signature
