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();