getting bigint and BigInteger to work.. 
Author Message
 getting bigint and BigInteger to work..
Has anyone managed to retrieve bigint values from SQL2000
using the JDBC driver like the following:
...
<B>
ResultSet rs = stmt.execute(...);
BigInteger b = rs.getBigInteger("SomeBigInteger");
</B>
...
I always get an error when trying to do this.  Something
about the driver not supporting TDS_INT8 type or
something.  Can anyone help?

-Kilwrath



Sat, 22 May 2004 05:57:06 GMT
 getting bigint and BigInteger to work..

just a thought -- i did this before MS released this driver -- try getLong
instead.  A java Long is the same thing -- 8 bytes (long) instead of 4
(int).


Quote:
> Has anyone managed to retrieve bigint values from SQL2000
> using the JDBC driver like the following:
> ...
> <B>
> ResultSet rs = stmt.execute(...);
> BigInteger b = rs.getBigInteger("SomeBigInteger");
> </B>
> ...
> I always get an error when trying to do this.  Something
> about the driver not supporting TDS_INT8 type or
> something.  Can anyone help?

> -Kilwrath



Sat, 22 May 2004 06:38:08 GMT
 getting bigint and BigInteger to work..
Hi,

Did you ever find a solution for this?

I have the same problem.

Thanks, Serge


Quote:
> Has anyone managed to retrieve bigint values from SQL2000
> using the JDBC driver like the following:
> ...
> <B>
> ResultSet rs = stmt.execute(...);
> BigInteger b = rs.getBigInteger("SomeBigInteger");
> </B>
> ...
> I always get an error when trying to do this.  Something
> about the driver not supporting TDS_INT8 type or
> something.  Can anyone help?

> -Kilwrath



Tue, 01 Jun 2004 19:09:41 GMT
 getting bigint and BigInteger to work..

Quote:

> Hi,

> Did you ever find a solution for this?

> I have the same problem.

> Thanks, Serge

change the nullability of the column, or wait till the next
version of the driver comes out.
Joe
Quote:



> > Has anyone managed to retrieve bigint values from SQL2000
> > using the JDBC driver like the following:
> > ...
> > <B>
> > ResultSet rs = stmt.execute(...);
> > BigInteger b = rs.getBigInteger("SomeBigInteger");
> > </B>
> > ...
> > I always get an error when trying to do this.  Something
> > about the driver not supporting TDS_INT8 type or
> > something.  Can anyone help?

> > -Kilwrath



Wed, 02 Jun 2004 03:20:59 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. bigint doesnt work

2. bigint doesnt work

3. bigint doesnt work

4. bigint doesnt work

5. no math found in shared library path java/math/BigInteger

6. Getting Groupwise to work with SQL Mail

7. Problem getting OSQL to work with Desktop 2000(MSDE)

8. Getting merge replication to work with BCP / DTS

9. Getting the RecordCount using ADO (Only works Sometimes!!)

10. Getting SQL Server 6.5 to Work!

11. Trouble getting QA SP Debugger working


 
Powered by phpBB® Forum Software