1. HQL for two tables linked by a relationship table? coderanch.comGiven the really stripped-down essence of two classes @Table( name="districts") class District { @id Long id; String name; @OneToMany(fetch = FetchType.LAZY) @JoinTable(name="school_district_relationship", joinColumns={ @JoinColumn(name="id_district") }, inverseJoinColumns={ @JoinColumn(name="id_school") } ) private Set |
2. HQL for two tables linked by a relationship table? forum.hibernate.orgGiven the really stripped-down essence of two classes Code: @Table( name="districts") class District { @id Long id; String name; @OneToMany(fetch = FetchType.LAZY) @JoinTable(name="school_district_relationship", joinColumns={ @JoinColumn(name="id_district") }, ... |
3. HQL involving many-to-many relationship forum.hibernate.orgHi, I have two objects A, B having getBs() and getAs() respectively, and I've successfully mapped them as bidirectional many-to-many with three tables A, B, and A_B. I now wish to find all As who has a B of a particular id, but I have no idea how to do it through HQL. Session.find("from A where A.bs....?") Normally with SQL I ... |
4. HQL for many-to-many relationship forum.hibernate.orgAuthor Message kombi Post subject: HQL for many-to-many relationship Posted: Thu Feb 10, 2005 4:00 pm Newbie Joined: Thu Feb 10, 2005 1:00 pm Posts: 1 Any one ever created a method in a DAO that fetches rows based upon a many-to-many relationship? here is what i am doing: 1. Add subscription. (Works fine.) 2. Then i fetch subscriptions ... |
5. HQL on one-to-many relationships forum.hibernate.orgSuppose I have the following small DB which defines two classes A and B, where B contains a set of As with a one-to-many relationship, eg: Code: /** * @hibernate.class table="as" */ public class A { public A() { } /** ... |
6. Hibernate hql join on tables with no relationship forum.hibernate.orgI need to run some read only reports by joining the following two tables: 1) payments 2) subscriptions The join will be on a column in both called paymentreference. I do not have control over the underlying database and the two tables and the two tables do not have a relationship i.e. no foreign keys exist. Is it possible to add ... |
7. Hibernate hql join on tables with no relationship forum.hibernate.orgI need to run some read only reports by joining the following two tables: 1) payments 2) subscriptions The join will be on a column in both called paymentreference. I do not have control over the underlying database and the two tables and the two tables do not have a relationship i.e. no foreign keys exist. Is it possible to add ... |
8. Hibernate hql join on tables with no relationship forum.hibernate.orgI need to run some read only reports by joining the following two tables: 1) payments 2) subscriptions The join will be on a column in both called paymentreference. I do not have control over the underlying database and the two tables and the two tables do not have a relationship i.e. no foreign keys exist. Is it possible to add ... |
9. HELP:HQL syntax for quering across many-to-many relationship forum.hibernate.orgNewbie Joined: Mon May 12, 2008 8:42 pm Posts: 2 We are trying to formulate a HQL to cross a many-to-many relationship with a criteria against the remote class i.e. we want to find all 'users' who are in a certain 'group' UserBean and GroupBean are related via GroupUserBean class. The GroupUserBean class has two one-to-many relationships The relationship work fine, ... |
10. Can HQL handle nullable foreign keys in relationships? forum.hibernate.orgI have a table with a nullable foreign key column. A value will be set when someone updates the record later, but all records start out with this field null. When I try to do a join from this table using the nullable foreign key Hibernate throws a null pointer exception. That's probably because the parent object is null in some ... |
11. HQL and eager many to one relationships. forum.hibernate.orgNewbie Joined: Wed Mar 05, 2008 3:11 am Posts: 3 I'm having a problem (which could just be a missunderstanding about hql and hibernate) when I do a HQL query on an entity that has an eagerly loaded relationship. I'm doing a HQL query on Parent entity which has an eagerly loaded many-to-one relationship to a Child entity. However, I am ... |
12. Using HQL to add into a relationship table. forum.hibernate.orgHi I want to construct a Hibernate object that refers to two database tables. I have one object called Attribute and another called Activity. The object Attribute is read only, and has a Many-to-Many relationship with Activity. The following is the definition of Attribute Code: |