Delete/update associations question

[Naveen Sampra]

I have mapped User --> UserProduct association(one-to-many) in hibernate as follows:

    
[B]Tables:[/B]
USER {
   user_id PK,
   first_name,
   last_name,
   email  
}
 
USER_PRODUCT {
   user_id FK, PK,
   product_status PK
}

I also have User class and UserProduct classes as follows:

public class User {
  Integer userId;
  String firstName;
  String lastName;
  String email;
  Set<UserProduct> userProducts = new HashSet<UserProduct>(0);
 
  //Getter and Setters
}
 
public class UserProductId {
  Integer userId
  Integer productStatus;
}
 
public class UserProduct {
  UserProductId id;
}

Here is the part of User.hbm.xml that shows the association:

  <class name="com.sma.disclosure.model.Users" table="USERS">
     <id name="userId" type="integer">
       ....
     </id>
    .....
    <set name="userProducts" inverse="true" >            
      <key>
        <column name="USER_ID" scale="0" />
        </key>
        <one-to-many class="com.sma.disclosure.model.UserProduct" />
    </set>
  ......
  </class>

Here is the UserProduct.hbm.xml file.

  
   <class name="package.UserProduct" table="USER_PRODUCT">
        <composite-id name="id" class="com.sma.disclosure.model.UserProductGroupsId">
            <key-property name="userId" type="integer">
                <column name="USER_ID"  scale="0" />
            </key-property>
            <key-property name="productStatus" type="integer">
                <column name="PRODUCT_STATUS"  scale="0" />
            </key-property>
        </composite-id>
    </class>

How do I delete all userProducts for a given User ?

When I load a user in the Hibernate session and do the following:

user.getUserProducts().clear();

The user records do not get deleted !

Can someone show me the correct way to modify hibernate associations.

[Gregg Bolinger]

I think I'll shimmy this on over to our ORM forum where folk talk about Hibernate on a regular basis.

[Jaikiran Pai]

Change your User hbm to contain:

<set name="userProducts" inverse="true" [B]cascade="all-delete-orphan"[/B]> 

And the code:

user.getUserProducts().clear();
//save the user object
session.saveOrUpdate(user);

Also, have a look at the "Cascading lifecycle" section at Hibernate reference - Parent child example

[Naveen Sampra]

Thank you very much for the reply and the useful link.

You are precisely correct. I was missing cascade="all-delete-orphan". That fixed the problem.