2.x with Spring 1.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:



General Question for a one to many Relationship:

I have the foll relationship:
Entity (one) to phones (many)
On deleting a phone num from the phone num collection, the phone num record gets de-referenced in the data base, i.e. the entity_id foreign-key is removed but the phone num record still remains, it is not physically deleted.

Thanks in advance.

I agree with that statement.

:)

The purpose was: Is there a way to physically delete the record instead of just de-referencing through Hibernate?

Thanks..

yes. search docs/forums/wiki for "delete-orphan" cascade option

Here're the mapping details:
------------------------------------
<list name="phoneNos" inverse="false" cascade="all-delete-orphan">
<key column="entity_id"/>
<index column="entity_id_index"/>
<one-to-many class="x.y.z.PhoneNumber"/>
</list>
-------------------
<many-to-one name="entity" column="entity_id" class="x.y.z.Entity"/>
-------------------------------------

I delete a given item from the entity's collection and then do a saveOrUpdate(entity);

"delete-orphan" does the same...The problem persists

Thanks again..