activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher.Mathru...@sybase.com
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">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii" inline 
Content-Disposition: format="flowed" plain; text Content-Type: 7bit 
Content-Transfer-Encoding:>
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<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 
contention?</FONT></SPAN></DIV>
<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 
environment?</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> "James Strachan" 
&lt;james.strachan@gmail.com&gt; [mailto:"James Strachan" 
&lt;james.strachan@gmail.com&gt;] <BR><B>Sent:</B> Tuesday, March
13, 2007 7:37 
AM<BR><B>To:</B> users@activemq.apache.org<BR><B>Subject:</B>
Re: ActiveMQ with 
Sybase for persistence<BR></FONT><BR></DIV>
<DIV></DIV>On 3/13/07, Christopher.Mathrusse@sybase.com 
<BR><CHRISTOPHER.MATHRUSSE@SYBASE.COM>wrote: <BR>&gt; <BR>&gt;
<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>http://issues.apache.org/activemq/browse/AMQ-1191 <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>-------

<BR>http://radio.weblogs.com/0112098/ <BR><BR></BODY></HTML>


Mime
View raw message