Referential Integrity Constraint Violation - Unidirectional OneToOne with Cascade.ALL, optional false and @PrimaryKeyColumnJoin

Description

Beginning from 5.2.14 our use case is not working anymore because of the change in HHH-9460. Our code looks like in the following:

Our use case is to share ID of parent without using Bidirectional association and while persisting parent, the child should be persisted with the ID of parent.

Before version 5.2.14, order of the relevant insert statements was:

Beginning from version 5.2.14, the order is:

This happens because parent has a foreign key constraint onto ID of child. If the parent will be persisted as first, child and ID of it does not exist, which causes ConstraintViolationException on flush.

Here is the Exception:

Problem in code is in class OneToOneSecondPass.java

Beginning from version 5.2.14 value.setForeignKeyType will be set to ForeignKeyDirection.TO_PARENT in our code. It was and should be set to ForeignKeyDirection.FROM_PARENT before version 5.2.14.

I tested this with the code above on 5.2.13.Final and there is no problem.

Environment

Windows 7 Enterprise
H2-Database 1.4.196
Spring Boot 2.0.0.Release

Activity

Show:
Gail Badner
April 17, 2018, 6:36 AM

Related to or duplicates HHH-12436.

Gail Badner
February 5, 2019, 12:16 AM

, are you still running into this issue with 5.4.1?

If so, please attach a test case. You can find test templates at https://github.com/hibernate/hibernate-test-case-templates.

Veli Döngelci
May 6, 2019, 3:34 PM

Hi, I need to check it. I will drop a comment here afterwards.

Veli Döngelci
August 15, 2019, 3:22 PM
Edited

Hi sorry for delay I was finally able to write tests. Uploaded as attachment.

Unfortunately I dont have access to source code anymore. I tried to demonstrate it again as much as I remember. There is only one test case and switching the version from 5.2.13.Final to 5.2.14.Final causes an exception.

And 5.4.1.Final was successful with the test above. so no issues anymore. Thanks.

Sanne Grinovero
February 27, 2020, 11:38 AM

Many thanks! I'll close this then.

Assignee

Unassigned

Reporter

Veli Döngelci

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Worked in

5.2.13

Components

Affects versions

Priority

Critical
Configure