following java code:

protected Entity loadEntityLightweight(Serializable entityId) throws DataAccessException {
Criteria criteria = getSession().createCriteria(Entity.class);
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Property.forName(BaseEntity.PROP_ID), BaseEntity.PROP_ID);
projectionList.add(Property.forName(BaseEntity.PROP_TYPE), BaseEntity.PROP_TYPE);
criteria.setProjection(projectionList);
criteria.add(Restrictions.eq(BaseEntity.PROP_ID, entityId));
criteria.setResultTransformer(new AliasToBeanResultTransformer(Entity.class));
return (Entity) criteria.uniqueResult();
}

generates following SQL query:

select this_.id as y0_, this_.type as y1_ from entities this_ left outer join facilities this_1_ on this_.id=this_1_.id left outer join users this_2_ on this_.id=this_2_.id left outer join addresses address2_ on this_.address_id=address2_.id left outer join entities entity3_ on this_2_.employer_id=entity3_.id left outer join facilities entity3_1_ on entity3_.id=entity3_1_.id left outer join users entity3_2_ on entity3_.id=entity3_2_.id where y0_=?

y0_ = ? expression in where clause is causing a 904 error on Oracle 9:

ORA-00904: "Y0_": invalid identifier

hibernate dialect: org.hibernate.dialect.Oracle9Dialect

mapping for Entity class:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping default-lazy="false" default-cascade="save-update">

<class name="Entity" table="entities" mutable="true">

<id name="id" type="java.lang.Long" unsaved-value="null">
<generator class="sequence">
<param name="sequence">entities_id_seq</param>
</generator>
</id>

<many-to-one name="address" class="Address" column="address_id" />

...

<!--

• Facilities
  -->
  <joined-subclass name="Facility" table="facilities">
  <key column="id" />

...
<set name="users" inverse="true" lazy="true">
<key column="facility_id" />
<one-to-many class="User" />
</set>
</joined-subclass>

<!--

• Users
  -->
  <joined-subclass name="User" table="users" dynamic-insert="true" dynamic-update="true">
  <key column="id" />

<many-to-one name="employer" class="Entity" column="employer_id" cascade="none" />

...
<set name="userAuthorities" inverse="true" cascade="all-delete-orphan">
<key column="user_id" />
<one-to-many class="Authority" />
</set>
</joined-subclass>

</class>
</hibernate-mapping>