java.math.BigInteger cannot be cast to java.lang.Long

I’m getting the following exception.

Caused by: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long

with the following code:

@Query(value = "SELECT id FROM "+ GlobalConsts.INTELLIF_STATIC + "." +GlobalConsts.T_NAME_OTHER_DETAIL +" WHERE indexed < 0 and from_image_id = :from_image_id ", nativeQuery = true) List<Long> findFailedId(@Param("from_image_id")long from_image_id); List<Long> failedIds = otherDetailDao.findFailedId(key); List<String> failedList = new ArrayList<String>(); for (Long id : failedIds) { String url = ResourceHelper.generateFileName(id); String idStr = ResourceHelper.decodeResourceId(url); failedList.add(idStr); }

解决方法： 在mysql中，long类型的字段都用bigint来表示，所以在进行hibernate进行解析的时候，会变成BigInteger，而这时我们却用Long类型来进行解析，会直接报异常：

java.math.BigInteger cannot be cast to java.lang.Long

在这里需要修改如下代码：(如果我们需要用到long类型的字段，可以将BigInteger类型转化为long型，xxx.intValue())

@Query(value = "SELECT id FROM "+ GlobalConsts.INTELLIF_STATIC + "." +GlobalConsts.T_NAME_OTHER_DETAIL +" WHERE indexed < 0 and from_image_id = :from_image_id ", nativeQuery = true) List<BigInteger> findFailedId(@Param("from_image_id")long from_image_id); List<BigInteger> failedIds = otherDetailDao.findFailedId(key); List<String> failedList = new ArrayList<String>(); for (BigInteger id : failedIds) { long faiedId = id.intValue(); String url = ResourceHelper.generateFileName(failedId); String idStr = ResourceHelper.decodeResourceId(url); failedList.add(idStr); }