Hi,

I am using Hibernate3.2 and SQL Server 2000 as database. I want to do one thing in my application that when one user is inserting data, other user can not update,delete or insert data in same table. How i can implement that. Is session.lock() method will works or there is other way to do same.

Please help me.
Thanks.


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

Session.lock should work.

Although it sounds like what you really want is "SERIALIZABLE" reads isolation level. So you might want to try setting the hibernate.connection.isolation property in hibernate.cfg.xml as well.

Hi,
>>> when one user is inserting data, other user can not update,delete or insert data in same table
Hibernate supports row level locks.
session.lock() does not support obtaining table locks.
We might have to rely on native sql and underlying database.

session.createSQLQuery(" LOCK table myTable in exclusive mode nowait").executeUpdate() ;

------------------------------------------
Rate the reply if you find it helpful