[hibernate-issues] [Hibernate-JIRA] Commented: (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:comment-tabpanel#action_30181 ] 

Diego Plentz commented on HHH-1697:
-----------------------------------

This sequence works with at least 8i. Sources:

http://www.oracle.com/pls/db102/
http://www.oracle.com/pls/db111/
http://www.oracle.com/pls/tahiti/
http://www.oracle.com/pls/db92/

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