[b]Hibernate version: 2.1[/b]

I need to have a many-to-one relationship between Company and Person.
(Don't ask why, I need to display the two records in specific places on the view, and many other reasons).

Now, i need to do something like this with my bean:

[Class Company]
private Person priPerson;
private Person secPerson;
private String priPid;
private String secPid;

... getter & setters ...

where priPid & secPid keeps the relationship for the two Person's related to Company.

The only (relevant) values stored in the Company record is the 2xId's of the Person record.

I've read the document many times, and the one reffered to from the Forum page on Parent/Child relationships. I'm afraid they don't give a solution to my perticular problem.

The documents suggests a many-to-one defenition from the parent point of view and a one-to-many relationship from the childs point of view... not true.

Company one has [b]TWO[/b] child entries for People.
One People can be the child of multiple Company entries.

So I'm not storing the Company Key in the People record, I'm storing [b]TWO[/b] People Key's in the Company record.
Company bean:
[code]
private Person priPerson;
private Person secPerson;
private String priPid;
private String secPid;
//(priPerson & secPerson is not stored in Company table, only their key's priPid & secPid)
[/code]

I can see this moving to a many-to-many direction, but that's unnecessary overhead (another table to maintain) and I will need overhead code in my bean just to put the People entry in the correct variable, since I need primary and secondary to be distinct. (Pri can't be the first record found according to the key's, it has to be in the possition according to the key for Pri).[/b][/code]

You do need many-to-one, twice, in the parent.



Then your Company table has two foreign keys, Pri_Person_id and Sec_person_id, to the primary key of the Person table.

The Person mapping would list relationship to the Company.

I had nearly the same exact situation, and it worked for me.

Sorry, I dropped a word there:

[/quote]