浏览 1850 次
锁定老帖子 主题:Hibernate的sql查询
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
|
|
---|---|
作者 | 正文 |
发表时间:2009-04-24
今天用Hibernate来执行sql语句,简单总结一下
SQLQuery query = null; query = session.createSQLQuery("select * from fun as ca,(select * from comment as r1 where r1.created_at>=all(select r2.created_at from comment as r2 where r1.fun_id=r2.fun_id)) as re where ca.id=re.fun_id order by re.created_at desc;"); List<Fun> list = query.addEntity(Fun.class).list(); 如果没有最后一行的addEntity方法,在执行过程中会产生
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1类似异常! 声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
推荐链接
|
|
返回顶楼 | |