RE: ActiveMQ with Sybase for persistence

2007-03-14 Thread Christopher . Mathrusse
0 PMTo: "Christopher.MathrusseCc: users@activemq.apache.orgSubject: Re: ActiveMQ with Sybase for persistence I've just raised a JIRA to track this...http://issues.apache.org/activemq/browse/AMQ-1204and have commited a patch using "DECIMAL" as the long integer and using the SQL

Re: ActiveMQ with Sybase for persistence

2007-03-14 Thread James Strachan
2007 1:32 AM *To:* users@activemq.apache.org *Subject:* Re: ActiveMQ with Sybase for persistence On 3/14/07, [EMAIL PROTECTED] wrote: > 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 > BIG

RE: ActiveMQ with Sybase for persistence

2007-03-14 Thread Christopher . Mathrusse
; <[EMAIL PROTECTED]> [mailto:"James Strachan" <[EMAIL PROTECTED]>] Sent: Wednesday, March 14, 2007 1:32 AMTo: users@activemq.apache.orgSubject: Re: ActiveMQ with Sybase for persistence On 3/14/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]>wrote: > I've been tryi

Re: ActiveMQ with Sybase for persistence

2007-03-14 Thread Thomas Gagné
Couldn't you add a user-defined type called BIGINT? -- Visit , or for more great reading.

Re: ActiveMQ with Sybase for persistence

2007-03-14 Thread James Strachan
On 3/14/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: 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 s

RE: ActiveMQ with Sybase for persistence

2007-03-13 Thread Christopher . Mathrusse
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 PMTo: [EMAIL PROTECTED]Cc: users@activemq.apache.orgSubject: RE: ActiveMQ with Sybase for persistence Looks like I still have p

RE: ActiveMQ with Sybase for persistence

2007-03-13 Thread Christopher . Mathrusse
users@activemq.apache.orgSubject: Re: ActiveMQ with Sybase for persistence On 3/13/07, [EMAIL PROTECTED] <[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

Re: ActiveMQ with Sybase for persistence

2007-03-13 Thread James Strachan
On 3/13/07, [EMAIL PROTECTED] <[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 useDataba

RE: ActiveMQ with Sybase for persistence

2007-03-13 Thread Christopher . Mathrusse
t; [mailto:"James Strachan" <[EMAIL PROTECTED]>] Sent: Tuesday, March 13, 2007 7:37 AMTo: users@activemq.apache.orgSubject: Re: ActiveMQ with Sybase for persistence On 3/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]>wrote: > > > Does anyone have a working example of u

RE: ActiveMQ with Sybase for persistence

2007-03-13 Thread Christopher . Mathrusse
12.5.1 does have SELECT FOR UPDATE but it can only be used on a CURSOR. From: Thomas Gagné <[EMAIL PROTECTED]> [mailto:Thomas Gagné <[EMAIL PROTECTED]>] Sent: Tuesday, March 13, 2007 7:24 AMTo: users@activemq.apache.orgSubject: Re: ActiveMQ with Sybase for persistence W

Re: ActiveMQ with Sybase for persistence

2007-03-13 Thread James Strachan
On 3/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 doc

Re: ActiveMQ with Sybase for persistence

2007-03-13 Thread Thomas Gagné
Which version? 12.5.1's documentation includes syntax for "FOR UPDATE". [EMAIL PROTECTED] wrote: > Does anyone have a working example of using ActiveMQ with Sybase ASE > as the persistence store? The online docs make mention that Sybase is > supported but ASE does not support SELECT FOR UPDATE and

ActiveMQ with Sybase for persistence

2007-03-13 Thread Christopher . Mathrusse
Does anyone have a working example of using ActiveMQ with Sybase ASE as the persistence store? 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.   Thanks