Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Hibernate doesn't generate cascade

I have a set hibernate.hbm2ddl.auto to create so that Hibernate creates the tables in mysql for me.

However, it doesn't seem that hibernate correctly adds Cascade on the references in the table. It does however work when I for instance delete a row, and I have a delete cascade as hibernate annotation. So I guess that means that Hibernate reads the annoation on runtime, and perform cascading manually?

Is that normal behavior?

For instance:

@Entity
class Report {
    @OneToOne(cascade = CascadeType.ALL)
    public File getPdf() {
    return pdf;
}
}

Here I have set cascade to ALL. However, when running show create table Report

Report | CREATE TABLE `Report` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `pdf_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK91B14154FDE6543A` (`pdf_id`),
  CONSTRAINT `FK91B14154FDE6543A` FOREIGN KEY (`pdf_id`) REFERENCES `File` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

It doesn't say anything about cascading other then the foreign key. In my opinion, it should have added the ON DELETE CASCADE ON DELETE UPDATE

like image 548
Shervin Asgari Avatar asked May 18 '10 10:05

Shervin Asgari


1 Answers

The CascadeType and @Cascade definitions are not translated into DDL, they tell Hibernate how to behave when an operation is performed.

However, there is @OnDelete that you can use on the parent to get the foreign key created with the appropriate on delete cascade clause.

like image 97
Pascal Thivent Avatar answered Sep 23 '22 13:09

Pascal Thivent