Re: how to map unsigned bigint in MySql to long value

2005-11-01 Thread Siming Weng
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

Re: how to map unsigned bigint in MySql to long value

2005-10-26 Thread Siming Weng
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

Re: how to map unsigned bigint in MySql to long value

2005-10-26 Thread Siming Weng
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

how to map unsigned bigint in MySql to long value

2005-10-26 Thread Siming Weng
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