[hibernate-issues] [JIRA] (HHH-14035) Issue with Oracle 11g and ddl-auto set to validate (missing sequence)

[Benjamin Lefevre (JIRA)]

Benjamin Lefevre ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A4dab0624-351e-4310-b85d-8ffc2d7901fa ) *created* an issue

Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiODc2MmM4YzdmNGJmNDliMDk3OTU5ZDI5YjZjNzE3OTUiLCJwIjoiaiJ9 ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14035?atlOrigin=eyJpIjoiODc2MmM4YzdmNGJmNDliMDk3OTU5ZDI5YjZjNzE3OTUiLCJwIjoiaiJ9 ) HHH-14035 ( https://hibernate.atlassian.net/browse/HHH-14035?atlOrigin=eyJpIjoiODc2MmM4YzdmNGJmNDliMDk3OTU5ZDI5YjZjNzE3OTUiLCJwIjoiaiJ9 ) Issue with Oracle 11g and ddl-auto set to validate (missing sequence) ( https://hibernate.atlassian.net/browse/HHH-14035?atlOrigin=eyJpIjoiODc2MmM4YzdmNGJmNDliMDk3OTU5ZDI5YjZjNzE3OTUiLCJwIjoiaiJ9 )

Issue Type: Bug Affects Versions: 5.4.15, 5.4.16 Assignee: Unassigned Components: hibernate-core Created: 20/May/2020 14:32 PM Environment: Oracle 11G, Oracle10gDialect Labels: core hibernate Priority: Blocker Reporter: Benjamin Lefevre ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A4dab0624-351e-4310-b85d-8ffc2d7901fa )

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)

( https://hibernate.atlassian.net/browse/HHH-14035#add-comment?atlOrigin=eyJpIjoiODc2MmM4YzdmNGJmNDliMDk3OTU5ZDI5YjZjNzE3OTUiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14035#add-comment?atlOrigin=eyJpIjoiODc2MmM4YzdmNGJmNDliMDk3OTU5ZDI5YjZjNzE3OTUiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100127- sha1:9440fb1 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200520/7d1e8744/attachment.html