Hi,

I have a one-to-many relationship beteween Team and Player where cascade=none



In the following code, I loaded a Team from database and deleted it.



But Hibernate set "null" in the "team_id" column in the Player table.
But why this code doesn't throw an exception ? like this:

"ORA-02292: integrity constraint (SCOTT.FKE294C1B2AA36363D) violated - child".

You can't remove a parent that contains children.

cascade is set to "none", so why is this happening?

Hibernate: select teamvo0_.team_id as team_id, teamvo0_.team_name as team_name, teamvo0_.city as city from teams teamvo0_ where teamvo0_.team_id=?
Hibernate: update players set team_id=null where team_id=?
Hibernate: delete from teams where team_id=?

thanks very much!

I suppose cascade attribute is not for specifying referential integrity rules. It is only to tell Hibernate which children objects must be persisted when you persist parent object.

Why don't you want to set RI constraints within DB?

ok, but if i execute a query with JDBC an Exception is threw:

for example:

Statement stmt = connection.createStatement();
stmt.execute("delete from parent.....");

"ORA-02292: integrity constraint (SCOTT.FKE294C1B2AA36363D) violated - child".

then, the hibernate should do the samething :-)

I suppose this is because of inverse="false"

Your parent_id column of child hasn't a not null constraint, so Hibernate set it to null and after that delete parent.
Hibernate does that because parent is responsible of the association (inverse=false)

In your plain SQL, you delete parent wo deferencing childs.

thank you guys !

it worked :-)