Let us take the classic Order-Customer relationship.
Order always will have a customer.
Hence relationship is Many to one from Order to Customer.
All is fine . I want to avoid the left outer join and do a
simple inner join since the relationship is mandatory.
Is there a way to do this?
I tried to specify not-null but did not work

<many-to-one name="customer" column="customer_id" not-null="true" />


If I add a criteria like customer.name='John' then Hibernate automatically does the inner join and not the left outer join

thanks

If the elationship is mandatory how can I avoid the outer join
thanks

Anyone? Hibernate team can you confirm please ..

I have a Many to One relationship which is guaranteed .
For example Order always has Customer.
Why is an OuterJoin done here ? Is it necessary? How can I avoid it?(By specifying something in the Mapping?)
I want to avoid the outerjoin since in some cases it does not make use of index and henc ecan create performance issue.

thanks

Are you talking about on load()? There there is no way to do this currently.

During queries, you can always explicitly specify the manner in which the joins are done using the various join strategies. Navigating a relation like you mention with the "select o from Order as o where o.customer.something..." syntax does an implicit inner join for you. The explicit way is to say "select o from Order as o inner join fetch o.customer as c". Check out the docs on HQL for more info on this.