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 19:27:22 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=285554515-14032007><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 class=285554515-14032007><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 class=285554515-14032007><FONT face=Arial 
color=#0000ff size=2><A 
href="http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/15426;pt=15426#X">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 class=285554515-14032007><FONT face=Arial 
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV><SPAN class=285554515-14032007>
<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>
      <P>Synonyms</P>
    <TD>
      <P>Range</P>
    <TD>
      <P>Bytes of storage</P>
  <TR>
    <TD>
      <P><I>Exact numeric: integers</I> </P>
  <TR>
    <TD>
      <P>tinyint</P>
    <TD>
      <P></P>
    <TD>
      <P>0 to 255 (Negative numbers are not permitted.)</P>
    <TD>
      <P>1</P>
  <TR>
    <TD>
      <P>smallint</P>
    <TD>
      <P></P>
    <TD>
      <P>215 -1 (32,767) to -215 (-32,768)</P>
    <TD>
      <P>2</P>
  <TR>
    <TD>
      <P>int </P>
    <TD>
      <P>integer</P>
    <TD>
      <P>231 -1 (2,147,483,647) to -231 (-2,147,483,648</P>
    <TD>
      <P>4</P>
  <TR>
    <TD>
      <P><I>Exact numeric: decimals</I> </P>
  <TR>
    <TD>
      <P>numeric (p, s)</P>
    <TD>
      <P></P>
    <TD>
      <P>1038 -1 to -1038</P>
    <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 
class=285554515-14032007>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 
class=285554515-14032007></SPAN></FONT>&nbsp;</DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=285554515-14032007><A 
href="http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/53713;pt=53713#X">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 
class=285554515-14032007></SPAN></FONT>&nbsp;</DIV>
<DIV dir=ltr align=left><FONT><SPAN class=285554515-14032007></SPAN></FONT><FONT

face=Arial color=#0000ff size=2><SPAN class=285554515-14032007>Thanks for the 
help on this.</SPAN></FONT></DIV></SPAN><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:32 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/14/07, Christopher.Mathrusse@sybase.com 
<BR><CHRISTOPHER.MATHRUSSE@SYBASE.COM>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 12.0.0.8. 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>http://radio.weblogs.com/0112098/ <BR><BR></BODY></HTML>


Mime
View raw message