I have a bidirectional one-to-one relationship set up between two classes, A and B. A "owns" the relationship. It seems to me there is always one additional query than should be necessary to load these objects. After loading an object of type A and then calling A.getB() I get:

select
a0_.A_ID as A1_0_1_,
a0_.B_ID as B3_0_1_,
a0_.A_TEXT as A2_0_1_,
b1_.B_ID as B1_1_0_,
b1_.B_TEXT as B2_1_0_
from
A a0_
left outer join
B b1_
on a0_.B_ID=b1_.B_ID
where
a0_.A_ID=?

To me, since the relationship is bidirectional it would appear all necessary information is now present to fill in both A and B. However, this is followed by:

select
a0_.A_ID as A1_0_1_,
a0_.B_ID as B3_0_1_,
a0_.A_TEXT as A2_0_1_,
b1_.B_ID as B1_1_0_,
b1_.B_TEXT as B2_1_0_
from
A a0_
left outer join
B b1_
on a0_.B_ID=b1_.B_ID
where
a0_.B_ID=?

I thought there might be some relationship attribute that could change this behavior but so far after trying several I don't see it. Could anyone explain if there is a way to get this to run with a single query and if not why the second query is needed?

Thanks!

As relationship is by directional, one side of relationship should be or .

If you post the code, that can give more understanding.

I should add it is on a foreign key if that wasn't clear from the sql. I'm using annotations and here is where the relationship is defined. I did try it using mapping files and saw the same behavior.