hibernate/mysql 外键级联删除
我有两张表部门表Department和员工表Employee,一个Department有多个Employee,Employee有指向Department的外键
问题是直接删除Department会报错,因为有外键,于是在数据库里设置外键on delete cascade,但这与实际情况不符,Department没有了,但是Employee还是在的,设定on delete set null,查询的时候又会报错,怎么能在删除时设定Employee的外键为默认值,用Hibernate的话配置该怎么写
用mysql5.5 设置on delete set default 总是报错,不能保存