activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jamie McCrindle" <jamiemccrin...@gmail.com>
Subject Re: JDBC Master Slave with SQL Server (was Re: [ANN] Apache ActiveMQ 4.1 released!)
Date Fri, 08 Dec 2006 10:50:46 GMT
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 <james.strachan@gmail.com> wrote:
>
> On 12/6/06, Jamie McCrindle <jamiemccrindle@gmail.com> 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/
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message