Hi Guys,

I am a newbie into Hibernate development and as i am progressing i came to know that Hibernate sessions are not threadsafe that means 2 different requests can modify the same data at the same time which leads to inconsistancy. Please correct me if i am wrong with my assumption.

Now suppose i am working on a record to modify column 'A' and another request modified it too to 'B' so it is a incorrect thing for first user [It can be a situation like in a session a user booked a product and again in different session different user booked the same]

is there anyway to avoid such stuff ? Any help is appreciated :)

Regards
Rahul

Have a look at different locking strategies. I'd recommend to use the @Version-Annotation and an optimistic locking mechanism. Hibernate increments a version-field or a timestamp to recognize changes made by different sessions.

update xy set field1 = ? where id = ?;

becomes

update xy set field1 = ?, version = ? where id = ? and version = ?;

If another session changed data concurrently the second session will update no rows. As hibernate knows that there must be exactly ONE row it throws an exception you can handle. E.g. inform the user that the item is reserved for another user.