activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject RE: ActiveMQ with Sybase for persistence
Date Tue, 13 Mar 2007 14:58:04 GMT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=Content-Type content="text/html; charset=us-ascii" inline 
Content-Disposition: format="flowed" plain; text Content-Type: 7bit 
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<DIV dir=ltr align=left><SPAN class=042225414-13032007><FONT face=Arial 
color=#0000ff size=2>I looked over the examples and did not find one for Sybase. 
I did get the datasource configured and I can connect without any issues, but 
when ActiveMQ starts it performs a SELECT FOR UPDATE which causes an exception. 
I'll try the useDatabaseLock=false and see if it resolves it, but what are the 
ramifications if I do this? The row will not be locked so will there be 
<DIV dir=ltr align=left><SPAN class=042225414-13032007><FONT face=Arial 
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=042225414-13032007><FONT face=Arial 
color=#0000ff size=2>I just downloaded the 4.1.2 build. I haven't retrieved the 
latest source. Is it stable enough to work in a production 
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> "James Strachan" 
&lt;; [mailto:"James Strachan" 
&lt;;] <BR><B>Sent:</B> Tuesday, March
13, 2007 7:37 
Re: ActiveMQ with 
Sybase for persistence<BR></FONT><BR></DIV>
<DIV></DIV>On 3/13/07, 
<BR>&gt; Does 
anyone have a working example of using ActiveMQ with Sybase ASE as the <BR>&gt;

persistence store? <BR><BR>The activemq.xml includes examples of configuring 
with various JDBC <BR>drivers; it should be a matter of just tweaking those... 
<BR><BR>&gt; The online docs make mention that Sybase is supported but <BR>&gt;

ASE does not support SELECT FOR UPDATE and I was wondering how to configure 
<BR>&gt; ActiveMQ so it will work. <BR><BR>I've recently patched the
4.2 trunk 
to work better with TransactSQL <BR>databases (SQLServer / Sybase) to use the 
'select * from with XLOCK" <BR>syntax instead... 
<BR><BR> <BR><BR>you
could try 
using the 4.2-SNAPSHOT distro and seeing if that works for you. <BR><BR>(As a

workaround you can add the useDatabaseLock="false" attribute to <BR>the XML 
element for the database configuration). <BR>-- <BR><BR>James <BR>-------


View raw message