hibernate的原生sql查询出错!高手帮帮忙!
下面是我的查询语句:
select top 5 {theme.*} from Theme {theme} where state=1 and type=1 order by newid()
下面是我的查询代码:
public List lisst(String sql) {
Session sess=super.getSession();
Query sqlquery=sess.createSQLQuery(sql).setEntity("theme",Theme.class);
List ls=sqlquery.list();
sess.close();
return ls;
}
下面是我报的错:
Parameter theme does not exist as a named parameter in [select top 5 {theme.*} from Theme {theme} where state=1 and type=1 order by newid()]