Hello,

I have three tables A, B and C. Object B inherits from obect A and table B is connected to table A by column x. Object B has Object C and table C i connected to table B by two columns y and z. y and z are foreign keys for table C and they are primary keys of table B. column x is a foreign is a primary key of table A and a unique column for table B.

I am not sure how to produce mapping for the following relationship. We have the mapping that connect table B to table A but how do we specify mapping between table C and table B. What sort of element do I put to specify that table B and tabe C should be joined by y and z

Thank you so much for your help.





Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt: