Hello:

I have the following many to many relationship:
Product_type - oganization.
Where a organization may have several product types ,a product type may have several organizations (many to many).

The problem is the following the organization class dont have a product_type setter/getter ,neither product_type has organization setter/getters ,but i must retrieve from a organization all the product types linked.
I think that i must use a find ,or use HSQL,but i dont know if its possible without setter/getter.

Tables:

product_type --- product_typeOrganization --- Organization
product_id --- product_id organization_id --- organization_id

Any suggestion?.

Do i MUST include setters/getters to use hibernate?.

ok,i exagerated a bit.
Product_type has a setter/getter List Organization.
Could i do something like this.

tipoproductos = GuiSGP.session.find("from TipoProducto where F_IdOrganizacion =" + idOrganizacion);

Where F_IdOrganizacion is a field of the collection table.

show the mapping it's easier.

Thanks emmanuel,I tried this ,but the following exception was thrown.

net.sf.hibernate.QueryException: outer or full join must be followed by path expression [select tipoproducto from Productos.TipoProducto tipoproducto join Organizacion organizacion where organizacion.idOrganizacion=1]
t net.sf.hibernate.hql.FromParser.token(FromParser.java:166)

mappings:

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

<hibernate-mapping>
<class name="Productos.TipoProductoOrganizacion" table="T_TipoProductoOrganizacion">
<id name="idTipoProductoOrganizacion" column="P_IdTipoProductoOrganizacion" type="int">
<generator class="identity"/>
</id>
<many-to-one name="organizacion" class="Common.Organizacion" column="F_IdOrganizacion"/>
<many-to-one name="tipoProducto" class="Productos.TipoProducto" column="F_TipoProducto"/>
</class>
</hibernate-mapping>


<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="Common.Organizacion" table="T_Organizacion">
<id name="idOrganizacion" column="P_IdOrganizacion" type="int">
<generator class="identity"/>
</id>
<property name="nombre" column="A_RazonSocial" type="string" />
<property name="predeterminada" column="A_Predeterminada" type="boolean" />
<property name="bajaLogica" column="A_BajaLogica" type="boolean" />
</class>
</hibernate-mapping>

My fault.