sql语句中取最大值 转换BigDecimal类型

             sql.append(" SELECT dc.ID as \"deviceCompositionId\", ");             sql.append(" dc.PREID as \"deviceCompositionPreId\", ");             sql.append(" dc.TOPID as \"deviceCompositionTopId\", ");             sql.append(" dc.COMPANYID as \"deviceCompositionCompanyId\", ");             sql.append(" dc.name as \"deviceCompositionName\", ");             sql.append(" dc.viewOrder as \"deviceCompositionViewOrder\", ");             sql.append(" mi.MODULE_ID as \"moduleId\", ");             sql.append(" mi.MODULE_NAME as \"moduleName\", ");// 这边是对fault_level 取最大值 然后插入实体类的faultMaxLevel 类型是BigDecimal            sql.append(" (select max(fault_level) from fault_info where module_id = mi.MODULE_ID ) as \"faultMaxLevel\",");//同上             sql.append(" (select count(0) from fault_info where module_id = mi.MODULE_ID group by module_id) as \"faultNumber\" ");             sql.append(" FROM ((COMPOSITION_MODULEINFO cm ");             sql.append(" RIGHT JOIN DEVICECOMPOSITION dc ");             sql.append(" ON dc.id = cm.devcom_id) ");             sql.append(" LEFT JOIN MODULE_INFO mi");             sql.append(" ON cm.module_id = mi.module_id ) ");             sql.append(" where  1=1 and (mi.enable = '1' or mi.enable is null) ");             sql.append(" order by dc.viewOrder,dc.ID,mi.module_id ");                     Query query =sessionFactory.getCurrentSession().createSQLQuery(sql.toString());        Query transQuery = query.setResultTransformer(Transformers.aliasToBean(DeviceCompositionMouduleDTO.class));//报错 显示在这一行~        List<DeviceCompositionMouduleDTO> list=transQuery.list();