title: hibernate not doing a eager fetch (using fetch="join" and lazy="false")
body: <p>I want to do a eager fetch in my webapplication.I have following in my mapping file</p>
  
  <pre><code>&lt;many-to-one name="user" class="com.xyz.beans.User" lazy="false" fetch="join"&gt;
      &lt;column name="startedBy" /&gt;
  &lt;/many-to-one&gt;
  &lt;many-to-one name="participantByParticipant1" class="com.xyz.beans.Participant" lazy="false" fetch="join" cascade="all" &gt;
      &lt;column name="participant1" /&gt;
  &lt;/many-to-one&gt;
  &lt;many-to-one name="participantByParticipant2" class="com.xyz.beans.Participant" lazy="false" fetch="join" cascade="all"&gt;
      &lt;column name="participant2" /&gt;
  &lt;/many-to-one&gt;
  </code></pre>
  
  <p>I have a query as follows</p>
  
  <pre><code>Query query = session.createQuery("from Post as p order by challenge.createdOn desc");
  query.setFirstResult(0);
  query.setMaxResults(10);
  </code></pre>
  
  <p>Participand table has has some mapping to other tables.And their fetch strategy is same
  This takes around 2+ seconds to execute above query and i can see following queries generated by hibernate
  1 select query to fetch 10 post
  20 select queries for participant tabel (as there are 2 participants per post)</p>
  
  <p>1) Why so? Why is it not taking a single join?<br>
  2) How can i optimize this ?Its taking too much time.The table only as 10 records now</p>