Hello:

I 'm still working with the lists,now bags ,but i have a problem with the Parent/Child Relationships.

This is the problem:

<joined-subclass name="Productos.Producto" table="T_Producto">
<key column="P_IdProducto"/>
<many-to-one name="organizacion" class="Common.Organizacion" column="F_IdOrganizacion"/>

<bag name="suplementos" lazy="false" cascade="all" inverse="true">
<key column="P_IdProducto"/>
<one-to-many class="Productos.Suplemento"/>
</bag>

</joined-subclass>
<joined-subclass name="Productos.Suplemento" table="T_Suplemento">
<key column="P_IdSuplemento"/>
<many-to-one name="producto" class="Productos.Producto" column="P_IdProducto"/>
</joined-subclass>

and the application throws the followong exception
-----------
SEVERE: could not initialize collection: [Productos.Producto.suplementos#2]
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid column name 'P_IdProducto'.
----------
The column is the primary key of producto.

What im doing wrong?

Thanks

Enable Hibernate SQL logging and check the generated SQL, then validate your mapping.

ok,i ve already checked to true the logging and the following query were shown:(I only write the last that is the erroneous one)

Hibernate: select suplemento0_.P_IdSuplemento as P_IdSupl1___, suplemento0_.P_IdProducto as P_IdProd2___, suplemento0_.P_IdSuplemento as P_IdElem1_0_, suplemento0__1_.A_Nombre as A_Nombre11_0_, suplemento0__1_.A_Habilitado as A_Habili3_11_0_, suplemento0__1_.A_Orden as A_Orden11_0_, suplemento0__1_.A_BajaLogica as A_BajaLo5_11_0_ from T_Suplemento suplemento0_ inner join T_ElementoEditorial suplemento0__1_ on suplemento0_.P_IdSuplemento=suplemento0__1_.P_IdElementoEditorial where suplemento0_.P_IdProducto=?

obviously .P_IdProducto is not a field of suplemento but of producto,what i m doing wrong in the maps.

Thanks for your fast answer.

Take a look at http://www.xylax.net/hibernate/

In many-to-one, you're refering your object Id as a FK column, this is not allowed.
A one-to-one is suited for that.

following the reference and your answers,i reach a point where the following exception is thrown:

net.sf.hibernate.WrongClassException: Object with id: 1 was not of the specified subclass: Productos.Suplemento (loaded object was of wrong class).

the final xml is this:

<joined-subclass name="Productos.Producto" table="T_Producto">
<key column="P_IdProducto"/>
<many-to-one name="organizacion" class="Common.Organizacion" column="F_IdOrganizacion"/>
<bag name="suplementos" lazy="false" cascade="all" inverse="true">
<key column="F_IdProducto"/>
<one-to-many class="Productos.Suplemento"/>
</bag>

</joined-subclass>
<joined-subclass name="Productos.Suplemento" table="T_Suplemento">
<key column="P_IdSuplemento"/>
<many-to-one name="producto" class="Productos.Producto" column="F_IdProducto"/>
</joined-subclass>


The java code is the following:

List losProductos = GuiSGP.session.find("from Producto where F_IdOrganizacion =" + idOrganizacion
+ " and A_Habilitado =" + 1 + " and A_BajaLogica =" + 0);

Thanks

One of the suplementos elements is refering a class that is not of suplemento class. This isn't expected

I 'm inspecting the code and i cant find any "reference to a class that is not of suplemento class".

Could it be a problem with bags?.
Should i change the code and maps and set the collections as sets?

I'm pretty sure of me, there is a non supplemento class referenced in F_IdProducto column in your DB.
What is the type of id 1 ?

i dont understand :
"I'm pretty sure of me, there is a non supplemento class referenced in F_IdProducto column in your DB.
What is the type of id 1 ?"

F_idProducto references a Producto not a suplemento.
How can i know what type is id1 ?.

Ok,apparently the reason was in the db, i delete all the records from suplemento and create only a new one and it works.
I mean the maps were ok ,but i have to correct a bit the java code.
Anyway i would like that someone answer me the last question,thanks.

F_IdProducto is used to find all related Productos.Suplemento?

You know that id = 1 refers to a sub-class if the associated table (the one of the subclass) contains id = 1 in it's key.
In case of broken data, id=1 may be in several subclass tables: Hibernate cannot find the appropriate type.

Have a look at http://www.agiledata.org/essays/mappingObjects.html#MappingInheritance