我想要查询auction_bid表里最大id的一条记录!下面是代码
public AuctionBid getMaxBid( ) {
Session session=null;
AuctionBid bid=null;
String hql="select top 1 {b.*} from auction_bid b order by ab_id desc";
try {
session=this.getSession();
SQLQuery q=session.createSQLQuery(hql).addEntity("b",AuctionBid.class);
List<AuctionBid>l=q.list();
bid=l.get(0);
} catch (HibernateException e) {
e.printStackTrace();
}
return bid;
}
下面是报错
Caused by: java.sql.SQLException: ORA-00923: 未找到要求的 FROM 关键字
映设文件也写了!
at org.hibernate.loader.Loader.list(Loader.java:2124)Hibernate: select top 1 b.AB_ID as AB1_2_0_, b.AU_USER_ID as AU2_2_0_, b.AP_PROD_ID as AP3_2_0_, b.AB_INDEX as AB4_2_0_, b.AB_CREATE_TIME as AB5_2_0_, b.AB_PRICE as AB6_2_0_ from auction_bid b order by ab_id desc
请问是什么原因?
public AuctionBid getMaxBid( ) {
Session session=null;
AuctionBid bid=null;
String hql="select top 1 {b.*} from auction_bid b order by ab_id desc";
try {
session=this.getSession();
SQLQuery q=session.createSQLQuery(hql).addEntity("b",AuctionBid.class);
List<AuctionBid>l=q.list();
bid=l.get(0);
} catch (HibernateException e) {
e.printStackTrace();
}
return bid;
}
下面是报错
Caused by: java.sql.SQLException: ORA-00923: 未找到要求的 FROM 关键字
映设文件也写了!
at org.hibernate.loader.Loader.list(Loader.java:2124)Hibernate: select top 1 b.AB_ID as AB1_2_0_, b.AU_USER_ID as AU2_2_0_, b.AP_PROD_ID as AP3_2_0_, b.AB_INDEX as AB4_2_0_, b.AB_CREATE_TIME as AB5_2_0_, b.AB_PRICE as AB6_2_0_ from auction_bid b order by ab_id desc
请问是什么原因?
解决方案 »
- Can't load IA 32-bit .dll on a AMD 64-bit platform
- 如何方便的导出pdf?
- 任务管理系统的业务逻辑,大家进来给些idea
- 帮助!谁能教我做web开发。
- 如何快速获取某内容的图片?
- 不明白struts应用与子应用?
- 求完美解决同一帐号重复登陆问题的代码,如果只是大概讲讲,我还是无从下手
- 我怎样发布自己的servlet
- myeclipse中tomcat部署键(Deploy Myeclipse j2ee project to server)点了没反应
- 页面一直在加载,静态页面好像没问题,不知道是不是数据库的问题
- 在线等,各位大侠,包含中文的url 访问tomcat 无法访问
- 求助:JSP的删除修改语句写在SERVLET里怎么实现
就是啊!
数字的话直接MAX(ID);
要达到想要的效果,最终生成的SQL应该是这样:select * from auction_bid b where b.ab_id = (select max(ab_id) from auction_bid);