Hi

Using H3. Is it possible to use:

... so that in the <class ...> tag, there is no table="..." attribute specified?

I just want to join tables specified only in joined-subclass.

Maybe you would ask me why I don't use union-subclass if I want Table per concrete class. So the reason is, that I have 9 subclasses each with cca avg 5 different attributes and hibernate generates pretty long SQL satement using UNION ALL. I don't find it very effective and clean.

Moreover this class is also one-to-one mapped to another that has other joined-subclass-es, and if I used union-subclass in this class, the generated SQL was unparsable by Oracle 9i :-( (very sad). That SQL statement was of this form:

SELECT ... FROM ... OUTER JOIN ... OUTER JOIN ... OUTER JOIN (SELECT ... FROM ... UNION ALL SELECT ... FROM ... UNION ALL ...) ...;

Any advice? I've got a headache from all this. Please help. Thanks in advance.