Hello all!
i have a strange sorting result after the execution of a query with association may-to-one.
The sorted column has the same name as one in the parent table.

My HQL query: SELECT l FROM Interloc l INNER JOIN l.societe as s order by s.nom

Result: return the list interloc which is always sorted by l.nom not l.societe.nom

Here is xml config file:


<class
name="com.vecteurplus.webapp.inforum6.model.Interloc"
table="INTERLOC"
lazy="true"

>
<id
name="noInterlo"
type="int"
column="NO_INTERLO">

<generator class="increment"/>
</id>
<property
name="nom"
type="java.lang.String"
column="NOM"
length="150"
/>

<!-- bi-directional many-to-one association to Societe -->
<many-to-one
name="societe"
class="com.vecteurplus.webapp.inforum6.model.Societe"/>
<column name="NO_SOCIETE" />
</many-to-one>

==================================

<class
name="com.vecteurplus.webapp.inforum6.model.Societe"
table="SOCIETE"
lazy="true"
>
<id
name="noSociete"
type="int"
column="NO_SOCIETE"
>
<generator class="assigned" />
</id>
<property
name="nom"
type="java.lang.String"
column="NOM"
length="100"
/>
</class>
</hibernate-mapping>


Can anyone help me?
Thanks in avance!
Oro