有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

java Hibernate Groupby sum

我想在hibernate中获得groupby sum。但是出现了一个名为“java.lang.ClassCastException:[Ljava.lang.Object;无法强制转换到”的错误,如何解决这个问题

这就是我想要的

select sum(this_.actual_qty), this_.c_code from m_crop_projections this_ where this_.cc_code='1089' and this_.entered_date='2018-03-22' group by this_.c_code

冬眠

@Override
public List<CropProjections> doInHibernate(Session session) throws HibernateException {
    System.out.println("inside repo-----"+colCode);
    System.out.println("inside repo-----"+date);
    Date convert_date = getUtilDate(date);

    Criteria criteria = session.createCriteria(CropProjections.class, "cp");

    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.alias(Projections.sum("actualqty"),"cp.actualqty"));
    projList.add(Projections.groupProperty("cropcode"));


    criteria.add(Restrictions.eq("colcode", colCode));
    criteria.add(Restrictions.eq("entereddate", convert_date));
    criteria.setProjection(projList);
    return criteria.list();
}

服务级别

@Override
@Transactional
public List<CropProjectionsDTO> getTotalReadyQty(String colCode, String date) {
    List<CropProjectionsDTO> list = new ArrayList<CropProjectionsDTO>();
    List<CropProjections> cropPrcojections = cropProjectionsDAO.getTotalReadyQty(colCode,date);     

    System.out.println(cropPrcojections);

    if (cropPrcojections.isEmpty()) {
        System.out.println("cropPrcojections Data Null-------");
    } else {
        System.out.println("cropPrcojections Data not-Null-------");
        for (CropProjections cropPro : cropPrcojections) {

            CropProjectionsDTO dto = new CropProjectionsDTO();
            dto.setActualqty(cropPro.getActualqty());
            dto.setCropcode(cropPro.getCropcode());

            System.out.println(cropPro.getActualqty());
            System.out.println(cropPro.getCropcode());
            list.add(dto);
        }
    }

    return list;
}

服务类中的for循环发生错误。然而,croprcojects具有hibernate查询无法解析的值。错误是CropprProject无法强制转换为cropPro。。如何解决这个问题


共 (0) 个答案