avoid extra select query on saving object with many-to-one

sanjay · **Joined:** Thu Jan 04, 2007 12:27 am **Posts:** 8

I have an object with a field mapped many-to-one e.g :

Code:

Course {
  User user ; 
   ...
}

<class name="com.pkg.Course" table="COURSE" polymorphism="implicit">
   <id name="id" type="long" column="ID" unsaved-value="0">
           <generator class="identity"/>
   </id>
   
   <many-to-one name="user" 
                     class="com.pkg.User" 
                     column="USER_ID" 
                     not-null="true" 
                     cascade="none"/> 
       ......
</class>

When I save a new object of course, session.save(Course), in the logs I see an extra select query on User, before every insert. I looked around in the forums but cant find a way to avoid it. Is there a way to avoid this query ?

batmat · **Posted:** Fri Mar 30, 2007 4:32 pm

What is the mapping of your User class?

sanjay · **Joined:** Thu Jan 04, 2007 12:27 am **Posts:** 8

Does it depend on mapping of User class?

it looks like this

Code:

   <class name="com.pkg.User" table="USER">
      <id name="username" type="java.lang.String" column="ID">
         <generator class="assigned"/>
      </id>
              .... 
      </class>

sanjay · **Joined:** Thu Jan 04, 2007 12:27 am **Posts:** 8

doesnt seem to work still.. anyone has a solution for this?