Criteria crt = getSession().createCriteria(StockSituationstock.class); crt.setProjection(Projections.projectionList().add(Projections.groupProperty("stockArticle.comp_id.codearti")).add(Projections.groupProperty("stockArticle.comp_id.codemaga")).add(Projections.max("datesitu")));//.addOrder(Order.desc("datesitu")); List res=crt.list(); // retourne Liste de type Object et n'accepte pas le casting
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questioncrt.setResultTransformer(Transformers.aliasToBean(BeanVoulu.class));
Criteria crt = getSession().createCriteria(StockSituationstock.class); crt.setProjection(Projections.projectionList().add(Projections.groupProperty("stockArticle.comp_id.codearti")).add(Projections.groupProperty("stockArticle.comp_id.codemaga")).add(Projections.max("datesitu")));//.addOrder(Order.desc("datesitu")); crt.setProjection(Projections.projectionList().add(Property.forName("datesitu"),"datesitu").add(Property.forName("comp_id"),"comp_id")); crt.setResultTransformer(Transformers.aliasToBean(StockSituationstock.class));
org.hibernate.QueryException: property does not map to a single column: comp_id at org.hibernate.loader.criteria.CriteriaQueryTranslator.getColumn(CriteriaQueryTranslator.java:371) at org.hibernate.criterion.PropertyProjection.toSqlString(PropertyProjection.java:41) at org.hibernate.criterion.AliasedProjection.toSqlString(AliasedProjection.java:27) at org.hibernate.criterion.ProjectionList.toSqlString(ProjectionList.java:49)
<composite-id name="comp_id" class="entity.StockSituationstockPK"> <key-property name="joursitu" column="JOURSITU" type="java.math.BigDecimal" length="22" /> <key-property name="moissitu" column="MOISSITU" type="java.math.BigDecimal" length="22" /> <key-property name="annesitu" column="ANNESITU" type="java.math.BigDecimal" length="22" /> </composite-id>