Hello All,
I have a database with a good number of joined subclasses, which works great for the business logic where the polymorphic behavior is truly desired. However, there is also a number if cases where we are only interested in the information from the base class but we still have to incur the overhead of all the outer joins in the queries.
So I was wondering if there is a way to turn off the generation of the outer joins for subclasses in Hibernate and load only a base class in a query.
I'm using Hibernate 2.1.6; all subclasses have lazy=true.

Thank you,
Alexander

Why don't you simply query for the base class then ?

Somehting like:

Aren't all Hibernate queries polymorphic by default, so

will result in a SQL with n outer joins where n is the number of joined subclasses (subclasses are defined in the BaseClass mapping)?

Thanks,
Alexander

Not sure about it... but is the "polymorphism" attribute useful in your case (see

I do use "explicit" polymorphism everywhere, "implicit" is more broad. According to the same section of the documentation, "explicit" still loads all the subclasses, so I was looking for a magic setting that would allow me to alter this behavior.

Thanks,
Alexander