Awesome. Thanks. Will check it out. I assume the JPA guys (hibernate / openjpa) should have also solved it in a Dialect way so will check out their code as well.
cheers, j. On 12/8/06, James Strachan <[EMAIL PROTECTED]> wrote:
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/
