SchemaExport creates foreign keys too early if across schema

Description

Our schema export used to work perfectly with Hibernate 4.x but fails after update to 5.0.

It turned out that the new SchemaMigratorImpl tries to create the foreign keys after the tables of a schema are complete. This however fails if those keys refer to tables in a different schema which have not yet been processed.

The old Configuration.generateSchemaUpdateScriptList created the foreign keys after the tables from all schema had been processed.

We created a test project on https://github.com/abenneke/sandbox/tree/master/hibernate-schema where

FirstParent from schema FIRST has children from SecondChild from schema SECOND
and
SecondParent from schema SECOND has children from FirstChild from schema FIRST

(both directions to make the creation order irrelevant, but note that there is no circle)

SchemaExport of Hibernate 4 created those tables this way:

1 2 3 4 5 6 create table FIRST.FirstChild (id varchar(255) not null, parent_id varchar(255), primary key (id)) create table FIRST.FirstParent (id varchar(255) not null, primary key (id)) create table SECOND.SecondChild (id varchar(255) not null, parent_id varchar(255), primary key (id)) create table SECOND.SecondParent (id varchar(255) not null, primary key (id)) alter table FIRST.FirstChild add constraint FK... foreign key (parent_id) references SECOND.SecondParent alter table SECOND.SecondChild add constraint FK... foreign key (parent_id) references FIRST.FirstParent

whereas Hibernate 5 now fails with

1 2 3 4 create table FIRST.FirstChild (id varchar(255) not null, parent_id varchar(255), primary key (id)) create table FIRST.FirstParent (id varchar(255) not null, primary key (id)) alter table FIRST.FirstChild add constraint FK... foreign key (parent_id) references SECOND.SecondParent HHH000389: Unsuccessful: alter table FIRST.FirstChild add constraint FK... foreign key (parent_id) references SECOND.SecondParent

Please note also that hibernate.hbm2ddl.auto with create simply reports this error and continues and update fails with a SchemaManagementException: Unable to execute schema management to JDBC target

Environment

None

Status

Assignee

Andrea Boriero

Reporter

Andreas Benneke

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

5.0.6

Priority

Major