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 Wed, 14 Mar 2007 20:09:39 GMT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META boundary="----=_Part_23514_9916868.1173902403654" alternative; multipart 
Content-Type:>
<META http-equiv=Content-Type content="text/html; charset=us-ascii" 
Content-Type: ------="_Part_23514_9916868.1173902403654" inline 
Content-Disposition: html; text 7bit Content-Transfer-Encoding:>
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=041060920-14032007>Sure. I can give it a try and see if it 
works.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=041060920-14032007></SPAN></FONT>&nbsp;</DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=041060920-14032007>Thanks for the quick turn around on this. With a bit of 
luck all will work well.</SPAN></FONT></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> Wednesday, March
14, 2007 
1:00 PM<BR><B>To:</B> "Christopher.Mathrusse<BR><B>Cc:</B>

users@activemq.apache.org<BR><B>Subject:</B> Re: ActiveMQ with Sybase for

persistence<BR></FONT><BR></DIV>
<DIV></DIV>I've just raised a JIRA to track this...<BR><BR><A 
href="http://issues.apache.org/activemq/browse/AMQ-1204">http://issues.apache.org/activemq/browse/AMQ-1204</A><BR><BR>and

have commited a patch using "DECIMAL" as the long integer and using the SQL 
statement "LOCK TABLE foo IN EXCLUSIVE MODE" for the exclusive lock. <BR><BR>Do

you want to try tomorrow's 4.2-SNAPSHOT build to see if this works?<BR><BR><BR>
<DIV><SPAN class=gmail_quote>On 3/14/07, <B class=gmail_sendername><A

href="mailto:Christopher.Mathrusse@sybase.com">Christopher.Mathrusse@sybase.com 
</A></B>&lt;<A 
href="mailto:Christopher.Mathrusse@sybase.com">Christopher.Mathrusse@sybase.com</A>&gt;

wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote 
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
  <DIV>
  <DIV dir=ltr align=left><SPAN><FONT face=Arial color=#0000ff size=2>For
a 
  large integer you can use the numeric data type. </FONT></SPAN></DIV>
  <DIV dir=ltr align=left><SPAN><FONT face=Arial color=#0000ff size=2>Per
the 
  Sybase ASE documentation for ASE 12.5:</FONT></SPAN></DIV>
  <DIV dir=ltr align=left><SPAN><FONT face=Arial color=#0000ff size=2><A

  onclick="return top.js.OpenExtLink(window,event,this)" 
  href="http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/15426;pt=15426#X"

  target=_blank>http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/15426;pt=15426#X</A></FONT></SPAN></DIV>
  <DIV dir=ltr align=left><SPAN><FONT face=Arial color=#0000ff 
  size=2></FONT></SPAN>&nbsp;</DIV><SPAN>
  <DIV dir=ltr align=left>
  <TABLE border=2>
    <TBODY>
    <TR>
      <TD>
        <P><FONT color=red size=+3><B>Datatypes</B></FONT> by
category</P></TD>
      <TD>
        <P>Synonyms</P></TD>
      <TD>
        <P>Range</P></TD>
      <TD>
        <P>Bytes of storage</P></TD></TR>
    <TR>
      <TD>
        <P><I>Exact numeric: integers</I> </P></TD></TR>
    <TR>
      <TD>
        <P>tinyint</P></TD>
      <TD>
        <P></P></TD>
      <TD>
        <P>0 to 255 (Negative numbers are not permitted.)</P></TD>
      <TD>
        <P>1</P></TD></TR>
    <TR>
      <TD>
        <P>smallint</P></TD>
      <TD>
        <P></P></TD>
      <TD>
        <P>215 -1 (32,767) to -215 (-32,768)</P></TD>
      <TD>
        <P>2</P></TD></TR>
    <TR>
      <TD>
        <P>int </P></TD>
      <TD>
        <P>integer</P></TD>
      <TD>
        <P>231 -1 (2,147,483,647) to -231 (-2,147,483,648</P></TD>
      <TD>
        <P>4</P></TD></TR>
    <TR>
      <TD>
        <P><I>Exact numeric: decimals</I> </P></TD></TR>
    <TR>
      <TD>
        <P>numeric (p, s)</P></TD>
      <TD>
        <P></P></TD>
      <TD>
        <P>1038 -1 to -1038</P></TD>
      <TD>
        <P>2 to 17</P></TD></TR></TBODY></TABLE></DIV>
  <DIV dir=ltr align=left><FONT face=Arial color=#0000ff 
  size=2></FONT>&nbsp;</DIV>
  <DIV dir=ltr align=left><FONT face=Arial color=#0000ff 
  size=2></FONT>&nbsp;</DIV>
  <DIV dir=ltr align=left>&nbsp;</DIV>
  <DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN>As
far as 
  locking goes I think you want to use HOLDLOCK. This would be specified after 
  the table name and not at the end of the select statement. It changes the 
  isolation level of the transaction to level 3 
  (serializable).</SPAN></FONT></DIV>
  <DIV dir=ltr align=left><FONT face=Arial color=#0000ff 
  size=2><SPAN></SPAN></FONT>&nbsp;</DIV>
  <DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN><A

  onclick="return top.js.OpenExtLink(window,event,this)" 
  href="http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/53713;pt=53713#X"

  target=_blank>http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/53713;pt=53713#X</A></SPAN></FONT></DIV>
  <DIV dir=ltr align=left><FONT face=Arial color=#0000ff 
  size=2><SPAN></SPAN></FONT>&nbsp;</DIV>
  <DIV dir=ltr align=left><FONT size=+0><SPAN></SPAN></FONT><FONT
face=Arial 
  color=#0000ff size=2><SPAN>Thanks for the help on 
  this.</SPAN></FONT></DIV></SPAN><BR>
  <DIV lang=en-us dir=ltr align=left>
  <HR>
  <FONT face=Tahoma size=2><SPAN class=q><B>From:</B> "James Strachan"
&lt;<A 
  onclick="return top.js.OpenExtLink(window,event,this)" 
  href="mailto:james.strachan@gmail.com" 
  target=_blank>james.strachan@gmail.com</A>&gt; [mailto:"James Strachan" &lt;<A

  onclick="return top.js.OpenExtLink(window,event,this)" 
  href="mailto:james.strachan@gmail.com" 
  target=_blank>james.strachan@gmail.com</A>&gt;] <BR></SPAN><B>Sent:</B>

  Wednesday, March 14, 2007 1:32 AM<BR><B>To:</B> <A 
  onclick="return top.js.OpenExtLink(window,event,this)" 
  href="mailto:users@activemq.apache.org" 
  target=_blank>users@activemq.apache.org</A><SPAN class=q><BR><B>Subject:</B>

  Re: ActiveMQ with Sybase for persistence<BR></SPAN></FONT><BR></DIV><SPAN

  class=q>
  <DIV></DIV>On 3/14/07, <A 
  onclick="return top.js.OpenExtLink(window,event,this)" 
  href="mailto:Christopher.Mathrusse@sybase.com" 
  target=_blank>Christopher.Mathrusse@sybase.com</A> <BR></SPAN><SPAN

  class=q>wrote: <BR>&gt; I've been trying to get this to work still and I now

  see an exception <BR>&gt; pertaining to BIGINT. It appears that Sybase ASE 
  only began support for <BR>&gt; BIGINT in version 15. I'm stuck on <A 
  onclick="return top.js.OpenExtLink(window,event,this)" href="http://12.0.0.8" 
  target=_blank>12.0.0.8</A>. Any suggestions as to a <BR>&gt; workaround
for 
  this? Also I searched through the documentation on ASE 15 but <BR>&gt; found 
  nothing pertaining to XLOCK. Am I missing something here? <BR><BR>Any idea 
  what the correct SQL is for the following on Sybase 12.x <BR><BR>* creating
an 
  exclusive row/table lock <BR>* a large integer column <BR><BR>Then we
can 
  create a JDBC adapter to handle your db <BR>-- <BR><BR>James <BR>-------

  <BR><A onclick="return top.js.OpenExtLink(window,event,this)" 
  href="http://radio.weblogs.com/0112098/" 
  target=_blank>http://radio.weblogs.com/0112098/</A> 
<BR><BR></SPAN></DIV></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- 
<BR><BR>James<BR>-------<BR><A 
href="http://radio.weblogs.com/0112098/">http://radio.weblogs.com/0112098/</A> 
</BODY></HTML>


Mime
View raw message