我想利用Hibernate的级联关系 在主表 大类 内删除数据的同时子表 次类表和物品表(物品表的子表为品牌表)的整条数据也删除出关系映射的配置
 大类表:
<set name="smallCategories" cascade="all" lazy="false" inverse="true">
<key>
<column name="bigCateId" />
</key>
<one-to-many
class="maillShoppingStart.entity.SmallCategory" /> </set>子类
次类表
<many-to-one name="bigCategory"
class="maillShoppingStart.entity.BigCategory" 
lazy="false" cascade="all">
<column name="bigCateId" />
</many-to-one> <set name="goodses" cascade="all" lazy="false" >
<key>
<column name="cateSid" />
</key>
<one-to-many class="maillShoppingStart.entity.Goods" />
</set>物品
<many-to-one name="smallCategory"
class="maillShoppingStart.entity.SmallCategory" cascade="all">
<column name="cateSid" />
</many-to-one>
<many-to-one name="bigCategory"
class="maillShoppingStart.entity.BigCategory">
<column name="cateBid"></column>
</many-to-one>
<many-to-one name="brand"
class="maillShoppingStart.entity.Brand" cascade="all" lazy="false">
<column name="brandId" />
</many-to-one>报错:org.springframework.dao.DataIntegrityViolationException: could not delete: [maillShoppingStart.entity.BigCategory#10]; nested exception is org.hibernate.exception.ConstraintViolationException: could not delete: [maillShoppingStart.entity.BigCategory#10]
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:621)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)
org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:784)
org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:780)
maillShoppingStart.dao.impl.BigCategoryDaoImpl.delete(BigCategoryDaoImpl.java:57)
maillShoppingStart.biz.impl.BigCategoryBizImpl.delete(BigCategoryBizImpl.java:18)
maillShoppingStart.web.BigCategoryAction.baseDelete(BigCategoryAction.java:57)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)