Hello! I'm not sure if that is what you want, have you tried Transaction Isolation Level of SERIALIZABLE?
Regards, -- Ilya Kasnacheev пн, 2 мар. 2020 г. в 10:43, Rout, Biswajeet <[email protected]>: > Hi, > > I used transactions in my project when I interact to cache. The > transaction isolation and concurrency modes combination I tried are not > synchronous. > > I want other threads to wait until the current running thread is done with > the same cache. > > For better understanding, I am attaching two sample codes with the > transaction and using Lock. > > I want the result of how it gives using Lock in the transaction. Basically > I want to avoid explicit locking. > And below here are the two results snapshot of these codes. > > *Results using Lock:* > > [image: image.png] > *Results using Transaction:* > > [image: image.png] > > > Regards, > > > Biswajeet *Rout* > > > Dtix-DELPHI > > > O +1 813 617 7739 > M 970 334 9977 > > <http://www.facebook.com/verizon> <http://twitter.com/verizon> > <http://www.linkedin.com/company/verizon> > <http://www.instagram.com/verizon> > >
