Whats Wrong with my DO classes?

[Avinash Ga]

Hi Ranchers,

i am trying to do a cascade insert using hibernate with jpa. Here are my DO classes.

Person Class.....

@Entity
@Table(name="Person")
public class Person {

	@Id
	@TableGenerator(name="PersonIdGenerator", allocationSize=1, initialValue=1,
					pkColumnName="Entity", pkColumnValue="Person", valueColumnName="NextId", table="IdSequence")
	@GeneratedValue(strategy=GenerationType.TABLE, generator="PersonIdGenerator")
	private int id;
	
	private String name;
	
	private int age;
	
	private String gender;
	
	@OneToMany(cascade=CascadeType.ALL, fetch=FetchType.EAGER, mappedBy="person")
	private List<Address> addresses;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public String getGender() {
		return gender;
	}

	public void setGender(String gender) {
		this.gender = gender;
	}

	public List<Address> getAddresses() {
		return addresses;
	}

	public void setAddresses(List<Address> addresses) {
		this.addresses = addresses;
	}
	
}

Address Class.....

@Entity
@Table(name="Address")
public class Address {
	
	@Id
	@TableGenerator(name="AddressIdGenerator", allocationSize=1, initialValue=1,
					pkColumnName="Entity", pkColumnValue="Address", valueColumnName="NextId", table="IdSequence")
	@GeneratedValue(strategy=GenerationType.TABLE, generator="AddressIdGenerator")
	private int id;
	
	private String type;
	
	private String value;
	
	@ManyToOne(cascade=CascadeType.ALL)
	@JoinColumn(name="PersonId")
	private Person person;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getType() {
		return type;
	}

	public void setType(String type) {
		this.type = type;
	}

	public String getValue() {
		return value;
	}

	public void setValue(String value) {
		this.value = value;
	}

	public Person getPerson() {
		return person;
	}

	public void setPerson(Person person) {
		this.person = person;
	}
	
}

if i try to persist these do's like this.....

EntityManager entityManager = PersistenceHelper.getEntityManager();
		EntityTransaction entityTransaction = entityManager.getTransaction();
		entityTransaction.begin();
		entityManager.persist(person);
		entityTransaction.commit();
		entityManager.close();
		return person;

where person is....

Address address1 = new Address();
		address1.setType(address1type);
		address1.setValue(address1value);
		
		Address address2 = new Address();
		address2.setType(address2type);
		address2.setValue(address2value);
		
		List<Address> addresses = new ArrayList<Address>();
		addresses.add(address1);
		addresses.add(address2);
		
		Person person = new Person();
		person.setName(name);
		person.setAge(Integer.valueOf(age));
		person.setGender(gender);
		person.setAddresses(addresses);

i am getting the following exception.

javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: INSERT on table 'ADDRESS' caused a violation of foreign key constraint 'FK1ED033D4A2C3AF45' for key (9). The statement has been rolled back.
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1361)
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289)
org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:78)
com.mycomp.personproject.dataaccessobject.PersonDao.save(Unknown Source)

can you please help me understanding the mapping? can anyone tell me what am i missing here?

[Bill Gorder]

What is foreign key constraint 'FK1ED033D4A2C3AF45' for key (9) ? I don't see any reason why this would not run. I would initialize the address list and use add rather than set the whole list, but despite that what you have should insert 2 rows in Address and one row in Person. Maybe post your ddl.

[Avinash Ga]

Thanks for your time Bill,

Actually when i run this program in Derby DB, its creating new Foreign key constraints in Address table. I dont know why it is doing this. i will run this program for MS-Sql and try to analyse the problem. I will update soon.