JPA Inheritance and Relations - Clarification question

Posted by Michael on Stack Overflow See other posts from Stack Overflow or by Michael
Published on 2010-05-15T11:45:22Z Indexed on 2010/05/15 12:04 UTC
Read the original article Hit count: 282

Here the scenario: I have a unidirectional 1:N Relation from Person Entity to Address Entity. And a bidirectional 1:N Relation from User Entity to Vehicle Entity.

Here is the Address class:

@Entity
public class Address implements Serializable {
  private static final long serialVersionUID = 1L;

  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  privat Long int
  ...

The Vehicles Class:

@Entity
public class Vehicle implements Serializable {
  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  private Long id;

  @ManyToOne
  private User owner;
  ...

  @PreRemove
  protected void preRemove() { //this.owner.removeVehicle(this); }

  public Vehicle(User owner) {
    this.owner = owner;
    ...

The Person Class:

@Entity
@Inheritance(strategy = InheritanceType.JOINED)
@DiscriminatorColumn(name="PERSON_TYP")
public class Person implements Serializable {

  @Id
  protected String username;

  @OneToMany(cascade = CascadeType.ALL, orphanRemoval=true)
  @JoinTable(name = "USER_ADDRESS",
  joinColumns =
  @JoinColumn(name = "USERNAME"),
  inverseJoinColumns =
  @JoinColumn(name = "ADDRESS_ID"))
  protected List<Address> addresses;
  ...

  @PreRemove
  protected void prePersonRemove(){ this.addresses = null; }
  ...

The User Class which is inherited from the Person class:

@Entity
@Table(name = "Users")
@DiscriminatorValue("USER")
public class User extends Person {

  @OneToMany(mappedBy = "owner", cascade = {CascadeType.PERSIST, CascadeType.REMOVE})
  private List<Vehicle> vehicles;
  ...

When I try to delete a User who has an address I have to use orphanremoval=true on the corresponding relation (see above) and the preRemove function where the address List is set to null. Otherwise (no orphanremoval and adress list not set to null) a foreign key contraint fails. When i try to delete a user who has an vehicle a concurrent Acces Exception is thrown when do not uncomment the "this.owner.removeVehicle(this);" in the preRemove Function of the vehicle.

The thing i do not understand is that before i used this inheritance there was only a User class which had all relations:

 @Entity
 @Table(name = "Users")
 public class User implements Serializable {

  @Id
  protected String username;

  @OneToMany(mappedBy = "owner", cascade = {CascadeType.PERSIST, CascadeType.REMOVE})
  private List<Vehicle> vehicles;

  @OneToMany(cascade = CascadeType.ALL)
  @JoinTable(name = "USER_ADDRESS",
  joinColumns =
  @JoinColumn(name = "USERNAME")      
  inverseJoinColumns =
  @JoinColumn(name = "ADDRESS_ID"))
  ptivate List<Address> addresses;
  ...

No orphanremoval, and the vehicle class has used the uncommented statement above in its preRemove function. And - I could delte a user who has an address and i could delte a user who has a vehicle. So why doesn't everything work without changes when i use inheritance?

I use JPA 2.0, EclipseLink 2.0.2, MySQL 5.1.x and Netbeans 6.8

© Stack Overflow or respective owner

Related posts about jpa2.0

Related posts about inheritance