mysql hibernate 分页,Hibernate兑现mysql数据库分页报错，100分救助

Daydayydayyy

于 2021-03-17 03:35:10 发布

阅读量105

点赞数

文章标签： mysql hibernate 分页

当前位置:我的异常网» Java Web开发 » Hibernate兑现mysql数据库分页报错，100分救助

Hibernate兑现mysql数据库分页报错，100分救助

www.myexceptions.net 网友分享于：2013-04-03 浏览：15次

Hibernate实现mysql数据库分页报错，100分救助

final String hql = "from SysWebsiteInfo where 1=1 ";

List list = this.getHibernateTemplate().executeFind(new HibernateCallback() {

public Object doInHibernate(final Session session) throws HibernateException, SQLException

{

final Query query = session.createQuery(hql);

query.setMaxResults(10); //如果去掉这一行

query.setFirstResult(1); //再去掉这一行可以正常查出来

return query.list();

}

});

----------------------------------------------------------------------

Struts Problem Report

Struts has detected an unhandled exception:

Messages: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 1 10 syswebsite0_.id as id0_, syswebsite0_.address as address0_, syswebsit' at line 1

FreeMarker template error!

Method public java.lang.String org.hibernate.exception.NestableRuntimeException.getMessage(int) threw an exception when invoked on org.hibernate.exception.SQLGrammarException: could not execute query

The problematic instruction:

----------

==> ${msg[0]} [on line 68, column 29 in org/apache/struts2/dispatcher/error.ftl]

----------

Java backtrace for programmers:

----------

freemarker.template.TemplateModelException: Method public java.lang.String org.hibernate.exception.NestableRuntimeException.getMessage(int) threw an exception when invoked on org.hibernate.exception.SQLGrammarException: could not execute query

at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:130)

at freemarker.ext.beans.SimpleMethodModel.get(SimpleMethodModel.java:138)

at freemarker.core.DynamicKeyName.dealWithNumericalKey(DynamicKeyName.java:111)

at freemarker.core.DynamicKeyName._getAsTemplateModel(DynamicKeyName.java:90)

at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)

at freemarker.core.Expression.getStringValue(Expression.java:93)

at freemarker.core.DollarVariable.accept(DollarVariable.java:76)