[ http://jira.nhibernate.org/browse/NH-576?page=all ]
Sergey Koshcheyev updated NH-576:
---------------------------------
Fix Version: LATER
Version: 1.2.0.Beta2
> Add support for Sybase and SQL Server (7,2000,2005) table hints
> ---------------------------------------------------------------
>
> Key: NH-576
> URL: http://jira.nhibernate.org/browse/NH-576
> Project: NHibernate
> Type: New Feature
> Components: Core
> Versions: 1.2.0.Beta2
> Reporter: Chad Myers
> Fix For: LATER
>
> Please see this forum post for more information and for updates:
> http://forum.hibernate.org/viewtopic.php?t=957955
> I need to lock a range of rows -- and I mean LOCK, no one can even read them or do anything with them until I'm done (this is a queueing type situation, so this is necessary).
> In SQL Server, the way you go about doing that is:
> ---------------
> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
> BEGIN TRANSACTION
> SELECT * FROM DocumentVersion WITH (HOLDLOCK, XLOCK) WHERE ...
> COMMIT TRANSACTION
> SET TRANSACTION ISOLATION LEVEL READ COMMITTED
> ---------------
> Currently, there is no way to accomplish this using HQL in NHibernate 1.x.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
|
