hibernate select top
- 作者: Delimma隐
- 来源: 51数据库
- 2021-01-12
在ssh的hibernate中写上这个方法
public List findTop(){
log.debug("finding all Bulletin instances");
try {
String queryString = "select top 10 from Bulletin order by Bulletin_Time desc";
return getHibernateTemplate().find(queryString);
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}
}
from Bulletin order by Bulletin_Time desc直接这么写的话可以执行
但是换成上面的语句就
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 10 near line 1, column 12 [select top 10 from com.volunteer.yy.vo.Bulletin order by Bulletin_Time desc]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 10 near line 1, column 12 [select top 10 from com.volunteer.yy.vo.Bulletin order by Bulletin_Time desc]
Caused by:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 10 near line 1, column 12 [select top 10 from com.volunteer.yy.vo.Bulletin order by Bulletin_Time desc]
public List findTop(){
log.debug("finding all Bulletin instances");
try {
String queryString = "select top 10 from Bulletin order by Bulletin_Time desc";
return getHibernateTemplate().find(queryString);
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}
}
from Bulletin order by Bulletin_Time desc直接这么写的话可以执行
但是换成上面的语句就
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 10 near line 1, column 12 [select top 10 from com.volunteer.yy.vo.Bulletin order by Bulletin_Time desc]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 10 near line 1, column 12 [select top 10 from com.volunteer.yy.vo.Bulletin order by Bulletin_Time desc]
Caused by:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 10 near line 1, column 12 [select top 10 from com.volunteer.yy.vo.Bulletin order by Bulletin_Time desc]
推荐阅读
