Top "Pessimistic-locking" questions

Pessimistic locking is a strategy that will lock a database record, that is to be updated, for exclusive use until the update is complete.

Optimistic vs. Pessimistic locking

I understand the differences between optimistic and pessimistic locking. Now could someone explain to me when I would use either …

sql-server locking optimistic-locking pessimistic-locking
Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect)

I have a java project that runs on a webserver. I always hit this exception. I read some documentation, and …

java hibernate spring amazon-web-services pessimistic-locking
Laravel lockforupdate (Pessimistic Locking)

i'm trying to figure out how to use/test the lockforupdate correctly, but i found is not function like what …

php mysql laravel laravel-5 pessimistic-locking
SQL Server, the misleading XLOCK & optimizations

From some recent testing and reading I've done, it seems the "X" (exclusive) name part of XLOCK is misleading. It …

sql-server sql-server-2008 locking pessimistic-locking
How to code optimistic and pessimistic locking from java code

I know what optimistic and pessimistic locking is, but when you write a java code how do you do it? …

java database jdbc optimistic-locking pessimistic-locking
sql rowlock on select statement

I have an ASP.Net webpage where the user selects a row for editing. I want to use the row …

sql-server tsql locking pessimistic-locking
How to rollback/timeout “select for update” locks in Oracle?

Our app is mostly using optimistic locking using Hibernate’ s versioning support. We are planning to implement pessimistic locking in …

java oracle web-applications architecture pessimistic-locking
JPA Pessimistic Lock attempt never times out

I'm trying to use Pessimistic locking in JPA, over Hibernate 3 against a Postgres Database. I can't get the lock to …

hibernate postgresql jpa pessimistic-locking
Spring Pessimistic locking

i have spring project under java, using hibernate query, i like to use pessimistic locking. How to do Pessimistic locking …

java database hibernate transactions pessimistic-locking
Why my pessimistic Locking in JPA with Oracle is not working

I'm trying to implement some kind of semaphores for cron jobs that runs in different JBoss nodes. I'm trying to …

java oracle hibernate jpa pessimistic-locking