title: ManyToOne Outer Join in a single query (1 to 0 relationship)
body: <p>I'm struggling with a mapping problem in hibernate. </p>
  
  <p>Got This mapping between 2 tables</p>
  
  <p>Table 1</p>
  
  <pre><code>    @ManyToOne(fetch = FetchType.EAGER)
      @JoinColumn(name="CNT_ID",referencedColumnName = "CNT_ID",insertable = false, updatable = false)
      @NotFound(action=NotFoundAction.IGNORE)
      private Table2 table2;
  </code></pre>
  
  <p>Table 2</p>
  
  <pre><code>@OneToMany(mappedBy="table2")
  private List&lt;Table1&gt; table1List;
  </code></pre>
  
  <p>I'm making a query like this : </p>
  
  <pre><code>select table1 from Table1 table1 left outer join table1.table2
  </code></pre>
  
  <p>The result is ok : got all data in table1 and some table2 (some table1 don't have link to table2) so the outer join is ok. </p>
  
  <p>The problem is that hibernate is making one query to catch all table1 and after 1 query for each line result for table1.
  So If I have 100lines in table 1, hibernate is making 101 queries ...</p>
  
  <p>Do I miss something ? I'm working with oracle database, also try the (+) operator (outer operator in oracle) but hibernate didn't want it.</p>
  
  <p>Thanks for your help !</p>