i have two tables employee with fields empid(primary key),name and age
and dependents table with fields depid(primary key),empid(foreign key),dependent name.

can you please provide the mapping file (hbm.xml)for the same.

thank you.

Hi Vibhuti,

May be you shud try to do somethng yourself and then if you get any issues.. post it... we can help u out...

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

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<hibernate-mapping>
<class name="com.iwms.hibernate.JavaBeans.TestFK.EmployeeDetails" table="employee" >
<id name="empId" type="java.lang.String" column="empid" ></id>
<property name="name" type="java.lang.String" column="name" length="30" />
<property name="age" type="java.lang.Integer" column="age" length="2" />

</class>

<class name="com.iwms.hibernate.JavaBeans.TestFK.DependentDetails" table="dependents">
<id name="depId" type="java.lang.String" column="depid" ></id>
<property name="empId" type="java.lang.String" column="empid" length="30" />
<property name="name" type="java.lang.String" column="name" length="30" />

</class>



</hibernate-mapping>




class file for dependent table:-

package com.iwms.hibernate.JavaBeans.TestFK;

import java.io.Serializable;

public class DependentDetails implements Serializable{

private static final long serialVersionUID = 1L;
private String empId;
private String depId;
private String name;
public String getDepId() {
return depId;
}
public void setDepId(String depId) {
this.depId = depId;
}
public String getEmpId() {
return empId;
}
public void setEmpId(String empId) {
this.empId = empId;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}


}



class file for employee table:-

package com.iwms.hibernate.JavaBeans.TestFK;

import java.io.Serializable;

public class EmployeeDetails implements Serializable{

private static final long serialVersionUID = 1L;
private String empId;
private String name;
private int age;

public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getEmpId() {
return empId;
}
public void setEmpId(String empId) {
this.empId = empId;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}

HI Vibhuti,,

change ur mapping file..

<id name="empId" type="java.lang.String" column="empid" >
<generator class="native">
</generator>
</id>


and tell me what is the relationship between ur these two classes(for foreign key)...then wil tell u the exact solution....

Here you have mapped the empId as String. But it actually points to an Employee object. So in OO paradigm, the property should be of type EmployeeDetails. So the mapping should be like: