delete-orphan with hibernate annotation

[Anand Loni]

Hello,

I am using hibernate annotation (hibernate 3.2.5). I am not able to delete orphan objects using @Cascade( { CascadeType.DELETE_ORPHAN }). When I googled for this, I found that delete-orphan not supported for the version I am using. Even I tried with version 3.5.0. Any idea how to delete orphans ?

Thanks,

[Paul Sturrock]

Not sure I understand the question. Are you saying this annotation doesn't work with a version of Hibernate that claims to support it, or are you asking how to get this functionality in an earlier version?

[Anand Loni]

Hi Paul,

Yes you are right. I want to delete orphan objects with the current version. Any ways to do this ?

Thanks

[Paul Sturrock]

Should be possible. Can we see your code?

[Anand Loni]

Here is the code

    
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.OneToOne;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

import org.hibernate.annotations.Cascade;
import org.hibernate.annotations.CascadeType;
import org.hibernate.annotations.CollectionOfElements;
import org.hibernate.annotations.LazyCollection;
import org.hibernate.annotations.LazyCollectionOption;

@Entity
@Table(name = "B_CANDIDATE_ENROLLMENT")
public class CandidateEnrollememt
{
	/**
	 * DOCUMENT ME!
	 */
	@SequenceGenerator(name = "CandidateEnrollememtSeq", sequenceName = "B_CANDIDATE_ENROLLMENT_SEQ")
	@Id
	@GeneratedValue(generator = "CandidateEnrollememtSeq")
	@Column(name = "CE_ID")
	Long id;

	/**
	 * DOCUMENT ME!
	 */
	@OneToOne
	@Cascade(CascadeType.ALL)
	@JoinColumn(name = "CD_ID")
	Candidate candidate;

	/**
	 * DOCUMENT ME!
	 */
	@Column(name = "CE_APPROVING_OFFICER")
	String approvingOfficer;

	/**
	 * DOCUMENT ME!
	 */
	@Column(name = "CE_UNIT")
	String unit;

	/**
	 * DOCUMENT ME!
	 */
	@OneToMany(cascade = javax.persistence.CascadeType.ALL)
	@Cascade( { CascadeType.DELETE_ORPHAN })
	@CollectionOfElements(targetElement = CandidateEnrollmentDetails.class)
	@JoinColumn(name = "CE_ID")
	@LazyCollection(LazyCollectionOption.FALSE)
	List<CandidateEnrollmentDetails> candidateEnrollmentDetails;


	public Long getId()
	{
		return id;
	}

	public void setId(Long id)
	{
		this.id = id;
	}
	
	/**
	 * @return
	 */
	public Candidate getCandidate()
	{
		return candidate;
	}

	/**
	 * @param candidate
	 */
	public void setCandidate(Candidate candidate)
	{
		this.candidate = candidate;
	}

	/**
	 * @return
	 */
	public String getApprovingOfficer()
	{
		return approvingOfficer;
	}

	/**
	 * @param approvingOfficer
	 */
	public void setApprovingOfficer(String approvingOfficer)
	{
		this.approvingOfficer = approvingOfficer;
	}

	/**
	 * @return
	 */
	public String getUnit()
	{
		return unit;
	}

	/**
	 * @param unit
	 */
	public void setUnit(String unit)
	{
		this.unit = unit;
	}

	public List<CandidateEnrollmentDetails> getCandidateEnrollmentDetails()
	{
		return candidateEnrollmentDetails;
	}


	public void setCandidateEnrollmentDetails(
			List<CandidateEnrollmentDetails> candidateEnrollmentDetails)
	{
		this.candidateEnrollmentDetails = candidateEnrollmentDetails;
	}



}

    
package com.dgmt.model;

import java.util.Date;
import java.util.List;
import java.util.Set;


import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.OneToOne;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

import org.hibernate.annotations.Cascade;
import org.hibernate.annotations.CascadeType;

import org.hibernate.annotations.Cascade;
import org.hibernate.annotations.CollectionOfElements;
import org.hibernate.annotations.LazyCollection;
import org.hibernate.annotations.LazyCollectionOption;
@Entity
@Table(name = "B_CANDIDATE_ENROLLMENT_DETAILS")
public class CandidateEnrollmentDetails {
	
	@SequenceGenerator(name = "CandidateEnrollmentDetailsSeq", sequenceName = "B_CANDIDATE_ENR_DTLS_SEQ")
	@Id
	@GeneratedValue(generator = "CandidateEnrollmentDetailsSeq")
	@Column(name = "CED_ID")
	Long id;
	
	/** Candidate Enrollement date. */
	@Column(name = "CED_EXAM_DATE")
	@Temporal(TemporalType.DATE)
	Date enrollmetExamDate;
		
	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public Date getEnrollmetExamDate() {
		return enrollmetExamDate;
	}

	public void setEnrollmetExamDate(Date enrollmetExamDate) {
		this.enrollmetExamDate = enrollmetExamDate;
	}
}

When I update CandidateEnrollment with new details, old details are unassociated but not deleted.

Thank,