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.

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

Priority

Minor
Configure