Re: EOFetchSpecification that locks objects like 'SELECT FOR UPDATE NO WAIT'
Re: EOFetchSpecification that locks objects like 'SELECT FOR UPDATE NO WAIT'
- Subject: Re: EOFetchSpecification that locks objects like 'SELECT FOR UPDATE NO WAIT'
- From: Andrew Lindesay <email@hidden>
- Date: Tue, 4 Nov 2008 23:02:41 +1300
Hello Andri;
I'm not sure I follow precisely what you're after, but I had a problem
where a very large volume of concurrent writes into a database product
from a number of instances was causing deadlocks, so I subclassed the
EOF JDBC Adaptor to apply ordered table-level locks on the leading
edge of the transaction. This has worked out very well and has been
in production for some time. You can get the source code for this
with my framework and maybe something like this may be what you are
after.
cheers.
a EOFetchSpecification that locks objects and throws an exception on
any other access trials (SELECT, UPDATE, whatever) is required. The
behaviour should be the same as the SQL Statement 'SELECT FOR UPDATE
NO WAIT'.
...
Any helpful hints or examples how to use 'setUseNoWaitLocks' would
be appreciated.
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden