Hi folks,

I'd like to know if and how I could map several objects to several tables when using the SINGLE_TABLE inheritance strategy? For example I got four classes:



And I'd like to have attributes from class Class1 in one table and attributes from classes Class2, Class3 and Class4 in an other, second table.

I've tried with @SecondaryTable, but unfortunately failed. Hibernate generates three (!) forein keys pointing to Class1. Thus when I try to persist a object of type Class3 or Class4 I get a DuplicateKeyException as probably every object in the hierarchy tries to persist its data with the same id on the second table. Using different names for the foreign keys, the same fails due to a forign key constraint.

Any ideas how I could achieve the above mentioned goal?

it should work, your mapping probably has an issue

Hi Emmanuel,

unfortunately it does not work. The DDL, respectively the database tables are created successfully as desired, but persisting objects of type Class3 or Class4 fails! :(

I guess I need to tell Hibernate to omit creating certain foreign keys.

But if you say that this should be possible, I maybe could supply a testcase that prooves that this does not work.

Regards,
bitbyter

Create a minimal test case reproducing the problem and send it to JIRA.