Hi,
I'm trying to map a table field of unsigned bigint to long value in
java. But it always give wrong numbers looks like being overflow. Pure
JDBC code can return the correct value.
JDBC documenation says RecordSet.getObject(int columnIndex) will
return a java.math.BigInteger if the field is uns
oesn't know what the data type is (i.e. if you use a Map as a result, or
> if the property in your result class is of type Object) - then you could
> cast it yourself. This will mimic what you are doing in JDBC.
>
> Jeff Butler
>
>
> On 10/26/05, Siming Weng <[EMAIL PR
the data type is (i.e. if you use a Map as a result, or
> if the property in your result class is of type Object) - then you could
> cast it yourself. This will mimic what you are doing in JDBC.
>
> Jeff Butler
>
>
> On 10/26/05, Siming Weng <[EMAIL PROTECTED] > wro
and cast it yourself to BigInteger. If the database field is
> signed, then either Long or long will work. I did get a weird result when I
> tried the Long/unsigned combination (as expected - there is a loss of
> precision in that case).
>
> I tried it with MySQL 5.0.15, and connector/j 3
