Cast bigint to long

I am getting data from a database. I am getting classcastex开发者_JAVA百科ception. In database my id is saved as BIGINT but in code(object) it is long. Is there is any problem while casting bigint to long?

---

have you tried casting your value to BigInteger first and then get the long value with longValue()? It should work. And aioobe is right, check for null values also.

cheers!

---

If this is MySql, you should probably use java.math.BigDecimal.

See the table at Java, JDBC and MySQL Types.

---

I was getting error java.math.BigInteger cannot be cast to java.lang.Long because I was getting the BigInteger while querying using Spring Data native query, so then I've resolved using below code.

((BigInteger)nativeQuery.getSingleResult()).longValue()