Default fetch for many to one

why · **Joined:** Fri Jun 17, 2005 7:24 am **Posts:** 23

Default fetch for many to one according to manual is "select" but i saw it in console there it use left join. How come? Actually hibernate those lazy and fetching very confuse.

pksiv · **Posted:** Wed Oct 26, 2005 9:42 am

why wrote:

Default fetch for many to one according to manual is "select" but i saw it in console there it use left join. How come? Actually hibernate those lazy and fetching very confuse.

What version of Hibernate are you using ? Can you post your mapping files ?

http://www.hibernate.org/ForumMailingli ... AskForHelp

why · **Joined:** Fri Jun 17, 2005 7:24 am **Posts:** 23

Console:
Hibernate: select email0_.emailid as emailid1_, email0_.email as email14_1_, email0_.personid as personid14_1_, person1_.personid as personid0_, person1_.person_name as person2_12_0_ from email email0_ left outer join Person person1_ on email0_.personid=person1_.personid where email0_.emailid=?

Code:

   public void testLoadMany2One() {
      Email email = (Email) session.load(Email.class, 1);
      email.getEmail();

      tx.commit();
      session.close();
   }

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping >

   <class name="hibernateSpring.Email" table="email" >

      <id name="emailID" column="emailid" type="int" unsaved-value="0">
         <generator class="increment" />
      </id>

      <property name="email" column="email" type="java.lang.String" not-null="false" length="20" />

      <many-to-one name="person" class="hibernateSpring.Person" cascade="save-update"
         column="personid"   />
   </class>

</hibernate-mapping>

why · **Joined:** Fri Jun 17, 2005 7:24 am **Posts:** 23

The hibernate version is 3.0.5.