delete option of cascade in Hibernate one-to-one association

[Soumya Ranjan Mohanty]

I am not able to delete the corresponding one-to-one relation row using delete option of cascade. Here are the code for my class and Mappings.

Code For Employee.java Class.

public class Employee {
	private int eno;
	private String ename;
	PersonalDetails personalDetails;
	public int getEno() {
		return eno;
	}
	public void setEno(int eno) {
		this.eno = eno;
	}
	public String getEname() {
		return ename;
	}
	public void setEname(String ename) {
		this.ename = ename;
	}
	public PersonalDetails getPersonalDetails(){
		return personalDetails;
	}
	public void setPersonalDetails(PersonalDetails pd){
		personalDetails=pd;
	}

}

Code for PersonalDetails.java Class

public class PersonalDetails {
	private int eno;
	private String fname,lname;
	Employee emp;
	
	public int getEno(){
		return eno;
	}
	public void setEno(int eno){
		this.eno=eno;
	}
	public String getFname(){
		return fname;
	}
	public void setFname(String fname){
		this.fname=fname;
	}
	public String getLname(){
		return lname;
	}
	public void setLname(String lname){
		this.lname=lname;
	}
	public void setEmp(Employee emp){
		this.emp=emp;
	}
	public Employee getEmp(){
		return emp;
	}
}

mapping -- Employee.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
    
<hibernate-mapping package="com.titu.hibernate">
	<class name="com.titu.hibernate.Employee">
		<id name="eno" column="eno">
			
			<generator class="foreign">
				<param name="property">personalDetails</param>
			</generator>			
		</id>
		<property name="ename" column="ename"></property>
		<one-to-one name="personalDetails" class="PersonalDetails" cascade="delete"></one-to-one>
	</class>
</hibernate-mapping>

mapping- PersonalDetails.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>



<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
    
<hibernate-mapping package="com.titu.hibernate">
	<class name="PersonalDetails">
		<id name="eno" column="eno">
			<generator class="increment"></generator>			
		</id>
		<property name="fname" column="fname"></property>
		<property name="lname" column="lname"></property>
		<one-to-one name="emp" class="Employee" constrained="true"></one-to-one>
	</class>
</hibernate-mapping>

When i delete any row from Employee table the Corresponding Foreign key row in PersonalDetails Table is not deleting. Please Help Me.

Thanks

[joy b chakravarty]

Interesting.. Not exactly sure why this one-to-one bidirectional relation is giving you trouble.

Can you try removing this
<generator class="foreign">
<param name="property">personalDetails</param>
</generator>

and instead have the following in the mapping- PersonalDetails.hbm.xml

<generator class="foreign">
<param name="property">emp</param>
</generator>

[Soumya Ranjan Mohanty]

i did exactly what you said and it's working fine. Thanks a lot joy b chakravarty .Can you please explain what was the mistake so that i can clear my doubt.

Again Thanks a lot.

[joy b chakravarty]

In a relationship, there is an owning side, here what you wanted is Employee as the owing side.
with your earlier configuration PersonalDetails became the owing side as the PersonalDetails 'eno' was assigned to an employee which shouldn't have been the case.
reversing that made Employee the owing side. Hope this helps.