We're updating the issue view to help you get more done. 

OracleDialect fails to recognize sequence accessible through syonyms when validating schema

Description

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.

Environment

Hibernate 3.1.2, Hibernate 3.1.3 Oracle 10g

Status

Assignee

DiegoP

Reporter

BjørnB

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

3.3.0.CR1

Priority

Minor