Has somebody been able to nest joined-subclass to create multilevel inheritance?

In my case, the ID of the first 2 objects are the same but the third level object has a different id and it seems to be a problem,

could somebody help me with this?

Thanks

how are your third subclass related to the first two levels ? How should hibernate join'em ?

First Class is a Person Class cointaining an id , first name last name
Second class is the Employee Class which extends Person by adding an employee id

Thirst class is an special kind of employee which brings a set of specialized properties.

I map the Person Class to a table that contains an id and other fields

The Employee to another table hwich contains only the person id and the employee id

and the EspecialEmployee table contains the employee_id and the rest of the info related to this class of employee

Thanks

Why doesnt SpecialEmployee just use PersonId as its id ?

Your relational model looks more like one where a Employee has a association to your special employee thingy.

yes you are right, but I have to live with the legacy database. I am just trying to create the most business oriented object model out of it.

The employee table with both the person_id and employee_id was created as a level of isolation interfacing between 2 systems


Another thing I tried was to create an Employee business object that is the join of the 2 tables employee and special employee and create an inheritance realtion with person

to do that I tried to create a joined-subclass in person to employee and inside it to join to the third table, but as far as I could go, hibernate's dtd doesnt allow a join inside a jonies-subclass

Fabricio

Max,

would you take a look at this posting that is my business situation and give me advice in how would you map it?

I really appretiate your help

http://forum.hibernate.org/viewtopic.ph ... highlight=

Sorry, but don't have time to do more than saying I would probably not let Employee extends Person - they sounds like two different things with associations in between.

Thanks Max, I suspected that was the only way