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 ?
Thanks for your attention
Francesco