SQLServer2005Dialect does not use NOWAIT for aliases

Description

When using lock aliases, the SQLServer2005Dialect ignores the initial LockOptions and uses the deprecated appendLochHint(lockMode, alias)

Environment

None

Activity

Show:
Carsten Hammer
June 9, 2016, 7:40 AM

Hi Vlad, I don't think it makes sense to support an unsupported product. SQLServer2005 end of life has been reached:
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2005-end-of-life-and-upgrade-options/
Rather than this it would be interesting to support SQLServer2016, memory tables and so on. To put effort in a dead product is a waste of time imho..

Vlad Mihalcea
June 9, 2016, 7:44 AM
Edited

I was referring to the SQLServer2005Dialect class, not the actual SQL Server 2005 product version. The SQLServer2005Dialect is a base class for:

  • SQLServer2008Dialect

  • SQLServer2012Dialect

  • any future SQLServer20012Dialect, SQLServer20014Dialect or SQLServer20016Dialect

So, it covers newer versions as well.

Assignee

Vlad Mihalcea

Reporter

Vlad Mihalcea

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

backportDecision

None

Priority

Major
Configure