I've been trying to get this to work still and I now
see an exception pertaining to BIGINT. It appears that Sybase ASE only began
support for BIGINT in version 15. I'm stuck on 12.0.0.8. Any suggestions as to a
workaround for this? Also I searched through the documentation on ASE 15 but
found nothing pertaining to XLOCK. Am I missing something
here?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 13, 2007 12:10 PM
To: [EMAIL PROTECTED]
Cc: users@activemq.apache.org
Subject: RE: ActiveMQ with Sybase for persistence
Looks like I still have problems. I downloaded the 4.2 that
you sent me the link to (thank you) and I configured it for my data source. The
problem is that my ASE is actually 12.0.0.8 and not 12.5. The SELECT WITH XLOCK
raises an error. ASE complains about the WITH syntax.
Any suggestions as to a work around or am I simply boned
for working with this version of ASE?
Thanks...
From: "James Strachan" <[EMAIL PROTECTED]> [mailto:"James Strachan" <[EMAIL PROTECTED]>]
Sent: Tuesday, March 13, 2007 8:21 AM
To: "Christopher.Mathrusse
Cc: users@activemq.apache.org
Subject: Re: ActiveMQ with Sybase for persistence
<[EMAIL PROTECTED]>wrote:
> 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?
That you cannot use JDBC Master/Slave and that there is a risk someone
will start 2 brokers on the same database (which can cause problems).
> The row will not be locked so will there be
> contention?
>
> I just downloaded the 4.1.2 build.
Which one? We've a 4.1-SNAPSHOT and 4.2-SNAPSHOT
http://people.apache.org/repo/m2-snapshot-repository/org/apache/activemq/apache-activemq/
(make sure you choose a recent one - near the bottom of those pages)
> I haven't retrieved the latest source. Is
> it stable enough to work in a production environment?
Yes.
--
James
-------
http://radio.weblogs.com/0112098/
