Ajudem - Hibernate - setFetchMode

Front-end
#1

me ajuda galera

to com o problema que é o seguinte

eu preciso executar a seguinte consulta

 SELECT
  *
 from
  `in_menus` as a,
  `in_assoc_menu` as b
 WHERE
      a.idin_menus = b.idin_menus
      and b.idin_usuario = "1"

entao, nesse sql, eu tenho 2 tabelas relacionadas

eu nao consigo fazer isso no hibernate
to tentando o setFetchMode() mas so da erro

esse é meu InMenus.hbm.xml

 
 <?xml version="1.0"?>
 <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
 "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 <!-- Generated 19/04/2007 15:12:54 by Hibernate Tools 3.2.0.b9 -->
 <hibernate-mapping>
     <class name="com.br.sistema.bean.InMenus" table="in_menus" catalog="exportacao">
         <comment></comment>
         <id name="idInMenus" type="int">
             <column name="idIN_MENUS" />
             <generator class="native" />
         </id>
         <many-to-one name="inImagensMenu" class="com.br.sistema.bean.InImagensMenu" fetch="select" lazy="false">
             <column name="idIN_IMAGENS_MENU" not-null="true">
                 <comment></comment>
             </column>
         </many-to-one>
         <property name="descricao" type="string">
             <column name="DESCRICAO" not-null="true">
                 <comment></comment>
             </column>
         </property>
         <property name="link" type="string">
             <column name="LINK" not-null="true">
                 <comment></comment>
             </column>
         </property>
         <property name="ativo" type="char">
             <column name="ATIVO" length="1" not-null="true">
                 <comment></comment>
             </column>
         </property>
         <set name="inUsuarios" inverse="true" table="in_assoc_menu">
             <key>
                 <column name="idIN_MENUS" not-null="true">
                     <comment></comment>
                 </column>
             </key>
             <many-to-many entity-name="com.br.sistema.bean.InUsuario">
                 <column name="idIN_USUARIO" not-null="true">
                     <comment></comment>
                 </column>
             </many-to-many>
         </set>
     </class>
 </hibernate-mapping>

e esse meu outro la o InAssocMenu.hbm.xml

 
 <?xml version="1.0"?>
 <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
 "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 <!-- Generated 25/04/2007 11:21:35 by Hibernate Tools 3.2.0.b9 -->
 <hibernate-mapping>
     <class name="com.br.sistema.bean.InAssocMenu" table="in_assoc_menu" catalog="exportacao">
         <comment></comment>
         <composite-id name="id" class="com.br.sistema.bean.InAssocMenuId">
             <key-property name="idInUsuario" type="int">
                 <column name="idIN_USUARIO" />
             </key-property>
             <key-property name="idInMenus" type="int">
                 <column name="idIN_MENUS" />
             </key-property>
         </composite-id>
     </class>
 </hibernate-mapping>

ja tentei assim

 
 criteria.setFetchMode("inUsuarios", FetchMode.EAGER);
 criteria.add( Restrictions.eq("idInUsuario", user.getIdInUsuario() ) );
 java.util.List listaRet = criteria.list();
#2

bom

eu consegui o seguinte

se eu fizer so isso:

ele me atras, so que agora eu quero, exemplo, so com o usuario = ‘1’

dai eu coloco assim

criteria.add( Restrictions.eq("idInUsuario", user.getIdInUsuario() ) );

e não funciona, fala que nao existe a propriedade

no meu bean de usuarios, está assim:

 private Set<InUsuario> inUsuarios = new HashSet<InUsuario>(0);

e ou meu xml


<set name="inUsuarios" inverse="true" table="in_assoc_menu" outer-join="true" lazy="false">
            <key>
                <column name="idIN_MENUS" not-null="true">
                    <comment></comment>
                </column>
            </key>
            <many-to-many entity-name="com.br.sistema.bean.InUsuario">
                <column name="idIN_USUARIO" not-null="true">
                    <comment></comment>
                </column>
            </many-to-many>
        </set>
#3