The colume nextMessage is foregin key references id and this has casecade as all.

If i delete one message than all the references should be deleated. But this is not happening.



<many-to-one
name="nextMessage"
cascade="all"
column="NEXT_MESSAGE_ID"
foreign-key="FK_NEXT_MESSAGE"/>

Example
-------------------------
// ############################################################################

// First unit of work
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction tx = session.beginTransaction();

Message parent = new Message("Parent");
parent.setText("I am Parent");
Message child1 = new Message("child1");
child1.setText("I am child1");
Message child2 = new Message("child2");
child2.setText("I am child2");

parent.setNextMessage(child1);
child1.setNextMessage(child2);

session.save(parent);
tx.commit();
session.close();

// Shutting down the application
HibernateUtil.shutdown();
}


-----------------------------------------------------

If I delete the parent. Than all the childs should go. because they have foreign key references

But this is not happening. Any clue?

Thanks in Advance
Balaji

Hi Balaji,

You are defining cascade=all in wrong place.
If you are deleting the record in the main table that is the talbe
where NEXT_MESSAGE is primary key.
There you might have defined one-to-many there you need to specify this attribute then it will work proper i hope.