这个问题是因为hql语句中有对象找不到.比如下面这个语句,就出现这个错误: 比如from BCWzbm wz,DCTempcodeaudit audit where wz.sflsbm=1 and audit.orgcode='0804' and audit.BCWzbm.wzno=wz.wzno and audit.spsj = (select max(spsj) from DCTempcodeaudit where DCTempcodeaudit.BCWzbm.wzno=wz.wzno group by DCTempcodeaudit.BCWzbm.wzno) 在()中的内联视图中,要使用外面语句的别名,即: from BCWzbm wz,DCTempcodeaudit audit where wz.sflsbm=1 and audit.orgcode='0804' and audit.spsj = (select max(spsj) from audit where audit.BCWzbm.wzno=wz.wzno group by audit.BCWzbm.wzno) 这样就正确执行了.还可参见: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1746
这一句错了.你可能用到了这句里面的对象的值,可是这里面没有值,所以就出现了这个异常!
比如from BCWzbm wz,DCTempcodeaudit audit where wz.sflsbm=1 and audit.orgcode='0804' and audit.BCWzbm.wzno=wz.wzno and audit.spsj = (select max(spsj) from DCTempcodeaudit where DCTempcodeaudit.BCWzbm.wzno=wz.wzno group by DCTempcodeaudit.BCWzbm.wzno)
在()中的内联视图中,要使用外面语句的别名,即:
from BCWzbm wz,DCTempcodeaudit audit where wz.sflsbm=1 and audit.orgcode='0804' and audit.spsj = (select max(spsj) from audit where audit.BCWzbm.wzno=wz.wzno group by audit.BCWzbm.wzno)
这样就正确执行了.还可参见:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1746