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 Components: core Affects Versions: 3.3.0.CR1 Environment: Hibernate 3.1.2, Hibernate 3.1.3 Oracle 10g Reporter: Bjørn Bjerkeli Assignee: Diego Plentz 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.