Christophe Janton (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ea0412...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTg0YzlhZTNm...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-13967?atlOrigin=eyJpIjoiNTg0Yz...
) HHH-13967 (
https://hibernate.atlassian.net/browse/HHH-13967?atlOrigin=eyJpIjoiNTg0Yz...
) Oracle Sequence metadata retrievement through synonym not working anymore (induce schema
validation failed) (
https://hibernate.atlassian.net/browse/HHH-13967?atlOrigin=eyJpIjoiNTg0Yz...
)
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=5ea0412...
)
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=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-13967#add-comment?atlOrigin=ey...
)
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....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100125- sha1:0a83519 )