How toPersist Value in the Tables Using Entity Bean

[Rahman ziaur]

Hi All Suppose i have two table Parent and child.
Parent table having one Primary key and my Child table contaion child_id as primary key and Parent_id as foriegn key.
There is oneto Many relationship among my tables.
Please help me i could i save the value in Child table for foriegn key.
I am able to persist value in Parent table but not able in Child table.Is it any way through which i insert in parent and its automaticaaly reflect on Child table.


Any suggestion,help must be Appreciated.
Thanks in Advance.

[Komal Renu]

Could you please list out more details ? architecture etc

[Rahman ziaur]

I have two table--
1-[code=javaCREATE TABLE `ttdb`.`competence` (
`competence_id` int(10) unsigned NOT NULL auto_increment,
`competence_name` varchar(45) NOT NULL,
`competence_desc` varchar(100) default NULL,
`competence_status` varchar(45) NOT NULL,PRIMARY KEY (`competence_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;[/code]


2nd table is---CREATE TABLE `ttdb`.`competence_section` ( `section_id` int(10) unsigned NOT NULL auto_increment, `section_name` varchar(45) NOT NULL, `competence_id` int(10) unsigned NOT NULL,PRIMARY KEY (`section_id`), KEY `competence_id` (`competence_id`), CONSTRAINT `competence_id` FOREIGN KEY (`competence_id`) REFERENCES `competence` (`competence_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


and i have two Entity class for them...

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

@Entity
@Table(name="competence")
public class Competence implements Serializable{
	
	
	
	
	/**
	 * @author rahmazia
	 */
	
	private static final long serialVersionUID = 6113818477083288423L;

	private static final CascadeType[] ALL = null;
	
	@Id
	@GeneratedValue(strategy=GenerationType.SEQUENCE)
	
	private int competence_id;
	private String competence_name;
	private String competence_desc;
	private String competence_status;
@OneToMany(cascade=CascadeType.ALL,fetch=FetchType.EAGER,mappedBy="competence")
	
	private List<CompetenceSection> competenceSection;
public void addCompetenceSection(String sectionName,String sectionDesc,String sectionStatus,int createdBy,Date  createdDate,int modifiedBy,Date modifiedDate)
	
	{
		if(competenceSection==null)
		{
			competenceSection=new ArrayList<CompetenceSection>();
			CompetenceSection  cSection=new CompetenceSection();
			cSection.setSectionName(sectionName);
			cSection.setSectionDesc(sectionDesc);
			cSection.setSectionStatus(sectionStatus);
			cSection.setCreatedBy(createdBy);
			cSection.setCreatedDate(createdDate);
			cSection.setModifiedBy(modifiedBy);
			cSection.setModifiedDate(modifiedDate);
			cSection.setCompetence(this);
			competenceSection.add(cSection);
			setCompetenceSection(competenceSection);
			System.out.println(competenceSection);
			
		}
		
		
  }




and getter setter for the field.

@Entity
@Table(name="Competence_section")
public class CompetenceSection implements Serializable{
	 
	private static final long serialVersionUID = 3432477037435974502L;
	/**
	 * @author rahmazia
	 */
	@Id
	 @GeneratedValue(strategy=GenerationType.SEQUENCE)
	@Column(name="section_id")
	 private int sectionId;
	@Column(name="section_name")
@ManyToOne(cascade={CascadeType.MERGE,CascadeType.PERSIST,CascadeType.REFRESH})
	@JoinColumn(name="competence",nullable=false)
	 private Competence competence;
	 
}
}
and getter setter methods...

i have two method
one to CreateCompetence and another for createCompetencESection.

So how i can insert the value in the Refrence key Table.

Kindly give me the logic how to write function logic for
CreateCompetenceSection........

[Cor Takken]

I think you can clarify your question even more if you can show us the code snippet showing where you persist your parent and particularly where you place the child "in" the parent... And perhaps some of the setter methods of the child, but that depends on how how link the child to the parent.