@ManyToOne - delete value in column

sc3sc3 · **Joined:** Thu Mar 27, 2008 8:54 am **Posts:** 1

hi

this is part of my User class:
////////////////////

Code:

@Entity
@Table(name = "xxx.yyy.[User]")
@org.hibernate.annotations.Entity(mutable = true)
@BatchSize(size = 50)
@Cache(usage = CacheConcurrencyStrategy.READ_WRITE)
public class User {

..

    private Cluster cluster;

..

   @ManyToOne(fetch=FetchType.LAZY)
        @JoinColumn(name="clusterId")
        @LazyToOne(LazyToOneOption.PROXY)
   public Cluster getCluster() {
      return cluster;
   }

   public void setCluster(Cluster cluster) {
      this.cluster = cluster;
   }

///////////////////////
this User is represented in the 'User' table in the database
the clusterId column is an int, nullable

when i delete a certain 'cluster' in my application
the value in the 'clusterId' column is not removed in 'User' table
it should be put to NULL

can anybody point me to a solution ?

thanks for your time
sc3*2

cbredesen · **Posted:** Fri Mar 28, 2008 3:27 pm

If your database is setup correctly (with the proper constraints) you should not be able to delete a cluster while a FK to one cluster row exists (perhaps the constraints are missing).

That said, deleting a cluster and breaking the association are two different things in JPA, just as they are relationally. You need to do user.setCluster(null) to null out the association.