Re: (Mis)use of transactions
- From: Arne Vajhøj <arne@xxxxxxxxxx>
- Date: Sun, 30 Sep 2007 22:44:56 -0400
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.
Arne
.
- Follow-Ups:
- Re: (Mis)use of transactions
- From: RedGrittyBrick
- Re: (Mis)use of transactions
- Prev by Date: Re: Finding valid ENUM values
- Next by Date: Re: Finding valid ENUM values
- Previous by thread: Re: Finding valid ENUM values
- Next by thread: Re: (Mis)use of transactions
- Index(es):
Relevant Pages
|
