Hibernate: select hotelreser0_.code as x0_0_ from HotelReservation hotelreser0_ inner join Reservation hotelreser0__1_ on hotelreser0_.code=hotelreser0__1_.code where ((hotelreser0__1_.reportCode<>0 ))and((hotelreser0__1_.controlReservation=es.parsec.parsys.reservation.HotelReservation@1eae719 )) order by  hotelreser0__1_.creationDate descending
2242547 [http-8080-Processor25] WARN  net.sf.hibernate.util.JDBCExceptionReporter  - SQL Error: 117, SQLState: 01000
2242563 [http-8080-Processor25] ERROR net.sf.hibernate.util.JDBCExceptionReporter  - The number name 'es.parsec.parsys.reservation' contains more than the maximum number of prefixes. The maximum is 3.
2242578 [http-8080-Processor25] WARN  net.sf.hibernate.util.JDBCExceptionReporter  - SQL Error: 117, SQLState: 01000
2242594 [http-8080-Processor25] ERROR net.sf.hibernate.util.JDBCExceptionReporter  - The number name 'es.parsec.parsys.reservation' contains more than the maximum number of prefixes. The maximum is 3.
2242594 [http-8080-Processor25] ERROR net.sf.hibernate.util.JDBCExceptionReporter  - Could not execute query
java.sql.SQLException: The number name 'es.parsec.parsys.reservation' contains more than the maximum number of prefixes. The maximum is 3.

Iterator it = HibernateSession.currentSession().iterate("from HotelReservation as hr where (hr.reportCode = 0) and (hr.isReplacedByReservation is null) and (hr.confirmationStatus not like 'RQ')");
           
           
            while(it.hasNext())
            {
                HotelReservation res = (HotelReservation)it.next();
                             Iterator auxIt = HibernateSession.currentSession().iterate("from HotelReservation as hra where (hra.reportCode <> 0) and (hra.controlReservation = " + res.getControlReservation() + ") order by hra.creationDate descending");
.
.
.
.
.
            }

<class name="es.parsec.parsys.reservation.Reservation">
   <cache usage="read-write" />
   <id name="code" type="long" column="code" unsaved-value="null">
      <generator class="native"/>
   </id>
   <!--many-to-one name="travelFileHeader" class="es.parsec.parsys.travelfile.TravelFileHeader" column="travelFileHeader"/-->
   <many-to-one name="travelFileHeader" class="es.parsec.parsys.travelfile.TravelFileHeader" column="travelFileHeader"/>
   <property name="reference" type="string" length="50"/>
   <property name="leadPaxName" type="string"/>
   <many-to-one name="service" class="es.parsec.parsys.service.Service" column="service"/>
   <property name="creationDate" type="calendar"/>
   <property name="startDate" type="calendar_date"/>
   <property name="endDate" type="calendar_date"/>
   <many-to-one name="controlReservation" class="es.parsec.parsys.reservation.Reservation" column="controlReservation"/>
   <many-to-one name="replacesReservation" class="es.parsec.parsys.reservation.Reservation" column="replacesReservation"/>
   <many-to-one name="isReplacedByReservation" class="es.parsec.parsys.reservation.Reservation" column="isReplacedByReservation"/>
   <property name="isOnRequest" type="boolean"/>
   <many-to-one name="parsysUser" class="es.parsec.parsys.user.ParsysUser" column="parsysUser"/>
   <property name="confirmationStatus" type="string" length="3"/>
   <many-to-one name="branchOffice" class="es.parsec.parsys.agency.BranchOffice" column="branchOffice"/>   
   <property name="reservationType" type="string"/>
   
   <property name="reportCode" type="long"/>
   
   <set name="comments" inverse="true" lazy="true" order-by="comment" cascade="all">
       <key column="reservation"/>
        <one-to-many class="es.parsec.parsys.reservation.ReservationComment"/>
    </set>
   
   <joined-subclass name="es.parsec.parsys.reservation.HotelReservation" table="HotelReservation">
       <key column="code"/>       
       <set name="reservationRooms" inverse="true" lazy="true" order-by="reservation" cascade="all">
          <key column="reservation"/>
           <one-to-many class="es.parsec.parsys.reservation.ReservationRoom"/>
       </set>   
    </joined-subclass>

.
.
.
.
</class>