主键表(DorkingInfo)hbm.xml:    <class name="pojo.DorkingInfo" table="DorkingInfo" schema="dbo" catalog="TraceSystem">
        <id name="dorkingNumber" type="java.lang.Integer">
            <column name="DorkingNumber" />
            <generator class="identity" />
        </id>
        <set name="productTraceInfos" inverse="true">
            <key>
                <column name="DorkingNumber" />
            </key>
            <one-to-many class="pojo.ProductTraceInfo" />
        </set>
    </class>
外键表(ProductTraceInfo)hbm.xml:        <many-to-one name="dorkingInfo" class="pojo.DorkingInfo" fetch="select" outer-join="true" lazy="false">
            <column name="DorkingNumber" />
        </many-to-one>HQL语句如下:                                                   
from ProductTraceInfo p,DorkingInfo d where p.DorkingNumber=d.dorkingNumber and d.dorkingNumber=1异常如下:
org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: DorkingNumber of: pojo.ProductTraceInfo [from pojo.ProductTraceInfo p,pojo.DorkingInfo d where p.DorkingNumber=d.dorkingNumber and d.dorkingNumber=1]; nested exception is org.hibernate.QueryException: could not resolve property: DorkingNumber of: pojo.ProductTraceInfo [from pojo.ProductTraceInfo p,pojo.DorkingInfo d where p.DorkingNumber=d.dorkingNumber and d.dorkingNumber=1]
Caused by: org.hibernate.QueryException: could not resolve property: DorkingNumber of: pojo.ProductTraceInfo [from pojo.ProductTraceInfo p,pojo.DorkingInfo d where p.DorkingNumber=d.dorkingNumber and d.dorkingNumber=1]
彻底无语

解决方案 »

  1.   

    从主键表的hbm.xml里看,应该是没错啊
      

  2.   

    p.DorkingNumber
    改为
    p.dorkingNumber
      

  3.   

    (ProductTraceInfo)hbm.xml: 
    里没有定义 DorkingNumber !
      

  4.   

    我觉得也是4楼的对,但是因为外键表里的DorkingNumber与主键表里的DorkingNumber相连,所以hibernate生成影射文件的时候就这样了....不知道怎么写
      

  5.   

    我这样写的
    from ProductTraceInfo p,DorkingInfo d where p.dorkingInfo.dorkingNumber=d.dorkingNumber and d.dorkingNumber=查后返回了个List对象size()为1,说明应该是查出了单条记录,但是instanceof就是查不出它是什么类的.
    (list).get(0).getClass()输出:class [Ljava.lang.Object;
    (obj).get(0).toString()输出:[Ljava.lang.Object;@1945a5a剩下的我就迷茫了....麻烦大家一定帮我解决下啊