Here is my setting with slight improvement:
Tables: People (columns - id, name, etc.), Relationship (columns - id1, id2, type_id, status, etc.), Relationship_Type (columns - type_id, type_name))
Examples of two rows in the People table:
1, john
2, paul
Examples of a row in the Relationship table:
1,2,1,"inactive"
Examples of a row in the Relationship_type table:
1,band_members
In the
example.People.java file
I'll have a property of
...
private Set relations;
...
1) I added an example.Relationship_type.java class
mapping to the Relationship_type table, along with the example.Relationship_type.hbm.xml.
2) I added a utility java class as individual members of relations
example.Relation.java file
...
private People person;
private String status;
private Relationship_type relationshipType;
...
and getter/setters
In the
example.People.hbm.xml file I now map
<set name="relations" sort="unsorted" table="Relationship" >
<key column="id1"/>
<composite-element class="example.Relation">
<many-to-one name="relationshipType" column="type_id" class="example.Relationship_type"/>
<many-to-many name="person" column="id2" class="example.People"/>
<property name="status"/>
</composite-element>
</set>
It compiles but bombs out in run time with a null pointer error. When I look into the log, it is in a Hibernate class of getting proxyFactory. By the debug info spitted out from Hibernate, I can see it actually built a correct sql for querying the Relationship table, and then went for loading example.Relationship_type class instance. Then there is a whole bunch of session closing debug information before the null pointer error.
This is where I'm stuck now.
Login
FAQ
Search
