I have a class A which has an object of Type B.A is associated with B with a one to one mapping and the association is bi-directional.In table A I have the id of B say for eg "b_Id" The problem is that when I try to Query using HQL "from A where some condition....",hibernate is generating sql "select * from A where b_Id =?" multiple times.I have joined A with B using left join fetch.Even then it gives n+1 selects.Can anybody help me on this to find an alternative

Hi,

You will find lot of information on one-to-one relation if you search hibernate forum with one-to-one as key. For you reference one of the good forum i have found is

http://www.hibernate.org/162.html

It explains one-to-one details. Summary from that article is you can use contraint=true attribute in your one-to-one relationship if you know A will always be associated with B. i.e. its true one-to-one not one-to zero or one.

Cheers,
Deepak

My case is one to zero or one mapping

Hi,

in that case u wont be able to use contraint = true. one thing you can do is either treat it like one-to-many or Inheritence with proxy.