Hi,

I am using Struts+Spring+Hibernate.
I have a MySQL table tb_ext, the pesistent object is TbExt as following:

public class TbExt implements java.io.Serializable
{
// Fields
private Long extId;
private String extNumber;
private String extBox;
private String extStatus;
private String extUser;
private String extPassword;
private String extPrivateip;
private String extDescription;
...
}

I'd like to do some query like sql string " SELECT * FROM tb_ext LIMIT 5,10" , so I write a method in DAO:

public List queryAll(int currentPage, int pageSize ) throws Exception
{
String queryString = "FROM TbExt limit " + (currentPage - 1) * pageSize + "," + pageSize;
System.out.println("queryAll=" +queryString);
log.debug("query TbExt page by page");
try
{
return getHibernateTemplate().find(queryString);
} catch (RuntimeException re)
{
log.error("find all failed", re);
throw re;
}
}

But i got error:

queryAll=FROM TbExt limit 0,20
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 0
near line 1, column 43 [FROM com.hq.ictbox.hi.mapping.TbExt limit 0,20]; nested
exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 0 nea
r line 1, column 43 [FROM com.hq.ictbox.hi.mapping.TbExt limit 0,20]
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 0 near
line 1, column 43 [FROM com.hq.ictbox.hi.mapping.TbExt limit 0,20]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxExcepti


I searched the forum and some answer says "Limit was never a supported clause in HQL. You are meant to use setMaxResults()", but how to control the current page number when setMaxResults() is used?


Thanks.

You can use native SQL queries if you really decide to do things such way.