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

2005-11-01 Thread Siming Weng
A defected connector/j 3.1.4 beta is used when the project is initially created. It failed to map unsigned bigint to java.math.BigInteger. Thanks a lot for your assistance. On 10/28/05, Jeff Butler <[EMAIL PROTECTED]> wrote: > I've tried your exact example (as close as I can replicate), and don't

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

2005-10-27 Thread Jeff Butler
I've tried your exact example (as close as I can replicate), and don't have any errors - and the values comes back as expected.  MySql returns a Long for signed bigint fields, and a BigInteger for unsigned bigint fields.   If your database field is unsigned, then you must set the type in your POJO

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

2005-10-26 Thread Siming Weng
Hi, The problem still exists. Here's my situation: I have a field in table in MySQL, unsigned bigint(20) time_stamp I have a result class which has a member "private long timeStamp" ... ... the value in database is 1428387426 whose binary format is 1010101001000110111011001100010 the value in

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

2005-10-26 Thread Siming Weng
I'll have a go later. Thank you for the quick response. On 10/26/05, Jeff Butler <[EMAIL PROTECTED]> wrote: > iBATIS does not have a type handler for BigInteger - because there is no > "getBigInteger()" method on a result set. iBATIS will call getObject() if > it doesn't know what the data type i

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

2005-10-26 Thread Jeff Butler
iBATIS does not have a type handler for BigInteger - because there is no "getBigInteger()" method on a result set.  iBATIS will call getObject() if it doesn'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 c