Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL
Expertise: Beginner
Mar 24, 1997



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Lock failure

I am using the Japanese version of OPO. Occasionally, I get an error message that says 'Failed to lock row.' It doesn't happen all the time. What makes OPO lock a row?

The problem is not you - it's everyone else!

Power Objects supports only a pessimistic locking model at this time. This means that OPO attempts to lock a row when you start to edit the row in your application.

When OPO tries to lock a row but finds that the row is already locked, you will see the error message you have been receiving. Since locks are the primary mechanism to protect data integrity, OPO does the right thing in this situation.

My understanding is that version 2 will contain a new method allowing you to intercept database errors, so you will be able to address this potential problem with specific corrective actions.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date