Hi all,

Sorry for newbie question but I have a problem with cascade delete.
See my mapping.
There is "one to one" relation between CartItem and CartConten, but it seems that cascade delete does not work. It complains that CartContent still references from CartItem.

Thanks in advance for help.

<class name="CartItem">
<id name="id" type="long">
<generator class="native"/>
</id>
<many-to-one name="cart" class="Cart" column="cartId" not-null="true" cascade="all, delete"/>

<many-to-one name="content" class="CartContent" cascade="all,delete">
<column name="contentid" not-null="true"
unique="true"></column>
</many-to-one>
</class>

<class name="CartContent" table="CartContent">
<id name="id">
<generator class="native"/>
</id>
</class>

Where's the one-to-one?

Post your Java code.

one-to-one is the following regarding Hibernate manual (http://www.hibernate.org/hib_docs/v3/re ... tional-121)

<many-to-one name="content" class="CartContent" cascade="all,delete">
<column name="contentid" not-null="true"
unique="true"></column>
</many-to-one>


public class CartItem {
private CartContent content;
private Long id;
private Cart cart;
}

public interface CartContent {

public Long getId();

public void setId(Long id);
}

When I told you to post the Java code, I wanted to mean the Java code that throws the exception or that doesn't work properly.

cascade="delete-orphan"


try this :)

actually it is code from the TestCase using DBUnit, it fails after colling Transaction.commit() in tearDown()

Cart cartToBeDeleted = cartDao.findById(dbCart.getId());

cartDao.delete(cartToBeDeleted);

Session session = sessionFactory.getCurrentSession();
assertNull(session.get(Cart.class, dbCart.getId()));

actually it is code from the TestCase using DBUnit, it fails after colling Transaction.commit() in tearDown()

Cart cartToBeDeleted = cartDao.findById(dbCart.getId());

cartDao.delete(cartToBeDeleted);

Session session = sessionFactory.getCurrentSession();
assertNull(session.get(Cart.class, dbCart.getId()));


4-Jun-2007 23:16:00 org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: ERROR: update or delete on table "cartcontent" violates foreign key constraint "fk4393e735379077a" on table "cartitem"
Detail: Key (id)=(3002) is still referenced from table "cartitem".

Unfortunatelly, it is not supported for "one to one"
I"ve tried it anyway

What sort of object are you deleting (cartToBeDeleted)?
A Cart, a CartContent, a CartItem????

You talked about a
but in your Java code you are deleting a Cart object.

Can you explain that a bit?