inner/outer join in hibernate
来源:互联网 发布:淘宝店铺利润分析 编辑:程序博客网 时间:2024/06/10 11:25
hibernate目前(3.0) 只支持theta-style的外连接,标准的ANSI-style外连接暂不支持
ANSI-style的外连接是什么样子?
select template
from CoTemplate template left outer join CoTempField field on template=field.comp_id.coTemplate
where field.comp_id.coField.fieldId=7//这里field用了复合主键
目前这种写法hibernate会跑出如下异常:
org.hibernate.QueryException: outer or full join must be followed by path expression....
会抛出如上异常的还包括inner join、right join
目前hibernate能够支持的写法如下
select template
from CoTemplate template,CoTempField field
where template *= field.comp_id.coTemplate
and field.comp_id.coField.fieldId=7
//*=表示左联接、=*表示右连接
好像hibnernate3目前拒绝fix this bug
参考:http://opensource.atlassian.com/projects/hibernate/browse/HHH-190
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=60864&view=next
- inner/outer join in hibernate
- inner/outer join in hibernate
- inner/outer join in hibernate
- inner join 和outer join
- Mysql Inner Join , Outer Join
- Linq INNER JOIN / OUTER JOIN
- inner join 和 outer join
- Learn SQL Join,Inner Join, Outer Join
- Oracle inner/outer/nature join
- inner join&left outer join&right outer join
- inner join&left outer join&right outer join 区别
- left outer join,inner join,right outer join的区别
- inner join&left outer join&right outer join
- inner join, left outer join, right outer join
- cross join & natural join & inner join & left outer join & right outer join & full outer join
- with inner join & with outer join
- inner join 和 outer join 的区别
- inner join 和outer join知识
- Android自动化测试之Monkey工具
- 微博空间分享 ios
- C#设计模式(4)——抽象工厂模式
- C语言中的内联函数(inline)与宏定义(#define)详细解析
- yiic创建YII应用 创建报错
- inner/outer join in hibernate
- JS之Window对象
- 变量的定义与使用问题
- Tomcat迁移JBoss杂症—不识别及不能解析web.xml
- symbol(s) not found for architecture i386问题的解决方案。
- linux添加新的磁盘
- iOS对照片库的操作
- poj 3253 Fence Repair 【哈弗曼树】+【优先队列】
- Android 下拉刷新框架实现、仿新浪微博、QQ好友动态滑到底部自动加载