search results

  1. It depends on your SQL statements. An optimistic lock will occur whenever the transaction fails to acquire a lock on the needed resource for whatever reason it might be.
    stackoverflow.com/.../optimistic-​locking-and-full-table-lock - Cached
  2. To control concurrent access to objects optimistic locking uses a version field ... In your table you need a dedicated ... optimistic - don\'t lock objects ...
    db.apache.org/ojb/docu/guides/​lockmanager.html - Cached
  3. Optimistic locking is a technique for SQL ... the optimistic locking technique is used, because locks cannot be ... the table needs to have a new ...
    publib.boulder.ibm.com/infocenter/​db2luw/v9r5/topic/com... - Cached
  4. Active Records support optimistic locking if the field lock_version is present.
    api.rubyonrails.org/.../ActiveRecord/​Locking/Optimistic.html - Cached
  5. Optimistic locking allows you to ... utilizes an optimistic predicate column for each table in the ... avoidance of optimistic locking issues by placing locks on ...
    pic.dhe.ibm.com/infocenter/wchelp/​v6r0m0/.../cpmoptlock.htm - Cached
  6. ... optimistic means \"don\'t lock the table while reading\" and pessimistic means \"lock the table while ... Optimistic locking is used when you don\'t expect many ...
    stackoverflow.com/questions/129329 - Cached
  7. Adobe PDF
    Since the locking mechanism is optimistic, no locks are taken out during the ... First we will add our concurrency key to the EMP table as an integer column ...
    orafaq.com/papers/locking.pdf
  8. Optimistic Locking : update table set column1 = :new_column1, column2 ... It is possible to use manual locking using the FOR UPDATE statement or LOCK TABLE ...
    www.datadisk.co.uk/html_docs/oracle/​locking.htm - Cached
  9. ... and a full context if anyone wishes to discuss it further.----- 
Example Table-----create table Security ... Optimistic Locking, ...
    dbaspot.com/.../417185-concurrency-​optimistic-locking.html - Cached

  10. Optimistic concurrency control - Wikipedia, the free encyclopedia

    ... transactions can complete without the expense of managing locks and without having transactions wait ... (what is between pessimistic and optimistic locking) ...
    en.wikipedia.org/wiki/Optimistic_​concurrency_control - Cached
    More results from en.wikipedia.org »
    < /LI>