java.math.BigInteger cannot be cast to java.lang.Long錯誤的解決方案

場景

mysql數據庫中

字段為`authority_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '權限ID',

問題

public interface BmRoleAuthorityRepository extends JpaRepository{
 
@Query(value = "SELECT authority_id FROM bm_role_authority where role_id = ?1", nativeQuery = true)
List getAllAuthorityIdByRoleId(Long roleId);

直接執行，獲取到的List是

之后我想循環authorityIdList

for (Long authorityId : authorityIdList) {

結果報錯：

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

解決方案

沒有看到有什么特別好的方法，只能將BigInterger的List先轉換為String，然后再轉換為Long List

 
List authorityIdList = bmRoleAuthorityRepository.getAllAuthorityIdByRoleId(roleId);
 
if(authorityIdList == null || authorityIdList.isEmpty()) {
   authorityIdList = new ArrayList<>();
}
String idArray = JSONArray.toJSONString(authorityIdList);

之后再處理這個String，將其轉換為Long list

 
// [1,2,3] convert to String[]
String[] split = StringUtils.split(StringUtils.substring(allAuthorityIdByRoleId, 1,
        allAuthorityIdByRoleId.length() - 1), ",");
// guava 將String[] convert to Long[]
authorityIdList.addAll(Lists.transform(Arrays.asList(split), Longs.stringConverter()));