Return-Path: Delivered-To: apmail-activemq-users-archive@www.apache.org Received: (qmail 31644 invoked from network); 13 Mar 2007 14:37:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Mar 2007 14:37:08 -0000 Received: (qmail 19099 invoked by uid 500); 13 Mar 2007 14:37:16 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 19081 invoked by uid 500); 13 Mar 2007 14:37:16 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 19071 invoked by uid 99); 13 Mar 2007 14:37:16 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Mar 2007 07:37:16 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of james.strachan@gmail.com designates 66.249.92.171 as permitted sender) Received: from [66.249.92.171] (HELO ug-out-1314.google.com) (66.249.92.171) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Mar 2007 07:37:05 -0700 Received: by ug-out-1314.google.com with SMTP id m3so293665ugc for ; Tue, 13 Mar 2007 07:36:43 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BiUcDC2YOoLcXtGV/TGpGlubx+RGt+KAj6HMAiv8zST8mnyWFkS0bRWVeHcbEwxSPVaa8rbIH+MvstUMZpEpOHO4WLHipytdAF04X9tAppyBMwJoL3FNQ0LqOKh4vUVN7BgogC9MyH5rrBX1abIP/l4Qgt+hh0VwTwjYh38NoGo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=DYtPiH9YmziHiRvq88Z8l7plbS89wyfJFbSgRdTJbGk6UgILgAZrAHRFnhLoxt508OyU+JKLkh5XeM/SxZtUBahNf6hakSj2k3AEFCgbp0+xUtOZHqFIsXL/dvW1pyRAjoJeVh6RL9gCCKd0I01mhzrE+xIIUf77ANK2sm0RVVI= Received: by 10.78.201.2 with SMTP id y2mr350805huf.1173796602850; Tue, 13 Mar 2007 07:36:42 -0700 (PDT) Received: by 10.78.155.11 with HTTP; Tue, 13 Mar 2007 07:36:42 -0700 (PDT) Message-ID: Date: Tue, 13 Mar 2007 14:36:42 +0000 From: "James Strachan" To: users@activemq.apache.org Subject: Re: ActiveMQ with Sybase for persistence In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Checked: Checked by ClamAV on apache.org On 3/13/07, Christopher.Mathrusse@sybase.com wrote: > > > Does anyone have a working example of using ActiveMQ with Sybase ASE as the > persistence store? The activemq.xml includes examples of configuring with various JDBC drivers; it should be a matter of just tweaking those... > The online docs make mention that Sybase is supported but > ASE does not support SELECT FOR UPDATE and I was wondering how to configure > ActiveMQ so it will work. I've recently patched the 4.2 trunk to work better with TransactSQL databases (SQLServer / Sybase) to use the 'select * from with XLOCK" syntax instead... http://issues.apache.org/activemq/browse/AMQ-1191 you could try using the 4.2-SNAPSHOT distro and seeing if that works for you. (As a workaround you can add the useDatabaseLock="false" attribute to the XML element for the database configuration). -- James ------- http://radio.weblogs.com/0112098/