Hibernate version: 3.0.4 and 3.1beta2

Name and version of the database you are using: MSSQL 2000

Can anyone say me what mssql locking status is?
I get deadlocks using MS SQL2000 and i don't see pessimistic locking in sql queuries generated by hibernate.

Does Hibernate support MSSQL pesimistic locking ?
I found that Gavin said such words "This SQL Server specific problem is a very well-known limitation in the current release." in this topic.
http://forum.hibernate.org/viewtopic.ph ... mssql+lock

Is this problem fixed or when it'll be fixed?

Thank's

Does nobody work with MSSQL 2000 ?

You can have deadlocks wo explicit pessimistic locking use.

I know it, but now i cann't turn on pessimistic locking on MSSQL.
And my question was about pessimistic locking on MSSQL or when it will be implemented in Hibernate.

Thank's

If you use explicit pessimistic locking it will be worse.
The locking are used by MSSQL depending on the JDBC isolation level you choose.

I have many threads which select, update, insert the same or new data from the same table, that's why i need pesimistic locking(i don't want that 2 threads select the same message, could you say how can i do it without pesimistic locking ? ).

It works good in Oracle but in MSSQL as i said there're deadlocks or 2 threads working with the same data.
In Oracle i use select ... for update and also oracle has row locking model.
I want to make the same pesimistic row locking with MSSQL and in other situation i want "select ... with (nolock) ..."

Could you say it's possible with Hibernate or i have to create own MS SQL dialect ?

Also if you give me a link to article about mssql locking and JDBC isolation level, i'll say big thank to you :) (I'm newbie in MSSQL)

Thank's

So that's a different problem you didn't expressed in the previous posts :-)
I don't know about the Sql Server bug we have, I don't think it has been fixed though.
For the isolation level, it's normalized at the JDBC level
Search google on JDBC isolation level, you should be able to find what you want
http://java.sun.com/docs/books/tutorial/jdbc/basics/transactions.html
Also, if you have Hibernate in Action, there is a very clean explaination on isolation level and tx in chapter 5

You're right, but i asked about pessimistic locking and you were trying to understand my problem :)


I see, so i'll create own MS SQL dialect to fix this bug or feature :)


Thank's