net.sf.hibernate.QueryException: path expression ends in a composite value: versaodocu0_.id [from vo.VersaoDocumento vd1 where vd1.comp_id.documento.id = ? and vd1.id = (select max(vd2.id) from vo.VersaoDocumento vd2 where vd2.comp_id.documento.id = ?)]
   at net.sf.hibernate.hql.PathExpressionParser.getWhereColumn(PathExpressionParser.java:370)
   at net.sf.hibernate.hql.WhereParser.doPathExpression(WhereParser.java:352)
   at net.sf.hibernate.hql.WhereParser.doToken(WhereParser.java:366)
   at net.sf.hibernate.hql.WhereParser.token(WhereParser.java:251)
   at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
   at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
   at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
   at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
( ... )

( ... )
session = sessionFactory.openSession();
         
List res = session.find("from vo.VersaoDocumento vd1 where vd1.comp_id.documento.id = ? and " +
         "vd1.id = (select max(vd2.id) from vo.VersaoDocumento vd2 where vd2.comp_id.documento.id = ?)",
         new Object[] {documento_id, documento_id}, new Type[] {Hibernate.LONG, Hibernate.LONG});
( ... )      

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
   
<hibernate-mapping>
<!--
    Created by Middlegen Hibernate plugin

    http://boss.bekk.no/boss/middlegen/
    http://hibernate.sourceforge.net/
-->

<class
    name="vo.VersaoDocumento"
    table="versao_documento"
>

    <composite-id name="comp_id" class="vo.VersaoDocumentoPK">
        <key-property
            name="id"
            column="id"
            type="long"
            length="8"
        />
        <!-- bi-directional many-to-one association to Documento -->
        <key-many-to-one
           name="documento"
           class="vo.Documento"
       >
           <column name="documento_fk" />
       </key-many-to-one>
    </composite-id>   

    <property
        name="descricao"
        type="java.lang.String"
        column="descricao"
        length="-1"
    />

    <!-- associations -->

</class>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
   
<hibernate-mapping>
<!--
    Created by Middlegen Hibernate plugin

    http://boss.bekk.no/boss/middlegen/
    http://hibernate.sourceforge.net/
-->

<class
    name="vo.Documento"
    table="documento"
>

    <id
        name="id"
        type="long"
        column="id"
    >
        <generator class="increment" />
    </id>

    <property
        name="nome"
        type="java.lang.String"
        column="nome"
        length="-1"
    />

    <!-- associations -->
    <!-- bi-directional one-to-many association to VersaoDocumento -->
    <set
        name="versaoDocumentos"
        lazy="true"
        inverse="true"
        cascade="delete"
    >
        <key>
            <column name="documento_fk" />
        </key>
        <one-to-many
            class="vo.VersaoDocumento"
        />
    </set>

</class>
</hibernate-mapping>

( ... )
session = sessionFactory.openSession();
         
List res = session.find("from vo.VersaoDocumento vd1 where vd1.comp_id.documento.id = ? and " +
         "vd1.comp_id.id = (select max(vd2.id) from vo.VersaoDocumento vd2 where vd2.comp_id.documento.id = ?)",
         new Object[] {documento_id, documento_id}, new Type[] {Hibernate.LONG, Hibernate.LONG});
( ... )

( ... )
List res = session.find("from vo.Documento d join fetch d.versaoDocumentos vd where d.id = ? order by vd.comp_id.id asc", documento_id, Hibernate.LONG);
( ... )

Hibernate: select documento0_.id as id0_, versaodocu1_.id as id1_, versaodocu1_.documento_fk as document2_1_, documento0_.nome as nome0_, documento0_.descricao as descricao0_, documento0_.user_id as user_id0_, documento0_.dt_hr as dt_hr0_, documento0_.pasta_documento_fk as pasta_do6_0_, versaodocu1_.descricao as descricao1_, versaodocu1_.user_submissao as user_sub4_1_, versaodocu1_.data_submissao as data_sub5_1_, versaodocu1_.aprovado as aprovado1_, versaodocu1_.user_aprovacao as user_apr7_1_, versaodocu1_.data_aprovacao as data_apr8_1_, versaodocu1_.user_id as user_id1_, versaodocu1_.dt_hr as dt_hr1_, versaodocu1_.id as id__, versaodocu1_.documento_fk as document2___ from documento documento0_ inner join versao_documento versaodocu1_ on documento0_.id=versaodocu1_.documento_fk where (documento0_.id=? ) order by  versaodocu1_.id asc

Hibernate: select documento0_.id as id3_, documento0_.nome as nome3_, documento0_.descricao as descricao3_, documento0_.user_id as user_id3_, documento0_.dt_hr as dt_hr3_, documento0_.pasta_documento_fk as pasta_do6_3_, docproxver1_.documento_fk as document1_0_, docproxver1_.versao_actual as versao_a2_0_, docproxver1_.user_id as user_id0_, docproxver1_.dt_hr as dt_hr0_, pastasdocu2_.id as id1_, pastasdocu2_.nome as nome1_, pastasdocu2_.descricao as descricao1_, pastasdocu2_.user_id as user_id1_, pastasdocu2_.dt_hr as dt_hr1_, pastasdocu2_.pasta_documento_fk as pasta_do6_1_, pastasdocu3_.id as id2_, pastasdocu3_.nome as nome2_, pastasdocu3_.descricao as descricao2_, pastasdocu3_.user_id as user_id2_, pastasdocu3_.dt_hr as dt_hr2_, pastasdocu3_.pasta_documento_fk as pasta_do6_2_ from documento documento0_ left outer join doc_prox_versao docproxver1_ on documento0_.id=docproxver1_.documento_fk left outer join pastas_documento pastasdocu2_ on documento0_.pasta_documento_fk=pastasdocu2_.id left outer join pastas_documento pastasdocu3_ on pastasdocu2_.pasta_documento_fk=pastasdocu3_.id where documento0_.id=?

----- DOCUMENTO -----
ID: 3 + NOME: xpto.pdf
------ VERSAO_DOCUMENTO ------
ID: 2 ++ DESC: null ++ DATE: 2004-02-12 16:46:24.046
ID: 1 ++ DESC: null ++ DATE: 2004-02-12 16:43:05.0
------------------------------------