HQL join returns no results.

[Mark A. Espinoza]

Hello all,

I am new to hibernate and am having trouble with making a join query in HQL.
This is between 2 classes with a one-to-many/many-to-one relationship.
I am trying to join in the second class based on matches between 2 columns,
where classA.jono = classB.jono. The relationship is one classA to many classB.
I am using a join table. I excluded the attributes I don't use in this query.
I am running this query in the eclipse HQL editor.

classA(Ent24DigB):

<?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>

    <class name="mil.army.yuma.enterprise.data.Ent24DigB" table="ent_24digb">
        <meta attribute="class-description">
            Represents the 24DigB table loaded from 'ENT.D24B.TXT'
            @author Mark Espinoza
        </meta>
        
        <id name="id" type="long" column="ent24DigBId">
        	<meta attribute="scope-set">protected</meta>
        	<generator class="identity">
            	    <param name="24DigBIdIdent">24digb_id_ident</param>
           	</generator>
        </id>

        <property name="jono" type="string">
            <column name="jono"/>
        </property>

 ....                

        <set name="trmsjono" 
        	 table="dig_b_trms_jono">
        	<key column="ent24DigBId"/>
        	<many-to-many column="entTrmsJonoId" 
        				 class="mil.army.yuma.enterprise.data.EntTrmsJono" 
        				 unique="true"/>
        </set>
        
    </class>

</hibernate-mapping>

classB(EntTrmsJono):

<?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>

    <class name="mil.army.yuma.enterprise.data.EntTrmsJono" table="ent_trmsjono">
        <meta attribute="class-description">
            Represents the trms jono table.
            @author Mark Espinoza
        </meta>
        
        <id name="id" type="long" column="entTrmsJonoId">
        	<meta attribute="scope-set">protected</meta>
           	<generator class="identity">
            	<param name="trmsJonoIdIdent">trms_jono_id_ident</param>
           	</generator>
        </id>

        <property name="jono" type="string">
            <column name="jono"/>
        </property>

  ......
                
        <property name="pe" type="string">
            <column name="pe"/>
        </property>

  ......
        
        <join table="dig_b_trms_jono"
        	  inverse="true"
        	  optional="true">
        	<key column="entTrmsJonoId"/>
        	<many-to-one name="ent24DigB"
        				 column="ent24DigBId" 
        				 class="mil.army.yuma.enterprise.data.Ent24DigB"
        				 not-null="false"/>
        </join>
        
    </class>

</hibernate-mapping>

The valid SQL that works is the following:

SELECT digb.jono,
            pe
FROM ent_24digb as digb
LEFT JOIN ent_trmsjono ON digb.jono = ent_trmsjono.jono

My HQL running is Eclipse HQL editor:

SELECT ent24DigB, ent24DigB.jono, jonot.pe
FROM Ent24DigB as ent24DigB
left join fetch ent24DigB.trmsjono as jonot
where jonot.jono = ent24DigB.jono

The HQL will run, no exceptions, warnings, or errors, but will return nothing.
The corresponding join table is empty.
Do I fill it? Does the query fill it? Do I use the "jono" columns somehow in my <set>
declaration? I am lost...despair....must finish...cough...cough. :P

Do you see me needing anything else in my collection definition?

I am running MySQL 5.1 Hibernate 3.3, Hibernate tools 3.2 Eclipse Galileo. Windows XP(not by choice).
Any help appreciated. Let me know of any more details you require.

thanks,
Mark

[Mark A. Espinoza]

Anyone?