Your question is not about transactions. Your's is a valid, but a separate and more or less unrelated topic. Brief answer - Cayenne supports optimistic locking, how to apply it (or any other locking technique) is for the user to decide.
Andrus On Feb 21, 2012, at 12:59 PM, Durchholz, Joachim wrote: >> Of course there are multiple sources of DB modification. >> The question is - do they all have to be in the same transaction ;) > > Rarely if ever, of course. > My question was about how Cayenne interacts with transactions > initiated by third parties: > >> What happens if a record is written that was modified by some third >> party? >> Ideally, Cayenne would avoid writing the udpates and instead report >> back that the application was trying to write stale data. > >
