1. Using outer joins in HQL queries stackoverflow.comI'm trying to build a query using HQL and |
2. Can this SQL with subquery in SELECT be converted to Hibernate 3.0.5 HQL? stackoverflow.comIs it possible to convert the following into HQL 3.0.5 using any approach? Subqueries, outer joins with predicates, etc?
SELECT c.case_id,
(SELECT MAX(a.begin_date)
... |
3. Criteria query for outer join to subquery stackoverflow.comI have two tables, tableA and tableB: |
4. Can we execute sql query with outer join in hibernate coderanch.com |
5. Outer Join running with N+1 Selects forum.hibernate.orgHi, I'm trying to get some example code going for this because my code is a bit too much to post up here (14 or so classes). Anyways, I'm loading up (loadAll through Criteria) one abstract type that is an inheritance hierarchy. It has 3 subclasses and each subclass has either a OneToMany or ManyToMany, one of them has both. I ... |
6. Outer join from subquery forum.hibernate.org |
7. Change order outer joins are executed within criteria forum.hibernate.orgHi all, Does anyone knows how to change the order a Criteria generates its JOINs? Let me use an example. I have this criteria (with DetachedCriteria modified by me to accept the withClause in the join): Code: DetachedCriteria criteria = DetachedCriteria.forClass(Customer.class); criteria.createCriteria("pc.protocol", "pcp"); criteria.createCriteria("protocolCustomer", "pc"); criteria.createCriteria("group", "gr"); criteria.createCriteria("gr.protocolGroupSet", "pgs", Criteria.INNER_JOIN, Restrictions.eqProperty("protocolGroupPK.protocolId", "pcp.protocolId")); This criteria generates this SQL code: Code: select ... |
8. Criteria query for outer join to subquery forum.hibernate.orgHi, I have two tables TABLEA and TABLEB TABLEA : int id, String val. TABLEB: int id, String logs, int a_ref I need to create a query such as :- select tabB.* from TABLEB tabB left outer join (select tabA_.ID from TABLEA tabA_) attr on attr.ID = tabB.a_ref; Can somebody please help me how to create a criteria query in hibernate ... |
9. outer join query help forum.hibernate.org |
10. Query Interface with Outer Join forum.hibernate.orguse hibernate 2.1.3: have a mapping as follows (with some simplification): |
11. Two outer-join fetches, or N queries? forum.hibernate.orgI was wondering how you guys would do this. I'm new to hibernate and trying to come up with the best fetching strategy. I have a number of instances where an entity has two or more many to many relationships to other entities. I have a User who is related to many Locations, and belongs to many Roles. I'm fetching the ... |
12. Two outer-join fetches, or N queries? forum.hibernate.orgSorry for cross-posting this, I posted to Miscellaneous before realizing that this is probably the place for it. Let me know if I'm still posting to the wrong place.. thanks! I was wondering how you guys would do this. I'm new to hibernate and trying to come up with the best fetching strategy. I have a number of instances where an ... |
13. Oracle like outer join forum.hibernate.org |
14. cannot order by on a col in an association w/outer-join=true forum.hibernate.org |
15. criteria queries createAlias() and outer joins forum.hibernate.orgif (queryPart != null) { crit.add(Restrictions.eq("somePart1", "test")); } if (queryPart2 != null) { Junction j = Restrictions.conjunction(); j.add(Restrictions.ge("somePart2", queryPart2.getValMin())); j.add(Restrictions.le("somePart2", queryPart2.getValMax())); ... |
16. Outer joins in HQL and SQL queries forum.hibernate.org |
17. Many-to-one with outer-join still results in n+1 selects forum.hibernate.org |
18. Criteria, subquery and outer join forum.hibernate.orgHi guys, I been searching the forum, found few things but nothing that will solve this problem. So i turn to you for help. Here is how the query would look in sql table -> people ppl_id lname fname table -> positions pos_id position_name position_type ppl_id (forign_key) select * from people, (select position_name, ppl_id from positions where position_type = 'Manager') pos ... |
19. outer joins and property projections forum.hibernate.orghi all We are trying using hibernate criteria mechanism to fetch data from table. We have 2 entities PROPERTY and PROPERTY_RATING mapped as a one to one relationship in hibernate mapping files. We need to fetch the OVERALLUSERRATING alongwith some other attributes of the PROPERTY table. Hibernate by default uses an outer join to retrieve data from the PROPERTY_RATING table. However ... |
20. order by an outer joined criteria forum.hibernate.org |
21. Right outer join and projection with Criteria API forum.hibernate.orgOk, so this is probably a rare case, but what I'm trying to do is this: There's an Exam entity and a TakenExam entity. The TakenExam entity references the Exam entity and a User who took the exam. There may be many TakenExam's for every Exam (or none). I'm trying to build a report of the available exams for a particular ... |
22. Three level outer join query question forum.hibernate.org |
23. How to do three level outer join query? forum.hibernate.orgStill looking for some real help with this question. We're using Hibernate 3.1 and writing java code with Eclipse. Suppose our application domain has these aspects: 1. Cases contain boxes. 2. Boxes contain items. 3. Sometimes a case or a box is empty. 4. Sometimes a box or item is loose and has no parent container. We think our database is ... |
24. Disabling outer join in session.refresh() forum.hibernate.org |
25. Adjusting the Outer Join Predicate using Criteria Query forum.hibernate.orgCriteria tabA = session.createCriteria(TableA.class); tabA.createAlias("Table_B"," Table_B", Criteria.LEFT_JOIN).add(Restrictions.eq("Talbe_B.Col_3", ACTIVE_REGION)); tabA.setProjection( ... |
26. Hibernate HQL and outer joins queries forum.hibernate.org[b]Hibernate version:3.1[/b] I'm also using Spring framework. Hello all. I need to build a HQL query that performs an outer join between two non associates entities. I just want to reproduce the following sql query in HQL: select table_a.id as col_0, table_b.score_1-table_a.score_1 as col_1, table_b.score_2-table_a.score_2 as col_2, table_b.score_3-table_a.score_3 as col_3, table_b.score_4-table_a.score_4 as col_4 from p_audit as table_a left join p_audit as ... |
27. Outer join problem with Criteria Query forum.hibernate.orgHibernate version:Core Plugin 3.2.0.beta9 Name and version of the database you are using: PostgreSQL 8.2 The generated SQL (show_sql=true): Code: Hibernate: select this_.REPORT_ID as y0_ from CUSTOMERS this_ left outer join CUSTOMERSTATS customersi2_ on this_.CUSTOMER_ID=customersi2_.STAT_ID Hibernate: select this_.uuid as y0_, this_.serialNum as y1_, this_.ipAddr as y2_, this_.operStatus as y3_, this_.label as y4_, cust2_.NICKNAME as y5_ from DEVICES this_ inner join REPORTS ... |
28. How to write a Outer join Query in HQL forum.hibernate.orgHi there are many joins in your hql. Please add one by one until you get the error. so you can identify where is the error and can focus to it. if you send java codes and othere nessary details i will look in details. Amila (Don't forget to rate if helps) |
29. Baffled: Oracle + Outer Join + Distinct not working. forum.hibernate.orgAuthor Message matan_a Post subject: Baffled: Oracle + Outer Join + Distinct not working. Posted: Fri Mar 20, 2009 9:14 am Newbie Joined: Thu Jun 03, 2004 2:10 am Posts: 19 I've been using Hibernate for a while, but i'm having a problem with something I usually take for granted. (I've read the issues with Hibernate and distinct at ... |
30. Baffled: Oracle + Outer Join + Distinct not working. forum.hibernate.orgAuthor Message matan_a Post subject: Baffled: Oracle + Outer Join + Distinct not working. Posted: Fri Mar 20, 2009 9:15 am Newbie Joined: Thu Jun 03, 2004 2:10 am Posts: 19 (Sorry for duplicate - site got stuck on "Submit") I've been using Hibernate for a while, but i'm having a problem with something I usually take for granted. ... |
31. outer joins vs. subquery forum.hibernate.orgI can quite easily do this in SQL: Code: select s.s_id, (select count(*) from issue i where i.i_s_id = s.s_id and i.i_status in (2)) from severity s; s_id | ?column? ------+---------- 1 | 0 2 | 3 ... |
32. Criteria API : pagination biaised with outer join collection forum.hibernate.orghello, When using Criteria with a join on a one-to-many association, paginiation does not work: ie setFirstResult() and setMaxResult() seem to work on the scalar product ans not on distinct entity counting. Ans setResultTransformer() does not help a bit .... List |