Problem with reading field in Hibernate

I am trying to do a simple query in HQL but I cannot figure out what is the cause of this error message. My flow is PowerDesigner->Generate SQL->Middle Gen->HBM2Java.

The error message I am getting looks like this:

Here are the relevant .hbm.xml files

(Videosession.hbm.xml)
 
<?xml version="1.0" ?> 
  <!DOCTYPE hibernate-mapping (View Source for full doctype...)> 
- <hibernate-mapping default-cascade="none" default-access="property" auto-import="true">
- <!-- 
 
    Created by the Middlegen Hibernate plugin 2.1
 
    <a href="http://boss.bekk.no/boss/middlegen/" target="_blank" rel="nofollow">http://boss.bekk.no/boss/middlegen/</a>
    <a href="http://www.hibernate.org/" target="_blank" rel="nofollow">http://www.hibernate.org/</a>

--> 
- <class name="roverlook.Videosession" table="videosession" mutable="true" polymorphism="implicit" dynamic-update="false" dynamic-insert="false" batch-size="1" select-before-update="false" optimistic-lock="version">
- <id name="videosessionid" type="java.lang.Integer" column="videosessionid" unsaved-value="null">
  <generator class="assigned" /> 
  </id>
  <property name="patientid" type="java.lang.String" column="patientid" length="30" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="playtype" type="java.lang.String" column="playtype" length="30" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="finalized" type="java.lang.Boolean" column="finalized" length="1" not-null="false" unique="false" update="true" insert="true" /> 
-  
-  
- <set name="videosessionmediamappings" lazy="true" inverse="true" cascade="none" sort="unsorted" batch-size="1" outer-join="auto">
- <key>
  <column name="videosessionid" /> 
  </key>
  <one-to-many class="roverlook.Videosessionmediamapping" /> 
  </set>
  </class>
  </hibernate-mapping>
 
-----------
 
(Videosessionmediamapping.xml)
 
<?xml version="1.0" ?> 
  <!DOCTYPE hibernate-mapping (View Source for full doctype...)> 
- <hibernate-mapping default-cascade="none" default-access="property" auto-import="true">
- <!-- 
 
    Created by the Middlegen Hibernate plugin 2.1
 
    <a href="http://boss.bekk.no/boss/middlegen/" target="_blank" rel="nofollow">http://boss.bekk.no/boss/middlegen/</a>
    <a href="http://www.hibernate.org/" target="_blank" rel="nofollow">http://www.hibernate.org/</a>

--> 
- <class name="roverlook.Videosessionmediamapping" table="videosessionmediamappings" mutable="true" polymorphism="implicit" dynamic-update="false" dynamic-insert="false" batch-size="1" select-before-update="false" optimistic-lock="version">
- <id name="mappingid" type="java.lang.Integer" column="mappingid" unsaved-value="null">
  <generator class="assigned" /> 
  </id>
  <property name="playorder" type="java.lang.Integer" column="playorder" length="4" not-null="false" unique="false" update="true" insert="true" /> 
-  
-  
- <many-to-one name="media" class="roverlook.Media" not-null="true" unique="false" outer-join="auto" update="true" insert="true">
  <column name="mediaid" /> 
  </many-to-one>
-  
- <many-to-one name="videosession" class="roverlook.Videosession" not-null="true" unique="false" outer-join="auto" update="true" insert="true">
  <column name="videosessionid" /> 
  </many-to-one>
  </class>
  </hibernate-mapping>
 
-------------

<?xml version="1.0" ?> 
  <!DOCTYPE hibernate-mapping (View Source for full doctype...)> 
- <hibernate-mapping default-cascade="none" default-access="property" auto-import="true">
- <!-- 
 
    Created by the Middlegen Hibernate plugin 2.1
 
    <a href="http://boss.bekk.no/boss/middlegen/" target="_blank" rel="nofollow">http://boss.bekk.no/boss/middlegen/</a>
    <a href="http://www.hibernate.org/" target="_blank" rel="nofollow">http://www.hibernate.org/</a>

--> 
- <class name="roverlook.Media" table="media" mutable="true" polymorphism="implicit" dynamic-update="false" dynamic-insert="false" batch-size="1" select-before-update="false" optimistic-lock="version">
- <id name="mediaid" type="java.lang.Integer" column="mediaid" unsaved-value="null">
  <generator class="assigned" /> 
  </id>
  <property name="title" type="java.lang.String" column="title" length="256" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="summary" type="java.lang.String" column="summary" length="255" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="duration" type="java.sql.Time" column="duration" length="8" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="iconpath" type="java.lang.String" column="iconpath" length="255" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="languageid" type="java.lang.Integer" column="languageid" length="4" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="rating" type="java.lang.String" column="rating" length="5" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="enabled" type="java.lang.Boolean" column="enabled" length="1" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="location" type="java.lang.String" column="location" length="255" not-null="false" unique="false" update="true" insert="true" /> 
  <property name="previewid" type="java.lang.Integer" column="previewid" length="4" not-null="false" unique="false" update="true" insert="true" /> 
-  
-  
- <set name="videosessionmediamappings" lazy="true" inverse="true" cascade="none" sort="unsorted" batch-size="1" outer-join="auto">
- <key>
  <column name="mediaid" /> 
  </key>
  <one-to-many class="roverlook.Videosessionmediamapping" /> 
  </set>
-  
- <set name="mediagenremappings" lazy="true" inverse="true" cascade="none" sort="unsorted" batch-size="1" outer-join="auto">
- <key>
  <column name="mediaid" /> 
  </key>
  <one-to-many class="roverlook.Mediagenremapping" /> 
  </set>
-  
- <many-to-one name="mediatype" class="roverlook.Mediatype" not-null="true" unique="false" outer-join="auto" update="true" insert="true">
  <column name="typeid" /> 
  </many-to-one>
-  
- <set name="mediagenres" lazy="true" cascade="none" table="mediagenremappings" sort="unsorted" inverse="false" batch-size="1" outer-join="auto">
- <key>
  <column name="mediaid" /> 
  </key>
- <many-to-many class="roverlook.Mediagenre" outer-join="auto">
  <column name="genreid" /> 
  </many-to-many>
  </set>
  </class>
  </hibernate-mapping>

My main confusion here is why the error says cannot find property 'title' of 'Videosessionmediamapping', where my query states 'vs.videosessionmediamappings. media.title'. I would expect it to associate 'title' with 'media' instead.

Another interesting thing I found is this query works:

Which leads me to believe there is a problem with the association between Videosessionmediamapping and Videosession.

Sorry for the long post, I tried to only give the mimimum information.

I just realized the exception came out on a single line. Here is a version of it which is easier to read: