from CategoryMap as map
join map.type
join fetch map.sourceCategory as source
join fetch map.targetCategory as target
where map.type=?

Hibernate: /*  from CategoryMap as map  join map.type join fetch map.sourceCategory as source join fetch map.targetCategory as target where map.type=? */
select categoryma0_.CATEGORY_MAP_ID as CATEGORY1_280_0_, categoryma1_.CATEGORY_MAP_TYPE_ID as CATEGORY1_281_1_, category2_.CATEGORY_ID as CATEGORY1_275_2_, category3_.CATEGORY_ID as CATEGORY1_275_3_, categoryma0_.UPDATE_TIMESTAMP as UPDATE2_280_0_, categoryma0_.START_DATE as START3_280_0_, categoryma0_.END_DATE as END4_280_0_, categoryma0_.CREATE_TIMESTAMP as CREATE5_280_0_, categoryma0_.UPDATE_USER_ID as UPDATE6_280_0_, categoryma0_.TYPE as TYPE280_0_, categoryma0_.SOURCE_CATEGORY_ID as SOURCE8_280_0_, categoryma0_.TARGET_CATEGORY_ID as TARGET9_280_0_, categoryma1_.UPDATE_TIMESTAMP as UPDATE2_281_1_, categoryma1_.CREATE_TIMESTAMP as CREATE3_281_1_, categoryma1_.UPDATE_USER_ID as UPDATE4_281_1_, categoryma1_.DESCRIPTION as DESCRIPT5_281_1_, categoryma1_.CODE as CODE281_1_, category2_.UPDATE_TIMESTAMP as UPDATE3_275_2_, category2_.CREATE_TIMESTAMP as CREATE4_275_2_, category2_.UPDATE_USER_ID as UPDATE5_275_2_, category2_.DESCRIPTION as DESCRIPT6_275_2_, category2_.TYPE as TYPE275_2_, category2_.SCOPE as SCOPE275_2_, category2_.CODE as CODE275_2_, category3_.UPDATE_TIMESTAMP as UPDATE3_275_3_, category3_.CREATE_TIMESTAMP as CREATE4_275_3_, category3_.UPDATE_USER_ID as UPDATE5_275_3_, category3_.DESCRIPTION as DESCRIPT6_275_3_, category3_.TYPE as TYPE275_3_, category3_.SCOPE as SCOPE275_3_, category3_.CODE as CODE275_3_
from CATEGORY_MAP categoryma0_
inner join CATEGORY_MAP_TYPE categoryma1_ on categoryma0_.TYPE=categoryma1_.CODE
inner join CATEGORY category2_ on categoryma0_.SOURCE_CATEGORY_ID=category2_.CATEGORY_ID
inner join CATEGORY category3_ on categoryma0_.TARGET_CATEGORY_ID=category3_.CATEGORY_ID
where categoryma0_.TYPE=?

Hibernate: /* load com...CategoryMapType */ select categoryma0_.CATEGORY_MAP_TYPE_ID as CATEGORY1_281_0_, categoryma0_.UPDATE_TIMESTAMP as UPDATE2_281_0_, categoryma0_.CREATE_TIMESTAMP as CREATE3_281_0_, categoryma0_.UPDATE_USER_ID as UPDATE4_281_0_, categoryma0_.DESCRIPTION as DESCRIPT5_281_0_, categoryma0_.CODE as CODE281_0_ from CATEGORY_MAP_TYPE categoryma0_ where categoryma0_.CODE=?

<hibernate-mapping>
   <class name="com...CategoryMap" table="CATEGORY_MAP">

      <id name="id" column="CATEGORY_MAP_ID" type="long" unsaved-value="any">
         <generator class="seqhilo">
            <param name="sequence">CATEGORY_MAP_SEQ</param>
            <param name="max_lo">1000</param>
         </generator>
       </id>

      <timestamp column="UPDATE_TIMESTAMP" name="updateTimestamp"/>
      
       <property name="startDate"       column="START_DATE"        type="date"/>
      <property name="endDate"         column="END_DATE"          type="date"/>
      <property name="createTimestamp" column="CREATE_TIMESTAMP"  type="timestamp"/>
      <property name="updateUserId"    column="UPDATE_USER_ID"    type="string"/>

      <many-to-one name="type"
         column="TYPE"
         class="com...CategoryMapType"
         property-ref="key.id"
         cascade="save-update"
         lazy="proxy"
         fetch="join"/>

      <many-to-one name="sourceCategory"
         column="SOURCE_CATEGORY_ID"
         class="com...Category"
         cascade="save-update"
         fetch="join"
         lazy="proxy"/>

      <many-to-one name="targetCategory"
         column="TARGET_CATEGORY_ID"
         class="com...Category"
         cascade="save-update"
         fetch="join"
         lazy="proxy"/>

  </class>

</hibernate-mapping>

<hibernate-mapping>
   
   <class name="com...CategoryMapType"
      proxy="com...ICategoryMapType"
      table="CATEGORY_MAP_TYPE" >
      
      <id name="id" column="CATEGORY_MAP_TYPE_ID" type="long"   unsaved-value="any">
         <generator class="seqhilo">
            <param name="sequence">CATEGORY_MAP_TYPE_SEQ</param>
            <param name="max_lo">100</param>
         </generator>
      </id>
      
      <timestamp name="updateTimestamp" column="UPDATE_TIMESTAMP"/>
      <property  name="createTimestamp" column="CREATE_TIMESTAMP" type="timestamp"/>
      <property  name="updateUserId"    column="UPDATE_USER_ID"   type="string"/>
      <property  name="description"     column="DESCRIPTION"      type="string"/>
      
      <component name="key" class="com...ICategoryMapType$CategoryMapTypeKey">
         <parent name="entity"/>      
         <property name="id" column="CODE" type="string"   not-null="true"/>
       </component>
       
  </class>

   <class name="com...ICategoryMapType$CategoryMapTypeKey" table="CATEGORY_MAP_TYPE" >
      
      <id name="id" column="CODE" type="string" />
      
      <many-to-one name="entity"
         column="CATEGORY_MAP_TYPE_ID"
          class="com...CategoryMapType"
          fetch="join"/>
  </class>
   
</hibernate-mapping>

Criteria criteria = getCriteria(ClassA.class)
             .setFetchMode("subOfB", FetchMode.JOIN)

@OneToOne(fetch = FetchType.LAZY, mappedBy = "subOfB")
protected ClassA classA;

@OneToOne(fetch = FetchType.LAZY)
@JoinColumn
@ForeignKey(name = "FK_CLASSA_SUBOFB")
private SubOfB subOfB;

Hibernate.initialize(criteria.list());

select * from ClassA, SubOfB, SuperB, SubOfSubOfB where (proper left join statements starting with ClassA)

select * from ClassA where subOfB_id=?