LockOptions.SKIP_LOCKED semantics implementation on MSSQL

Description

I tried to use LockOptions with LockOptions.SKIP_LOCKED as a timeout value on MSSQL with Hibernate 4.3.11 but it seems it was ignored.

As far as I checked, it is possible to have SKIP_LOCKED semantics with MSSQL using READPAST hint (see also https://msdn.microsoft.com/en-us/library/ms187373.aspx), for example:

Will return a first not locked row in my_table and will lock it at the same time.

Activity

Show:

Vlad MihalceaApril 3, 2017 at 2:26 PM

Applied PR upstream.

Vlad MihalceaMarch 29, 2016 at 6:46 AM

Thanks for adding the issue.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created March 29, 2016 at 5:54 AM
Updated April 14, 2017 at 10:13 AM
Resolved April 3, 2017 at 2:26 PM