方法是这样写的
public class Test extends HibernateDaoSupport{ public List getLimitListByOptimizeHQL(final String hql, final Object[] queryParams, final int start, final int limit) {
final int showCount = limit;
final String str_hql="select * from tbepisteme";
final Object[] obg_queryParams=null;
final int int_start=0;
final int int_limit=10;
return getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException, SQLException { Query query = s.createSQLQuery(str_hql);
// if(queryParams!=null)
// {
// for (int i = 0; i < queryParams.length; i++) {
// query.setParameter(i, queryParams[i]);
// }
// }
query.setFirstResult(int_start);
query.setMaxResults(int_limit);
System.out.println("aaaaaaaaaaa");
List list = query.list();
System.out.println("lsit"+list.size());
return list;
}
});
}
}
一运行就报这样的错误:
WARN - Unhandled Exception thrown: class org.springframework.orm.hibernate3.HibernateQueryException
2008-7-25 9:57:21 org.apache.catalina.core.ApplicationContext log
信息: org.springframework.orm.hibernate3.HibernateQueryException: addEntity() or addScalar() must be called on a sql query before executing the query. [select * from tbepisteme]; nested exception is org.hibernate.QueryException: addEntity() or addScalar() must be called on a sql query before executing the query. [select * from tbepisteme] 请大家给小弟指出错误所在....不剩感激!!!!
public class Test extends HibernateDaoSupport{ public List getLimitListByOptimizeHQL(final String hql, final Object[] queryParams, final int start, final int limit) {
final int showCount = limit;
final String str_hql="select * from tbepisteme";
final Object[] obg_queryParams=null;
final int int_start=0;
final int int_limit=10;
return getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException, SQLException { Query query = s.createSQLQuery(str_hql);
// if(queryParams!=null)
// {
// for (int i = 0; i < queryParams.length; i++) {
// query.setParameter(i, queryParams[i]);
// }
// }
query.setFirstResult(int_start);
query.setMaxResults(int_limit);
System.out.println("aaaaaaaaaaa");
List list = query.list();
System.out.println("lsit"+list.size());
return list;
}
});
}
}
一运行就报这样的错误:
WARN - Unhandled Exception thrown: class org.springframework.orm.hibernate3.HibernateQueryException
2008-7-25 9:57:21 org.apache.catalina.core.ApplicationContext log
信息: org.springframework.orm.hibernate3.HibernateQueryException: addEntity() or addScalar() must be called on a sql query before executing the query. [select * from tbepisteme]; nested exception is org.hibernate.QueryException: addEntity() or addScalar() must be called on a sql query before executing the query. [select * from tbepisteme] 请大家给小弟指出错误所在....不剩感激!!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货