Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

Lock failure

Question:
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?

Answer:
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.

 

 

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