Hibernate: How to maintain data integrity between parent and child?

Hibernate ORM
1

I have two entities called owner and pet and its One-to-One mapping unidirectional
Using transaction to perform persist operation. When there are any Issues while saving owner entity, I assumed pet entity should not persist and rollback. But in real scenario pet entity getting persisted. I tried to off auto commit in mysql and tried but that didn’t worked. there should not be any pet with out owner.

@OneToOne(cascade = CascadeType.ALL, optional = false)
@JoinColumn(name = “pet_id”, referencedColumnName = “id”,unique = true,nullable = false)
private Pet pet;

2

How are you persisting these entities? You should use a single transaction where you persist both the owner and the pet, so that if an error occurs at any point the entire transaction will be rolled back. Read more about transactions in our user guide.

3

try (Session session = sessionFactory.openSession()) {
transaction = session.beginTransaction();
session.persist(owner);
transaction.commit();
} catch (Exception e ) {
transaction.rollback();
}

4

Then you’re missing a not-null constraint on the pet_id column. Add that and the insert will fail.