Dude, I was able to reproduce the correct behaviour here. I tested using MySQL 5 and Hibernate 3.2.6 (which you said is the version you are using).
In the below code, comment the last 4 lines (or change the last commit to a rollback), and look into the database. There should be 1 record for table A, 2 records for table B and 3 records for table C.
If you don't comment it, there should not be any records on any table, except C, which should have 1 record.
This is the relevant java code for my test:
Code:
tx = s.beginTransaction();
C c1 = new C();
c1.setName("c1");
C c2 = new C();
c2.setName("c2");
C c3 = new C();
c3.setName("c3");
B b1 = new B();
b1.setName("b1");
B b2 = new B();
b2.setName("b2");
List<C> cList = new ArrayList<C>();
cList.add(c1);
cList.add(c2);
b2.setC(cList);
A a1 = new A();
a1.setName("a1");
List<B> bList = new ArrayList<B>();
bList.add(b1);
bList.add(b2);
a1.setB(bList);
s.save(a1);
s.save(c3);
tx.commit();
tx = s.beginTransaction();
a1 = (A) s.createQuery("from A where name = 'a1'").list().iterator().next();
s.delete(a1);
tx.commit();
And these are the mappings, each on its own mapping file:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="notcascading">
<class name="A">
<id name="id" column="a_id">
<generator class="native"/>
</id>
<property name="name"/>
<list cascade="all-delete-orphan" fetch="join" lazy="false" name="b">
<key column="a_id"/>
<list-index column="b_idx"/>
<one-to-many class="B"/>
</list>
</class>
</hibernate-mapping>
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="notcascading">
<class name="B">
<id name="id" column="b_id">
<generator class="native"/>
</id>
<property name="name"/>
<list cascade="all-delete-orphan" fetch="join" lazy="false" name="c">
<key column="b_id"/>
<list-index column="c_idx"/>
<one-to-many class="C"/>
</list>
</class>
</hibernate-mapping>
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="notcascading">
<class name="C">
<id name="id" column="c_id">
<generator class="native"/>
</id>
<property name="name"/>
</class>
</hibernate-mapping>
Login
FAQ
Search
