[Hibernate-issues] [Hibernate-JIRA] Created: (HB-456) Select for update isn't supported for MS SQLServer

[<leg...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-456


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-456
    Summary: Select for update isn't supported for MS SQLServer
       Type: Improvement

     Status: Unassigned
   Priority: Major

    Project: Hibernate2

   Assignee: 
   Reporter: Dieter Bogdoll

    Created: Wed, 5 Nov 2003 3:51 AM
    Updated: Wed, 5 Nov 2003 3:51 AM
Environment: MS SQLServer 6.5, 7, 2000

Description:
MS SQLServer doesn't support the "FOR UPDATE" keyword within the SELECT statement.

But it is possible to create the same effect with table hints. 

Hibernate just add "FOR UPDATE" behind the select to lock objects. 
This has to be changed for the MS SQLServer. 
After each table name the correct table hints has to be written.


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira