Problem with hibernate.use_outer_join

unkyaku · **Joined:** Wed Oct 01, 2003 11:01 pm **Posts:** 23

Hi all...

When I specify hibernate.use_outer_join=false, does this mean that Hibernate will never generate a SQL query that uses outer joins? If so, this doesn't seem to be working for Hibernate 2.1.2 against Oracle when using joined-subclass and attempting to retrieve a set of these subclasses based on a superclass.

For example, if I have FooA and FooB which extends FooBase, and I have another object Bar that has a set of FooBase objects, attempting to iterate through this set produces SQL that uses outer joins.

Is this the expected behavior?

Do most people enable outer joins fetching? Is there a set of general guidelines when you would and would not enable it?

Thanks,
-Mark

gavin · **Posted:** Wed Mar 10, 2004 12:22 am

This is expected. That (deprecated) setting affects only association fetching.

unkyaku · **Joined:** Wed Oct 01, 2003 11:01 pm **Posts:** 23

Gavin,

Why is the setting deprecated? This is not mentioned in the docs btw.

Is there something replacing it? And if not, what's the default behavior?

christian · **Posted:** Thu Mar 11, 2004 2:53 pm

Have a look at max_fetch_depth. Setting this to 0 turns outer join fetching (used only for many-to-one and one-to-one) off.