Projections.rowCount could return a wrong result when joining is used in the criteria. I used “setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)” in the criteria to get the distinct items but it doesn’t work with Projections.rowCount.
This won’t work, it still contain duplicates:
public Criteria countDefaultCriteria(){
return getIncidentsDefaultCriteria().setProjection(Projections.rowCount());
}
This give the correct row count:
public Criteria countDefaultCriteria(){
return getIncidentsDefaultCriteria().setProjection(Projections.countDistinct("objID"));
}
Recent Comments