Hi,
I have been struggling to map a multi level complex table.
Here is my class A contains List of B and B contains List of C.

class A{
int a;
List<B> bList;
..
}
class B{
int b;
List<C> cList;
..
}
class C{
int c;
..
}

Here is my mapping sql

<class name="A" table="TABLE_A">
<id name="a" column="COL_A">
<generator class="increment"/>
</id>
<list name="bList" lazy="false" cascade="all">
<key column="b"/>
<index column="IDX"/>
<one-to-many class="B"/>
</list>
<property name="index" column="IDX" type="integer"/>
</class>

<class name="B" table="TABLE_B">
<id name="b"
column="COL_B">
<generator class="increment"/>
</id>
<list name="cList" lazy="false" cascade="all">
<key column="c"/>
<index column="IDX"/>
<one-to-many class="C"/>
</list>
<property name="index" column="IDX" type="integer"/>
</class>
<class name="C" table="TABLE_C">
<id name="c" column="COL_C">
<generator class="increment"/>
</id>
<property name="index" column="IDX" type="integer"/>
</class>

Got the following error
SEVERE: Exception executing batch:
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

What's wrong with about mapping? Please guide me.

Thanks
Raj

Don't know if this is what's causing your error, but you've made IDX writable in two places, which is definitely an error. Change all <property> elements toor to