Unable to save data into child table

[Jitesh Sinha]

Hi All,

I think I am doing something that is very basic, incorrectly.
I have a parent child relation ship in my db and I am trying to save data.Data gets properly saved into parent table but it does not get saved into child table.

I have defined OneToMany relation in parent table and ManyToOne in child table.All of import statements are importing javax.persistence classes (can that be an issue?).

Another thing is that child class is child of two classes(It has two columns that have ManyToOne relations).Is that an issue?

Parent class :-

@Entity
@Table(name = "CSO_PROFILE")
@XmlRootElement
public class CsoProfile implements Serializable {

        private int csoProfileId;
	private String csoProfileName;
	private String defaultProfile;
	private String langPair; 
	private int transEngineProfileMapId;
	private String customerName;

private List<CustomerCsoProfileMap> customerCsoProfileMapList;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "csoProfileId")
	public List<CustomerCsoProfileMap> getCustomerCsoProfileMapList() {
        return customerCsoProfileMapList;
    }

    public void setCustomerCsoProfileMapList(List<CustomerCsoProfileMap> customerCsoProfileMapList) {
    	this.customerCsoProfileMapList = customerCsoProfileMapList;
    }

Child class -

@Entity
@Table(name = "CUSTOMER_CSO_PROFILE_MAP")
@XmlRootElement
public class CustomerCsoProfileMap {
	
	private int customerCsoProfilemapId;
	private Customer customerID;
    private CsoProfile csoProfileId;
	
    @SequenceGenerator(name = "CustCsoProfile_Gen", sequenceName = "customer_cpm_sequence")
    @Id
    @GeneratedValue(generator = "CustCsoProfile_Gen")
    @Basic(optional = false)
	@Column(name = "CUSTOMER_CSO_PROFILE_MAP_ID")
	public int getCustomerCsoProfilemapId() {
		return customerCsoProfilemapId;
	}
	public void setCustomerCsoProfilemapId(int customerCsoProfilemapId) {
		this.customerCsoProfilemapId = customerCsoProfilemapId;
	}
	
	
	@JoinColumn(name = "CUSTOMER_ID", referencedColumnName = "CUSTOMER_ID")
	@ManyToOne(optional = false)
	public Customer getCustomerID() {
		return customerID;
	}
	public void setCustomerID(Customer customerId) {
		this.customerID = customerId;
	}
	
	
	
	@JoinColumn(name = "CSO_PROFILE_ID", referencedColumnName = "CSO_PROFILE_ID")
    @ManyToOne(optional = false)
	 public CsoProfile getCsoProfileId() {
	        return csoProfileId;
	    }

	    public void setCsoProfileId(CsoProfile csoProfileId) {
	        this.csoProfileId = csoProfileId;
	    }

	}

Data should be saved in CustomerCsoProfileMap when data is inserted in CsoProfile.There is no error in logs.Also I see the insert statement for parent class and also the sequencename.nextval for parent class sequence in logs.I do not see any statement in logs for child class at all.
What am I doing wrong?

[James Sutherland]

What code do you use to persist the objects? Do you get any errors?

Make sure you persist both objects.
Ensure you set both sides of the relationship (add to 1-m and set m-1 back).

[Jitesh Sinha]

Thanks James.So you mean I have to write code to save data into both Parent and child tables?In that case,what is the use of putting relationship between parent and child(one-to-many and many-to-one)?
Just for getting all children from parent and getting parent from child?

[Jitesh Sinha]

Can someone please reply to above post?

I have another question as well(somewhat related).
Suppose I have a parent entity and child entity.I have set up one-to-many in parent and many-to-one in child correctly.
Now when setting up parent's attribute,I set the attribute of embedded child object as well.Something like this -

child.setOneAttribute("something") ;
child.setAnother("something") ;


parent.setAttributeA("something") ;
parent.setAttributeB("something") ;
parent.setChildJoinColumn(child) ;
hibernateSession.save(parent) ;//or maybe getHibernateTemplate().save(parent) ;


will it save the data in child entity as well?
Let me know if you want me to clarify anything.