1. Mixing implicit and explicit JOINs stackoverflow.comI am having a problem with Hibernate generating invalid SQL. Specifically, mixing and matching implicit and explicit joins. This seems to be an open bug. However, I'm not sure why ... |
2. cross join issue in hibernate stackoverflow.comI have been using Hibernate 3.2 intailly for my J2EE application with Spring 2.5.Recently I wanted a feature of hibernate 3.5(BigInt Identity support).So I have upgraded my hibernate and now I ... |
3. Cross join and then left join using HQL or Criteria stackoverflow.comIs it possible to use HQL to make a cross join between two tables, select some of the columns and then left joining the result against a third table. SQL that ... |
4. Hibernate generates unwanted cross join forum.hibernate.org |
5. Implicit join generates "cross join" in SQL forum.hibernate.orgQuoting from Hibernate documentation, 14.4 Forms of join syntax: "The implicit form does not use the join keyword. Instead, the associations are "dereferenced" using dot-notation. implicit joins can appear in any of the HQL clauses. implicit join result in inner joins in the resulting SQL statement. " However, when I use something like this: SELECT COUNT DISTINCT A.id from A where ... |
6. Joined sub class in dual role as many 2 many cross reference forum.hibernate.orgNewbie Joined: Thu Dec 09, 2004 12:29 pm Posts: 10 We have the following object model: A Correspondent (this could be a customer, a solictor, a surveyor etc) - table is CORRESPONDENT A sub-class of Correspondent is Customer, which has additional fields held on another file (CUSTOMER) A Correspondent can have a collection of addresses (current address, previous address etc) (ADDRESS) ... |
7. cross table joins forum.hibernate.orgI am looking at implementing cross table joins in Hibernate and am unsure of the approach. I am looking at including the queries in the XML table definition file. I have a table A and table B and I want to access all fields from both tables from my Java class. As I see it there are two possibilities to accomplish ... |
8. HQL: outer join cross product forum.hibernate.orgThe new parser is much more picky (as it should be) with what can be passed through the SQL generator. If you want outer joins you need the relationship mapped or you can use nativeSQL. In your case that should be fine since you are using an Oracle extension to the HQL anyway. |