Hibernate version: 2

Hi,
I have mappings:
<class name="parent">
...
<list name="children" table="child" cascade="all">
<key column="PARENT_ID"/>
<index column="number"/>
<one-to-many class="child"/>
</list>
</class>

<class name="child">
...
<property name="number" column="number"/>
</class>

I want to have just two tables in DB. Without intervening collection table for childrens.
The only way I know I am able to do it is through <composite-element ..> in parent's children list mapping - change child with such composite.

Using <set> for children there is no such problem. But I'm loosing <index> element. I insist using list here but only with parent <-> child tables, not parent <-> children <-> child tables.
I hope the problem is clear.
Do you have any suggestions?

Cheers,
Maciek

Have you tried a child table like this?


jd

thanks for reply. yup I tried this stuff. but the problem was in my sql table definition. I've had not null field constraint in key table. so oracle transaction stuff wouldn't work with this. now it is ok.
thanks anyway!
-
Maciek