[hibernate-issues] [JIRA] (HHH-14039) Oracle schema validation fails due to missing sequences

[Varun Shrivastava (JIRA)]

Varun Shrivastava ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec5c9b1a1925f0c1943c512 ) *created* an issue

Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZGQ1NTJkNDI1Nzc4NDJhOWFmZTYyNmQxN2MzZDkyMzkiLCJwIjoiaiJ9 ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14039?atlOrigin=eyJpIjoiZGQ1NTJkNDI1Nzc4NDJhOWFmZTYyNmQxN2MzZDkyMzkiLCJwIjoiaiJ9 ) HHH-14039 ( https://hibernate.atlassian.net/browse/HHH-14039?atlOrigin=eyJpIjoiZGQ1NTJkNDI1Nzc4NDJhOWFmZTYyNmQxN2MzZDkyMzkiLCJwIjoiaiJ9 ) Oracle schema validation fails due to missing sequences ( https://hibernate.atlassian.net/browse/HHH-14039?atlOrigin=eyJpIjoiZGQ1NTJkNDI1Nzc4NDJhOWFmZTYyNmQxN2MzZDkyMzkiLCJwIjoiaiJ9 )

Issue Type: Bug Assignee: Varun Shrivastava ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec5c9b1a1925f0c1943c512 ) Components: hibernate-core Created: 20/May/2020 17:39 PM Priority: Major Reporter: Varun Shrivastava ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec5c9b1a1925f0c1943c512 )

https://github.com/hibernate/hibernate-orm/commit/188c05cc333dec0fe3edfefd8f27fe19b63c702a
Fetching only user_sequences instead of all_sequences in Oracle8iDialect is a breaking change for many application.
Hibernate-core is updated with spring-boot-dependencies update from 2.2.6 to 2.2.7.

Usually, user creating DB resources (sequences) is admin even if flyway/liquibase is used then user creating the DB resources is different from the DB user running the application.

With Spring config spring.jpa.hibernate.ddl-auto=validate the startup of application fails as it cannot find the user_sequences which is owned by other users.

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

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/20200521/8d54baef/attachment.html