HBM mapping Problem

[vivek kumar jaiswal]

Hello Ranchers,

Please see this mapping.

<class name="User" table="users">
<id name="id" column="id">
<generator class="identity" />
</id>
<discriminator column="user_type" type="string" />
<version name="version" column="version" />

<bag name="pchDetails" table="user_pch" lazy="false" inverse="true">
<key column="user_id"/>
<many-to-many column="pch" class="PchDetail"/>
</bag>
<bag name="workcenters" table="user_workcenter" inverse="true"
lazy="false">
<key column="user_id" />
<many-to-many column="workcenter_id" class="Workcenter" />
</bag>
<property name="firstName" column="first_name" />
<property name="middleName" column="middle_name" />
<property name="lastName" column="last_name" />
<property name="tokenNumber" column="token_number" />
<property name="userId" column="user_id" />
<property name="hashedPassword" column="hashed_password" />
<property name="randomCookie" column="random_cookie" />
<property name="userState" column="user_state" />
</class>

<class name="UserPch" table="user_pch">
<composite-id>
<key-property name="pchDetail" column="pch"/>
<key-property name="user" type="string" column="user_id"/>
</composite-id>
<many-to-one name="user" class="User" lazy="false" column="user_id" insert="false" update="false"/>
<many-to-one name="pchDetail" class="PchDetail" lazy="false" column="pch" insert="false" update="false"/>
<property name="tdate" type="java.util.Date" column="tdate"/>
</class>

<class name="PchDetail" table="pch_detail">
<id name="pch" column="pch"/>
<property name="pch" column="pch" insert="false" update="false"/>
</class>




Check this mapping

<bag name="pchDetails" table="user_pch" lazy="false" inverse="true">
<key column="user_id"/>
<many-to-many column="pch" class="PchDetail"/>
</bag>


The value of "user_id" column in "user_pch" table saved the value of "id" column in "users" table.

I want to save user_id column in users table to user_id column in user_pch.

Please what should I do.

regards,

vivek

[Waswani Naresh]

Hi Vivek,

I was not very comfortable with the concern/question that you have. I tried to simulate some thing similar using layman POJOs and mappings. Have a look at them and see if this helps to solve your problem.

Proj.java

package junk;

import java.util.Set;

public class Proj {

	private String projID;
	private String projName;

	private Set<EmpProj> employeeProjects;

	public String getProjID() {
		return projID;
	}

	public void setProjID(String projID) {
		this.projID = projID;
	}

	public String getProjName() {
		return projName;
	}

	public void setProjName(String projName) {
		this.projName = projName;
	}

	public Set<EmpProj> getEmployeeProjects() {
		return employeeProjects;
	}

	public void setEmployeeProjects(Set<EmpProj> employeeProjects) {
		this.employeeProjects = employeeProjects;
	}
}

Empl.java

package junk;

import java.util.Set;

public class Empl {

	private String empID;
	private String empName;

	private Set<EmpProj> employeeProjects;
	
	public Set<EmpProj> getEmployeeProjects() {
		return employeeProjects;
	}

	public void setEmployeeProjects(Set<EmpProj> employeeProjects) {
		this.employeeProjects = employeeProjects;
	}

	public String getEmpID() {
		return empID;
	}

	public void setEmpID(String empID) {
		this.empID = empID;
	}

	public String getEmpName() {
		return empName;
	}

	public void setEmpName(String empName) {
		this.empName = empName;
	}

}

EmpProj.java

package junk;

import java.io.Serializable;
import java.util.Date;

public class EmpProj implements Serializable {
	private static final long serialVersionUID = 1L;
	
	private Proj project;
	private Empl employee;
	
	private Date projectJoiningDate;

	public Proj getProject() {
		return project;
	}

	public void setProject(Proj project) {
		this.project = project;
	}

	public Empl getEmployee() {
		return employee;
	}

	public void setEmployee(Empl employee) {
		this.employee = employee;
	}

	public Date getProjectJoiningDate() {
		return projectJoiningDate;
	}

	public void setProjectJoiningDate(Date projectJoiningDate) {
		this.projectJoiningDate = projectJoiningDate;
	}
}

Proj.hbm.xml
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="junk"> <class name="Proj" table="PROJECT_1" > <id name="projID"></id> <property name="projName"></property> <set name="employeeProjects" table="EMP_PROJ" cascade="all" inverse="true"> <key column="PROJ_ID"></key> <one-to-many class="EmpProj"/> </set> </class> </hibernate-mapping>

Empl.hbm.xml
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="junk"> <class name="Empl" table="EMPLOYEE_1"> <id name="empID"></id> <property name="empName"></property> <set name="employeeProjects" table="EMP_PROJ" cascade="all" inverse="true"> <key column="EMP_ID"></key> <one-to-many class="EmpProj"/> </set> </class> </hibernate-mapping>


EmplProj.hbm.xml

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="junk"> <class name="EmpProj" table="EmpProj"> <composite-id> <key-many-to-one name="project" column="PROJ_ID"></key-many-to-one> <key-many-to-one name="employee" column="EMP_ID"></key-many-to-one> </composite-id> <many-to-one name="project" column="PROJ_ID" cascade="all" insert="false" update="false"></many-to-one> <many-to-one name="employee" column="EMP_ID" cascade="all" insert="false" update="false"></many-to-one> <property name="projectJoiningDate" type="date"></property> </class> </hibernate-mapping>


Main code for saving objects :

		session.beginTransaction();
		
		Empl e = new Empl();
		e.setEmpID("e1");
		e.setEmpName("Naresh");
		
		Proj p1 = new Proj();
		p1.setProjID("p1");
		p1.setProjName("Proj 1");

		Proj p2 = new Proj();
		p2.setProjID("p2");
		p2.setProjName("Proj 2");

		EmpProj ep1 = new EmpProj();
		ep1.setProject(p1);
		ep1.setProjectJoiningDate(new Date());
		ep1.setEmployee(e);
		
		EmpProj ep2 = new EmpProj();
		ep2.setProject(p2);
		ep2.setProjectJoiningDate(new Date());
		ep2.setEmployee(e);
		
		Set<EmpProj> epSet = new HashSet<EmpProj>();
		epSet.add(ep1);
		epSet.add(ep2);
		
		e.setEmployeeProjects(epSet);
		
		session.save(e);

Regards,
Naresh

[vivek kumar jaiswal]

Dear Naresh,

thanking to replying this concern i solved this problem.

<key column="user_id" property-ref="UserId"/>


regards,

VIVEK