Hi,

Is there any way for JOOQ to handle optimistic locking automatically?

So given an updateable record something like the following:

MyRecord r = .... // some query
r.setValue(.....) // do some stuff
r.storeWithCheck(); // throws an exception if has been updated by another 
connection

Rather than adding a version column it could do a select on the record and 
if the initial values are different then throw the exception.

Or is there another approach to achieve this?

Thanks! Ryan

Reply via email to