I think this should be an easy question/answer, but I've been wrong before. I've defined a class that has a one-to-many relationship to another class, and I want the data from the one-to-many table to be returned as an array. Here's the definition of the parent class:

<class name="com.ibm.caes.wcs.db.cache.beans.UserPreferences" table="user">
<cache usage="read-write"/>
<id name="webId" column="webId"/>
<array name="searches" inverse="true" cascade="all, delete-orphan">
<cache usage="read-write"/>
<key column="userid" not-null="true"/>
<list-index column="index"/>
<one-to-many class="com.ibm.caes.wcs.db.cache.beans.SavedSearch"/>
</array>
</class>

Here's the definition of the one-to-many class, the data of which I want to be returned as an array:

<class name="com.ibm.caes.wcs.db.cache.beans.SavedSearch" table="iphrasesavedsearches">
<cache usage="read-write"/>
<composite-id>
<key-property name="userId"/>
<key-property name="index"/>
</composite-id>
<property name="ipState"/>
<property name="queryId"/>
<property name="rank"/>
<property name="name" column="pspname"/>
</class>

I update the userPreferences object using the saveOrUpdate() method. If I add elements to the array, the new elements are persisted just fine. If I rearrange the order of the elements in the array by modifying the index field, again the changes are persisted just fine. But, if I remove an element from the array, the removed element isn't deleted from the table when the saveOrUpdate() method is called. I don't seem to have this problem with other types of collections (such as a set).

Shouldnt' it be
<array name="searches" inverse="true" cascade="all-delete-orphan"> ?

per http://www.hibernate.org/hib_docs/v3/re ... tions.html

Nope, changing it from "all, delete-orphan" to "all-delete-orphan" didn't fix the problem. Also, the documentation shows both forms, so I don't know if they behave differently or not. But regardless, I still can't seem to get rid of deleted elements in an array from the corresponding database table.

Yes, by some reasons delete orphaned does not work with arrays.


does not cause unreferenced Address to be deleted



deletes unreferenced record from address.

I suggest submitting bug .
[/code]