reset password
Author Message
ashasabeer
Posts: 55
Posted 15:57 Nov 20, 2010 |

Can a transaction make an Exclusive lock on the same data which is having Shared lock by another transcation/

For example:

sl1(b3),r1b3,xl2(b3), w2b3, Is this correct?

cysun
Posts: 2935
Posted 19:56 Nov 20, 2010 |

What do you think?

ashasabeer
Posts: 55
Posted 20:04 Nov 20, 2010 |
I think below one is correct .but i am not sure.
 
ashasabeer wrote:

Can a transaction make an Exclusive lock on the same data which is having Shared lock by another transcation/

For example:

sl1(b3),r1b3,xl2(b3), w2b3, Is this correct?

cysun
Posts: 2935
Posted 23:02 Nov 20, 2010 |

What does the textbook or the lecture notes say about exclusive locks?