org.hibernate.PropertyNotFoundException: no appropriate constructor in class

最新推荐文章于 2021-06-24 20:57:05 发布

iteye_4568

最新推荐文章于 2021-06-24 20:57:05 发布

阅读量657

点赞数

本文链接：https://blog.youkuaiyun.com/iteye_4568/article/details/82158431

版权

hibernate 专栏收录该内容

14 篇文章

订阅专栏

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 总结的很不错哦~~~