Java开发网 - 关于hibernate中的Named query not known问题

Java开发网

您没有登录

» Java开发网 » Java EE 综合讨论区 » Hibernate

打印话题 寄给朋友 订阅主题

作者

关于hibernate中的Named query not known问题

wjb_0827

发贴: 2
积分: 0

于 2006-08-11 09:06

有如下代码：
SysPerson sysPerson=getPersonUuidByOrgCode(orgCode);
public SysPerson getPersonUuidByOrgCode(String orgCode) {
String sql="from SysPerson sysperson where sysperson.personUuid in( select sysapproleperson.personUuid from SysApprolePerson sysapproleperson where sysapproleperson.personUuid in( select sysorgperson.personUuid from SysOrgperson sysorgperson where sysorgperson.orgUuid in(select sysorg.orgUuid from SysOrg sysorg where sysorg.orgCode like '%"+orgCode+"%'))and sysapproleperson.roleCode='"+receive+"')";
List persons=getHibernateTemplate().findByNamedQuery(sql);
if(persons.isEmpty()){
  return null;
}
return (SysPerson)persons.get(0);
}

执行这段代码的时候报错：
下列异常已记录 org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.orm.hibernate3.HibernateSystemException: Named query not known: from SysPerson sysperson where sysperson.personUuid in( select sysapproleperson.personUuid from SysApprolePerson sysapproleperson where sysapproleperson.personUuid in( select sysorgperson.personUuid from SysOrgperson sysorgperson where sysorgperson.orgUuid in(select sysorg.orgUuid from SysOrg sysorg where sysorg.orgCode like '%012430301%'))and sysapproleperson.roleCode='FurlConfidentialSecretary'); nested exception is org.hibernate.MappingException: Named query not known: from SysPerson sysperson where sysperson.personUuid in( select sysapproleperson.personUuid from SysApprolePerson sysapproleperson where sysapproleperson.personUuid in( select sysorgperson.personUuid from SysOrgperson sysorgperson where sysorgperson.orgUuid in(select sysorg.orgUuid from SysOrg sysorg where sysorg.orgCode like '%012430301%'))and sysapproleperson.roleCode='FurlConfidentialSecretary')]
  at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
  at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
* Nested Exception (Underlying Cause) ---------------
org.springframework.orm.hibernate3.HibernateSystemException: Named query not known: from SysPerson sysperson where sysperson.personUuid in( select sysapproleperson.personUuid from SysApprolePerson sysapproleperson where sysapproleperson.personUuid in( select sysorgperson.personUuid from SysOrgperson sysorgperson where sysorgperson.orgUuid in(select sysorg.orgUuid from SysOrg sysorg where sysorg.orgCode like '%012430301%'))and sysapproleperson.roleCode='FurlConfidentialSecretary'); nested exception is org.hibernate.MappingException: Named query not known: from SysPerson sysperson where sysperson.personUuid in( select sysapproleperson.personUuid from SysApprolePerson sysapproleperson where sysapproleperson.personUuid in( select sysorgperson.personUuid from SysOrgperson sysorgperson where sysorgperson.orgUuid in(select sysorg.orgUuid from SysOrg sysorg where sysorg.orgCode like '%012430301%'))and sysapproleperson.roleCode='FurlConfidentialSecretary')
org.hibernate.MappingException: Named query not known: from SysPerson sysperson where sysperson.personUuid in( select sysapproleperson.personUuid from SysApprolePerson sysapproleperson where sysapproleperson.personUuid in( select sysorgperson.personUuid from SysOrgperson sysorgperson where sysorgperson.orgUuid in(select sysorg.orgUuid from SysOrg sysorg where sysorg.orgCode like '%012430301%'))and sysapproleperson.roleCode='FurlConfidentialSecretary')
  at org.hibernate.impl.SessionImpl.getNamedQuery(SessionImpl.java:1027)
  at org.springframework.orm.hibernate3.HibernateTemplate$32.doInHibernate(HibernateTemplate.java:806)
  at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:311)
  at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:804)
  at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:796)
  at com.icss.oa.core.service.impl.BaseServiceImpl.findByNamedQuery(BaseServiceImpl.java:63)
  at com.icss.oa.user.service.impl.RonePersonServiceImpl.getPersonUuidByOrgCode(RonePersonServiceImpl.java:183)
  at com.icss.oa.core.container.LogJobBean.sentNoteMessage(LogJobBean.java:121)
  at com.icss.oa.core.container.LogJobBean.executeInternal(LogJobBean.java:102)
  at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:66)
  at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
  at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
请问有哪位高手能指教指教，谢谢先。
在线等待中

已读帖子

新的帖子

被删除的帖子