hibernate里使用联合主键composite-id映射查询

0 0

hibernate里使用联合主键composite-id映射查询0

通过联合主键查询数据库（ORACLE），出错信息为：
Exception in thread "main" org.hibernate.PropertyNotFoundException: Could not find setter for ID on class com.traffic.rest.data.bean.DimTraficonMap
at org.hibernate.property.ChainedPropertyAccessor.getSetter(ChainedPropertyAccessor.java:44)
at org.hibernate.transform.AliasToBeanResultTransformer.transformTuple(AliasToBeanResultTransformer.java:57)
at org.hibernate.hql.HolderInstantiator.instantiate(HolderInstantiator.java:69)
at org.hibernate.loader.custom.CustomLoader.getResultList(CustomLoader.java:330)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:150)
at dao.BaseDao.getCount(BaseDao.java:113)
at com.traffic.rest.dao.TrafficMapDao.get(TrafficMapDao.java:28)
at com.traffic.rest.dao.TrafficMapDao.main(TrafficMapDao.java:44)

执行查询的语句，其中hql为select * from dim_traficon_map where ID='124' and ZONE_ID='1969'

Query query = session.createSQLQuery(hql);
query.setResultTransformer(Transformers.aliasToBean(entityClass));
return query.list();

相关的javabean类

package com.traffic.rest.data.bean;
// Generated 2012-6-6 12:52:18 by Hibernate Tools 3.2.0.b9


import java.math.BigDecimal;

/**
 *        @hibernate.class
 *         table="DIM_TRAFICON_MAP"
 *     
 */
public class DimTraficonMap  implements java.io.Serializable {


     /**
      *                @hibernate.property
 *                 column="ID"
 *             
     */
     private BigDecimal id;
     /**
      *                @hibernate.property
 *                 column="ZONE_ID"
 *             
     */
     private BigDecimal zoneId;
     /**
      *            @hibernate.property
 *             column="IP"
 *             length="128"
 *         
     */
     private String ip;
     /**
      *            @hibernate.property
 *             column="CA"
 *             length="50"
 *         
     */
     private String ca;
     /**
      *            @hibernate.property
 *             column="LID"
 *             length="22"
 *             not-null="true"
 *         
     */
     private BigDecimal lid;

    public DimTraficonMap() {
    }

	
    public DimTraficonMap(BigDecimal id, BigDecimal zoneId, BigDecimal lid) {
        this.id = id;
        this.zoneId = zoneId;
        this.lid = lid;
    }
    public DimTraficonMap(BigDecimal id, BigDecimal zoneId, String ip, String ca, BigDecimal lid) {
       this.id = id;
       this.zoneId = zoneId;
       this.ip = ip;
       this.ca = ca;
       this.lid = lid;
    }
   
    /**       
     *      *                @hibernate.property
     *                 column="ID"
     *             
     */
    public BigDecimal getId() {
        return this.id;
    }
    
    public void setId(BigDecimal id) {
        this.id = id;
    }
    /**       
     *      *                @hibernate.property
     *                 column="ZONE_ID"
     *             
     */
    public BigDecimal getZoneId() {
        return this.zoneId;
    }
    
    public void setZoneId(BigDecimal zoneId) {
        this.zoneId = zoneId;
    }
    /**       
     *      *            @hibernate.property
     *             column="IP"
     *             length="128"
     *         
     */
    public String getIp() {
        return this.ip;
    }
    
    public void setIp(String ip) {
        this.ip = ip;
    }
    /**       
     *      *            @hibernate.property
     *             column="CA"
     *             length="50"
     *         
     */
    public String getCa() {
        return this.ca;
    }
    
    public void setCa(String ca) {
        this.ca = ca;
    }
    /**       
     *      *            @hibernate.property
     *             column="LID"
     *             length="22"
     *             not-null="true"
     *         
     */
    public BigDecimal getLid() {
        return this.lid;
    }
    
    public void setLid(BigDecimal lid) {
        this.lid = lid;
    }




}

相应的HBM文件

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
    
<hibernate-mapping>
<!-- 
    Created by the Middlegen Hibernate plugin 2.1

    http://boss.bekk.no/boss/middlegen/
    http://www.hibernate.org/
-->

<class 
    name="com.traffic.rest.data.bean.DimTraficonMap" 
    table="DIM_TRAFICON_MAP"
>

    <composite-id>
        <key-property 
            name="id" 
            column="ID" 
            type="java.math.BigDecimal"
            length="22"
        ></key-property>
        
        <key-property 
            name="zoneId" 
            column="ZONE_ID" 
            type="java.math.BigDecimal"
            length="22"
        ></key-property>
    </composite-id>    

    <property
        name="ip"
        type="java.lang.String"
        column="IP"
        length="128"
    ></property>
    
    <property
        name="ca"
        type="java.lang.String"
        column="CA"
        length="50"
    ></property>
    
    <property
        name="lid"
        type="java.math.BigDecimal"
        column="LID"
        not-null="true"
        length="22"
    ></property>

</class>
</hibernate-mapping>