I didn't understand how optimistic concurrency will work in hibernate?
As per my knowledge, we need to have either VERSION or TIMESTAMP column in persistence table which is mappend to hibernate.
Say we are having TIMESTAMP column then whenever we execute INSERT,UPDATE statement hibernate will modify TIMESTAMP column with system timestamp. When we try to update a row and that row timestamp is differenent from the existing row timestamp then it determines as stale data and it will through the error message.
Please correct me if I'm wrong and also provide some example too.