New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use MySQL BIGINT in Java?

807601Jan 2 2008 — edited Jan 4 2008

after some SQL I get this error..

com.mysql.jdbc.exceptions.MySQLDataException: '1.186569750717E12' in column '1' is outside valid range for the datatype INTEGER.

which makes sense to me.. after looking with phpmyadmin and it said the column is a BIGINT.. why the hell anyone did that I don't know but I'll have to work with it

now since all other programmers here are with PHP and they don't have anything to do with datatypes they ain't much help..

how am I supposed to use this thing?
I figured I could just use a long or a double and do something like resultset.getBigInt instead of resultset.getInt but that option isn't there..

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2008

Added on Jan 2 2008

4 comments

8,536 views