I'm using an example from Hibernate reference:

<class name="Order" table="orders">
<id name="id">
<generator class="native"/>
</id>
<property name="date"/>
<many-to-one name="customer" column="customer_id"/>
<list name="lineItems" table="line_items">
<key column="order_id"/>
<list-index column="line_number"/>
<composite-element class="LineItem">
<property name="quantity"/>
<many-to-one name="product" column="product_id"/>
</composite-element>
</list>
</class>

And when I load Order from database, and try to delete it, I got
this error:

org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1

It seems like line item are deleted, but then Hibernate try to update
this Order, insted of deleting it ?!

Please help.

Also, I'm getting this error here:

org.hibernate.ObjectDeletedException: deleted object would be re-saved by cascade (remove deleted object from associations): [org.hiberante.example.Order#2].

What is the problem ?!

O.K. I found solution for this second error (ObjectDeletedException), an Order must be deleted from collection which contains it when deleting.

But, I still getting this first error when I try to delete Order:

org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1

Order is has not been deleted ! What's the problem here ?