使用hibernate对oracle数据库分页出现错误
代码
public List findRec(final String hql, final int firstResult,
final int maxResults) {
return getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException,
SQLException {
Query query = s.createQuery(hql);
query.setFirstResult(firstResult);
query.setMaxResults(maxResults);
List list = query.list();
return list;
}
});
}
public List getRolesCategorys(final int start, final int limit) {
return findRec("from HtSysRolesCategory", start, limit);
}
输出的hql:
Hibernate: select htsysroles0_.ROLE_CATE_ID as ROLE1_1_, htsysroles0_.ROLE_CATE_NAME as ROLE2_1_ from HT_SYS.HT_SYS_ROLES_CATEGORY htsysroles0_ limit ?
(怎么多出了limit? ,我用的是oracle)
错误:
Struts Problem Report
Struts has detected an unhandled exception:
Messages:
1. ORA-00933: SQL ???????
2. could not execute query
3. could not execute query; SQL [select htsysroles0_.ROLE_CATE_ID as ROLE1_1_, htsysroles0_.ROLE_CATE_NAME as ROLE2_1_ from HT_SYS.HT_SYS_ROLES_CATEGORY htsysroles0_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
File: oracle bc/driver/DatabaseError.java
Line number: 112
请高手帮忙啊。