[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-1697) OracleDialect fails to recognize sequence accessible through syonyms when validating schema

[Diego Plentz (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Diego Plentz updated HHH-1697:
------------------------------

             Assignee: Diego Plentz
    Affects Version/s: 3.3.0.CR1
          Component/s: core

> 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.

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira