Author: d.plentz
Date: 2008-07-16 14:04:53 -0400 (Wed, 16 Jul 2008)
New Revision: 14938

Modified:
 core/trunk/core/src/main/java/org/hibernate/dialect/Oracle8iDialect.java
Log:
[HHH-1697] OracleDialect fails to recognize sequence accessible through syonyms when validating schema

Modified: core/trunk/core/src/main/java/org/hibernate/dialect/Oracle8iDialect.java
===================================================================
--- core/trunk/core/src/main/java/org/hibernate/dialect/Oracle8iDialect.java  2008-07-16 14:55:53 UTC (rev 14937)
+++ core/trunk/core/src/main/java/org/hibernate/dialect/Oracle8iDialect.java  2008-07-16 18:04:53 UTC (rev 14938)
@@(protected) @@
 }

 public String getQuerySequencesString() {
-    return "select sequence_name from user_sequences";
+    return   "select sequence_name from all_sequences "
+        + "union "
+        + "select synonym_name "
+        + " from all_synonyms us, all_sequences asq "
+        + " where asq.sequence_name = us.table_name"
+        + "  and asq.sequence_owner = us.table_owner";
 }

 public String getSelectGUIDString() {

_______________________________________________
hibernate-commits mailing list
hibernate-commits@(protected)
https://lists.jboss.org/mailman/listinfo/hibernate-commits