<!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> </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> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left> </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> </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> </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"
<james.strachan@gmail.com> [mailto:"James Strachan"
<james.strachan@gmail.com>] <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>> I've been trying
to get
this to work still and I now see an exception <BR>> pertaining to BIGINT. It
appears that Sybase ASE only began support for <BR>> BIGINT in version 15.
I'm stuck on 12.0.0.8. Any suggestions as to a <BR>> workaround for this?
Also I searched through the documentation on ASE 15 but <BR>> 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>
|