Re: (Mis)use of transactions



Arne Vajhøj wrote:
RedGrittyBrick wrote:

Arne Vajhøj wrote:

I think you should drop database builtin locking and go to
application based locking.

Search for optimistic locking and pessimistic locking.

There are well known techniques to handle database operations
in human time (minutes) instead of computer time (milliseconds).


My Google-fu appears to be weak today. I just get lots of refs to EJB locking, Apache Object-relational-bridging etc. These don't appear to be what you are referring to :-(


I may have been a bit too optimistic.

:-(

http://c2.com/cgi/wiki?OptimisticLocking
http://c2.com/cgi/wiki?PessimisticLocking
http://martinfowler.com/eaaCatalog/optimisticOfflineLock.html
http://martinfowler.com/eaaCatalog/pessimisticOfflineLock.html
http://www.javaworld.com/javaworld/jw-01-2006/jw-0130-pojo.html?page=6

say something, but I must admit that it is far from clear
what they really mean.

If you can get your hands on a copy of Fowlers book, then
it has examples in Java/JDBC.


Many thanks :-)
.



Relevant Pages

  • Re: (Mis)use of transactions
    ... Search for optimistic locking and pessimistic locking. ... There are well known techniques to handle database operations ... in human time instead of computer time. ...
    (comp.lang.java.databases)
  • Re: (Mis)use of transactions
    ... Search for optimistic locking and pessimistic locking. ... There are well known techniques to handle database operations ... in human time instead of computer time. ...
    (comp.lang.java.databases)
  • Re: Datensatz sperren
    ... bei der ein einziger Benutzer ganz alleine auf seine lokal gespeicherte ... optimistischen Locking besser bedient. ... Macht man das selbe mit optimistischen Locking, dann ist ein Datensatz ... Hier ist in der Tat optimistic Locking der bessere Weg. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Update Integrity
    ... you have imnplemented optimistic locking: ... AND RowVers = @RowVers ... Pessimistic locking isn't used much, mainly because neither option is very ...
    (microsoft.public.sqlserver.programming)
  • Re: Best Multi-user strategy for ADO on an Access (mdb) file
    ... >edits etc. ... Well neither optimistic or Pessimistic locking is going to let the users know ... Optimistic locking when they try to post the data. ...
    (borland.public.delphi.database.ado)