Hi all,

Is it posiible to mix table-per hierarchy and table-per-subclass strategies on <subclass> or <joined-subclass> level?

For example, DTD does not allow constructions like this:

<class>
<subclass>
<joined-subclass>
</joined-subclass>
</subclass>
</class>

or

<class>
<joined-subclass>
<subclass>
</subclass>
</joined-subclass>
</class>

So it seems we can mix those strategies only on <class> level

<class>
<subclass>
</subclass>

<joined-subclass>
</joined-subclass>
</class>

Is there any workaround for this limitation?

Thanks

No,
Yes, use one-to-one association.

You can also search the forum on this subject, it was discussed in a interesting thread.

Emmanuel,

thanks a lot!

Did you mean I should use composition rather than inheritance in my object model? Unfortunately it is impossible in my case because model is "fixed" already and it uses inheritance.

It seems there is absolutely no way to implement that in existing object model...

Actually the pb you're facing is a fixed DB model that mix the 2n strategies