Method for releasing update locks on rollback to savepoint

A method for selectively releasing locks when rolling back to a savepoint includes: providing at least one savepoint in a transaction, where the at least one savepoint and the transaction are separate lock owners, where at least one lock is assigned to the at least one savepoint and at least one loc...

Full description

Saved in:
Bibliographic Details
Main Author WATTS JULIE A
Format Patent
LanguageEnglish
Published 05.01.2006
Subjects
Online AccessGet full text

Cover

Loading…
More Information
Summary:A method for selectively releasing locks when rolling back to a savepoint includes: providing at least one savepoint in a transaction, where the at least one savepoint and the transaction are separate lock owners, where at least one lock is assigned to the at least one savepoint and at least one lock is assigned to the transaction; rolling back the transaction to the at least one savepoint; and releasing any locks owned by the at least one savepoint, where any locks owned by the transaction is maintained. Ownership of locks to persist until commit is assigned to the transaction. Ownership of locks to be released when rolled back to a savepoint is assigned to the savepoint. When roll back to a given savepoint occurs, locks owned by the savepoint are released while locks owned by the transaction are maintained.
Bibliography:Application Number: US20050184619