hibernate查询的两种方式，有什么不同？

0 0

hibernate查询的两种方式，有什么不同？5

数据库是sqlserver2005

为什么我的hql在第一种方法正常，第二种方法报错？

hql：" from PersonInfo p ,PersonAccount a where p.status <> 1 and (select count(o) from OrgPerson o where o.orgInfo.orgid='12345' and o.personuuid = p.personuuid and p.personuuid = a.personuuid and p.status =0) > 0"

方法1：

List list = getHibernateTemplate().find(hql);

方法2：
List list = getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery(hql);

int firstResult = (fpi.getPage().intValue() == 1 ? 0 : (fpi.getPage().intValue() - 1) * fpi.getSize().intValue());
if(firstResult <=0 )firstResult = 0;

int maxResults = fpi.getSize().intValue();

query.setFirstResult(firstResult);
query.setMaxResults(maxResults);
List list = query.list();
return list;
}
});

方法2会报如下错误：

Hibernate operation: could not execute query; bad SQL grammar [select personinfo0_.PERSONUUID as PERSONUUID0_, personacco1_.PERSONUUID as PERSONUUID1_, personinfo0_.PERSONCODE as PERSONCODE10_0_, personinfo0_.SORTNO as SORTNO10_0_, personinfo0_.CNNAME as CNNAME10_0_, personinfo0_.LASTNAME as LASTNAME10_0_, personinfo0_.FIRSTNAME as FIRSTNAME10_0_, personinfo0_.POLITYCODE as POLITYCODE10_0_, personinfo0_.IDTYPE as IDTYPE10_0_, personinfo0_.IDNO as IDNO10_0_, personinfo0_.SEX as SEX10_0_, personinfo0_.MARRYCODE as MARRYCODE10_0_, personinfo0_.EDUCATEHISTORY as EDUCATE12_10_0_, personinfo0_.DEGREE1 as DEGREE13_10_0_, personinfo0_.PHOTO as PHOTO10_0_, personinfo0_.DUTY as DUTY10_0_, personinfo0_.DUTYLEVEL as DUTYLEVEL10_0_, personinfo0_.OFFICETEL as OFFICETEL10_0_, personinfo0_.HOMETEL as HOMETEL10_0_, personinfo0_.OFFICEFAX as OFFICEFAX10_0_, personinfo0_.MOBILE as MOBILE10_0_, personinfo0_.EMAIL1 as EMAIL21_10_0_, personinfo0_.EMAIL2 as EMAIL22_10_0_, personinfo0_.ADDRESS as ADDRESS10_0_, personinfo0_.POSTALCODE as POSTALCODE10_0_, personinfo0_.MEMO as MEMO10_0_, personinfo0_.STATUS as STATUS10_0_, personacco1_.USERID as USERID9_1_, personacco1_.PASSWORD as PASSWORD9_1_, personacco1_.ACCOUNTTYPE as ACCOUNTT4_9_1_, personacco1_.VALIDDATE as VALIDDATE9_1_, personacco1_.LASTLOGINTIME as LASTLOGI6_9_1_, personacco1_.LASTLOGINIP as LASTLOGI7_9_1_, personacco1_.ACCOUNTSTATUS as ACCOUNTS8_9_1_, personacco1_.CREATETIME as CREATETIME9_1_ from framework.PERSON_INFO personinfo0_, framework.PERSON_ACCOUNT personacco1_ where personinfo0_.STATUS <>1 and (select count(orgperson2_.ORGPERSONID) from framework.ORG_PERSON orgperson2_ where orgperson2_.ORGID='2c90a84e1b01388f011b013bdbea0003' and orgperson2_.PERSONUUID=personinfo0_.PERSONUUID and personinfo0_.PERSONUUID=personacco1_.PERSONUUID and personinfo0_.STATUS=0)>0]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'where'.

....

太奇怪了！！

Hibernate