We're updating the issue view to help you get more done. 
Learn more or See the old view

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:

1 2 3 select top 1 * from my_table with (rowlock, updlock, readpast);

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

Environment

4.3.11, MSSQL

Status

Assignee

Vlad Mihalcea

Reporter

Piotr Roubo

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

backportDecision

None

Components

Affects versions

4.3.11

Priority

Minor