To provide an alternative to the former topic I'd like to raise a discussion about optimistic locking. As far as I know optimistic locking can be obtained with 2 ways 1) Timestamp for double-checking 2) Using a UPDATE where ... AND ... to double check fields I have two questions about it:
1) Optimistic locking can be obtained only with BMP? because I have to code these strategies manually in the Bean. 2) Which of these 2 strategies seems better ?