Issue with Oracle 11g and ddl-auto set to validate (missing sequence)

Description

Since I bumped to spring-boot 2.3.0 (which comes with hibernate-orm 5.4.15.Final) I got a severe issue at startup (app doesn't even start).

Context
Oracle 11g / Oracle10gDialect
spring.jpa.hibernate.ddl-auto: validate (because of legacy context, deactivate ddl validation is not an option)

It fails with this message on one of my entity (the sequence is of course existing):

[PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing sequence [seq_canal]

Same code was working with spring boot 2.2.6 (hibernate 5.4.12.Final)

Environment

Oracle 11G, Oracle10gDialect

Activity

Show:
Benjamin Lefevre
May 21, 2020, 5:49 AM

In my particular cases the sequences are owned by another Oracle user, and granted to the app user.

Benjamin Lefevre
May 22, 2020, 7:00 AM

It seems to be in double with

Sanne Grinovero
July 20, 2020, 2:53 PM

is this a duplicate of ?

Andrea Boriero
July 20, 2020, 3:43 PM

Hi can you please try if the problem persists with the last hibernate version ( 5.4.18) ? Thanks

Assignee

Unassigned

Reporter

Benjamin Lefevre

Fix versions

None

Labels

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Worked in

5.4.12

Components

Affects versions

Priority

Blocker
Configure