phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pradheep Shanmugam <Pradheep.Shanmu...@infor.com>
Subject optimistic lock in phenix
Date Wed, 30 Aug 2017 16:38:24 GMT
hi,


we have a table in phoenix 4.4 which has a modifyrevision as a column..

when a thread updates the row the modifyrevision has to be incremented..

only option i can see is to use the upsert select to get the latest revision but since it
is not atomic how do we avoid the dirty reads?is there any other way this can be done?


Thanks,

Pradheep

Mime
View raw message