[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1697?page=c...
]
Christophe Vanfleteren commented on HHH-1697:
---------------------------------------------
I'm not sure the above query is sufficient.
In our Oracle10g DB the above query did not find sequences owned by another user but
available via public synonyms.
OracleDialect fails to recognize sequence accessible through syonyms
when validating schema
-------------------------------------------------------------------------------------------
Key: HHH-1697
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1697
Project: Hibernate3
Issue Type: Bug
Environment: Hibernate 3.1.2, Hibernate 3.1.3 Oracle 10g
Reporter: Bjørn Bjerkeli
Priority: Minor
Attachments: Oracle9Dialect.java
The Dialect implementations in OracleDialect and Oracle9Dialect fails to recognize
sequences upon validation when they are accesssed through synonyms
because the user_sequences table will not create when the sequence is acced through a
synonym. This is needed when using hibernate.hbm2ddl.auto=validate
which is a very useful feature.
Thus sequences returned by:
public String getQuerySequencesString() {
return "select sequence_name from user_sequences";
}
will mot identify sequences accessible using a synonym.
By using this implementation:
public String getQuerySequencesString() {
return "select sequence_name from user_sequences " +
"union " +
"select synonym_name from user_synonyms us " +
"where exists (select 1 from all_objects ao where
object_type='SEQUENCE' and " +
"us.table_name = ao.object_name)";
}
orale will also return sequences acccessible though synonyms.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira