On 12/6/06, Jamie McCrindle <[EMAIL PROTECTED]> wrote:
> If you can figure out the right SQL that SQLServer needs to
> create an exclusive table lock (and keep it open until
> the connection dies) then it should be easy to patch the JDBC adapter
Cool. Will give it a go when some of the noise dies down over here.
Its a while since I've used SQL Server but this is the best reference
I could find on the locking syntax...
http://msdn2.microsoft.com/en-us/library/ms187373.aspx
maybe something vaguely like this...
SELECT from ActiveMQLocks WITH (TABLOCK, XLOCK)
We could maybe switch to an update statement maybe which might be a
bit more portable.
--
James
-------
http://radio.weblogs.com/0112098/
