Recently I have found that version checking ( optimistic lock) and version updating do not happen when we use JPQL ( @Query and @Modifying). Hence, I modified the SQL using
a.version = a.version+1
to increment the version. But I'm not sure how can I achieve version checking in where clause.
I can do this by querying the table first to find out the current version number and then do the update. But I'm not sure it is the recommended way. Expecting an expert advise.
与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
