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
Phillip Moreloc #2 / 4
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
Serge Sozonof #3 / 4
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
Joseph Weinstei #4 / 4
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?
getting bigint and BigInteger to work..