org.hibernate.PropertyNotFoundException: no appropriate constructor in class

 

 

hql.append("SELECT NEW com.coscon.cbs.domain.result.settlement.SettlementCommissionSumDetailResult(companys.companyNameCn,commCntr.containerSizeType,");
		hql.append(" companyChargeCode.settlementChargeCodeDescription,");
		hql.append(" commCntr.commissionCurrencyCode,");
		hql.append(" COUNT(*),SUM(commCntr.commissionAmount))");
		hql.append(" FROM com.coscon.cbs.domain.model.settlement.SettlementHead  settlementHead,");
		

 注意这里的 COUNT 的类型要写成.Long 或 int ,因为数据库自动生成的number字段,对应的是 BigDecimal,所以我在定制结果集

的时候也写成了.BigDecimal 不应该啊,

 

List<Object[]>  list = querys.list();
		for (Object[] objects : list) {
			String name1 = (String)objects[0];
			String name2 = (String)objects[1];
			String name3 = (String)objects[2];
			String name4 = (String)objects[3];
			Long name5 = (Long)objects[4];
			BigDecimal name6 = (BigDecimal)objects[5];
		}
//		return querys.list();
		return list;

 后来通过遍历结果集的时候,才发现类型转换异常.. 这次写下来是为了加深一下印象.

 

	public SettlementCommissionSumDetailResult(String companyNameCn,
			String containerSizeType, String settlementChargeCodeDescription,
			String commissionCurrencyCode, Long containerNumbers,
			BigDecimal commissionAmounts) {

		this.companyNameCn = companyNameCn;
		this.containerSizeType = containerSizeType;
		this.settlementChargeCodeDescription = settlementChargeCodeDescription;
		this.commissionCurrencyCode = commissionCurrencyCode;
		this.containerNumbers = containerNumbers;
		this.commissionAmounts = commissionAmounts;
	}

 以后不要再犯类似的错误了..

 

 

org.hibernate.PropertyNotFoundException: no appropriate constructor in class: com.coscon.cbs.domain.result.settlement.SettlementCommissionSumDetailResult

 

出现这种错误在定制结果集的时候 无非就这么几种情况..

1.在写New后面的字段()里边的字段的个数和他们对应的类型,要和结果集的字段相对应.(不多不少) 

2.注意","号不漏了..注意好细节..

 

 

只要认真检查一下. 问题是可以很快的解决的..

 

在开发的过程中我看到了一篇关于 hibernate HQL的总结 好帖子 

 

http://kuangbaoxu.iteye.com/blog/193076 总结的很不错哦~~~