ORA-02291: integrity constraint, can not find parent key

[Kamil Kuchta]

@Entity
public class Person {
    @Id
    @GeneratedValue(strategy=GenerationType.SEQUENCE)
	private long id;
	private String name;
	private String surname;

	@ManyToOne(cascade = javax.persistence.CascadeType.ALL)
	@JoinColumn(name="city_id")
	private City city;

	public Person(){}
		
	public Person(String name, String surname, City city){
		
		this.name=name;
		this.surname=surname;
		this.city=city;
	}

	public long getId() {
		return id;
	}

	public String getName() {
		return name;
	}

	public String getSurname() {
		return surname;
	}
	public City getCity() {
		return city;
	}

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

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

	public void setSurname(String surname) {
		this.surname = surname;
	}

	public void setCity(City city) {
		this.city = city;
	}

  @Entity
public class City {

    @Id
    @GeneratedValue(strategy=GenerationType.SEQUENCE)
	private long id;
	private String name;
	
	public City(String name){
		this.name=name;
	}

	public long getId() {
		return id;
	}

	public String getName() {
		return name;
	}

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

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

}  

 
Person per = new Person("Kamil", "Jakis", new City("SomeCity"));
session.save(per);

I don't know why, Hibernate can not find the primary key of the City which was inserted in the same session with Person. I'm using Oracle 10g.

Hibernate: select diagno.hibernate_sequence.nextval from dual
Hibernate: select diagno.hibernate_sequence.nextval from dual
Hibernate: insert into diagno.City (name, id) values (?, ?)
Hibernate: insert into diagno.Person (name, surname, city_id, id) values (?, ?, ?, ?)

Exception in thread "main" org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
.
.
Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (DIAGNO.PERSON_CITY_FK) violated - parent key not found

[Cameron Wallace McKenzie]

It appears as simple as the error. You have a constraint that says an entry can't go in unless it's associated through it's primary key with another table. Seems like you must have something null going in as the reference key.

[Kamil Kuchta]

Unfortunatly, there is no null...
If I get already existing city object, it works fine:

City c = new CityDAOImpl().getCity(new Long(14));
Person per = new Person("Somename", "somesurname", c);
session.save(per);

but when the city object is going to be created w person in the same session it doesn't work

Person per = new Person("Kamil", "Jakis", new City("SomeCity"));  
session.save(per);

[Pablo Marmol]

I have this, i think it is the same thing:

https://coderanch.com/t/533735/ORM/java/two-parents-one-child-ora

What app server are using? JPA version?

[Vijitha Kumara]

G. Prasad,
Your post was moved to a new topic.

[Rachna Jotwani]

I am getting the same error. is there any updtae on how to fix this error?

[Telemart Network]

Try another theme or go for latest version. Your key might not be working in this & will execute in next one.