I have a big object graph with some association within some objects.I am facing problem with deletion.

My annotation as below.

@Entity
@Table(name = "t_person")
public final class Person
{
.....................
......................

@OneToMany(fetch = FetchType.LAZY)
@Cascade(
{
org.hibernate.annotations.CascadeType.SAVE_UPDATE,
org.hibernate.annotations.CascadeType.DELETE_ORPHAN
})
@JoinTable(name = "t_per_cars", joinColumns =
{
@JoinColumn(name = "fk_to_person")
})
@IndexColumn(name = "car_list_position", base = 1)
private List<Car> cars = new ArrayList<Car>();
.........................................
..........................................

}

@Entity
@Table (name="t_car")
@GenericGenerator(name="car-uuid", strategy="uuid",
parameters={@Parameter(name="separator", value="-")})
public class Car implements Vehichel
{
..............
// Many other association
...............
}


in that case it generates the three tables between Person and Car object
t_person,t_per_cars,t_car

I need to delete the Person object as well as all the cascade object with related to persons
In my case all the related cars object with the Person.
But above mapping just remove the reference between person and car object .It didn't delete the actual car object from the t_car table.

So what should I make a change to delete the all object which are associate with person object while I am going to delete the person object??

There are more and more orphan data in my DB.

Is there anyway hibernate handle that ??

Hi jigu4paint,

I'm not sure if works stand alone without or
Anyway, you post So, your car instances may have other associations which keeps them from being deleted?

CU
Froestel

So you mean I required DELETE in case to use DELETE_ORPHAN??

@OneToMany(fetch = FetchType.LAZY)
@Cascade(
{
org.hibernate.annotations.CascadeType.SAVE_UPDATE,
org.hibernate.annotations.CascadeType.DELETE
org.hibernate.annotations.CascadeType.DELETE_ORPHAN
})
@JoinTable(name = "t_per_cars", joinColumns =
{
@JoinColumn(name = "fk_to_person")
})
@IndexColumn(name = "car_list_position", base = 1)
private List<Car> cars = new ArrayList<Car>();


Anyway, you post
jigu4paint wrote:
Code:
public class Car implements Vehichel {
..............
// Many other association
...............
}
So, your car instances may have other associations which keeps them from being deleted?


Yes , just like Person and car association and many more..

for example.

public class Car implements Vehichel {

......................


@CollectionOfElements(targetElement = Part.class)
@JoinTable(name = "t_carpats", joinColumns = { @JoinColumn(name = "car_id", nullable=false) })
@MapKey(columns = @Column(name="part_id", nullable=false))
@Column(name = "partname")
public Map<String, Part> part = new HashMap<String,Part>();


// Many other association
...............
}

Maybe, I don't know - try.


... and possibly one of these collections prevents car from being deleted. Does not look like you have a cascading delete down to the part collection. Since that one joins on the car_id column, not to be nullable, deletion of cars does not work.

CU
Froestel

btw: Please use BBCode - see buttons below the subject field - makes your posts much easier to read if used properly.

I tried with your opinion with DELETE which is not working.