[hibernate-issues] [JIRA] (HHH-13967) Oracle Sequence metadata retrievement through synonym not working anymore (induce schema validation failed)

[Christophe Janton (JIRA)]

Christophe Janton ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ea041268e58680c1ff598ee ) *created* an issue

Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTg0YzlhZTNmZDBmNDVhYTk1ZDI2ZmFkNmQ0MWJlMGMiLCJwIjoiaiJ9 ) / Bug ( https://hibernate.atlassian.net/browse/HHH-13967?atlOrigin=eyJpIjoiNTg0YzlhZTNmZDBmNDVhYTk1ZDI2ZmFkNmQ0MWJlMGMiLCJwIjoiaiJ9 ) HHH-13967 ( https://hibernate.atlassian.net/browse/HHH-13967?atlOrigin=eyJpIjoiNTg0YzlhZTNmZDBmNDVhYTk1ZDI2ZmFkNmQ0MWJlMGMiLCJwIjoiaiJ9 ) Oracle Sequence metadata retrievement through synonym not working anymore (induce schema validation failed) ( https://hibernate.atlassian.net/browse/HHH-13967?atlOrigin=eyJpIjoiNTg0YzlhZTNmZDBmNDVhYTk1ZDI2ZmFkNmQ0MWJlMGMiLCJwIjoiaiJ9 )

Issue Type: Bug Affects Versions: 5.4.13, 5.4.14 Assignee: Unassigned Components: hibernate-core Created: 22/Apr/2020 06:46 AM Priority: Major Reporter: Christophe Janton ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ea041268e58680c1ff598ee )

HHH-13322 ( https://hibernate.atlassian.net/browse/HHH-13322 ) breaks Oracle metadata retrievement when sequence are not owned by the user/shema but used through synonym. This is caused by the introduced query change from all_sequences to user_sequences.
Schema validation does'nt find the sequence anymore and failed.

I suggest to set the folowing query to manage both usecase :

select * from all_sequences seq where seq.sequence_owner = user or sequence_name in (select synonym_name from user_synonyms)

Best regards

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

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#100125- sha1:0a83519 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200422/edb0389b/attachment.html