Author: epbernard Date: 2007-01-12 09:30:07 -0500 (Fri, 12 Jan 2007) New Revision: 11039 Modified: branches/Branch_3_2/HibernateExt/metadata/src/java/org/hibernate/cfg/annotations/MapBinder.java Log: ANN-529 remove as in subquery Modified: branches/Branch_3_2/HibernateExt/metadata/src/java/org/hibernate/cfg/annotations/MapBinder.java =================================================================== --- branches/Branch_3_2/HibernateExt/metadata/src/java/org/hibernate/cfg/annotations/MapBinder.java 2007-01-10 20:13:22 UTC (rev 11038) +++ branches/Branch_3_2/HibernateExt/metadata/src/java/org/hibernate/cfg/annotations/MapBinder.java 2007-01-12 14:30:07 UTC (rev 11039) @@ -282,7 +282,8 @@ String alias = "$alias$"; StringBuilder fromAndWhereSb = new StringBuilder( " from " ) .append( associatedClass.getTable().getName() ) - .append(" as ").append(alias).append(" where "); + //.append(" as ") //Oracle doesn't support it in subqueries + .append(alias).append(" where "); Iterator collectionTableColumns = element.getColumnIterator(); while ( collectionTableColumns.hasNext() ) { Column colColumn = (Column) collectionTableColumns.next();