hibernate 自连接级联操作出错

0 0

hibernate 自连接级联操作出错5

问题：删除上级时候不会同时删除下级。
实体类
public class Department implements Serializable {
//部门ID
private Long departmentId;
//部门名称
private String name;
//父部门
private Department parent;

//部门描述
private String description;

//子部门
private Set<Department> childs = new HashSet<Department>();

get,set方法都已经设置，没贴上来，太占地方
}

hbm文件
<class name="Department" table="tab_department">
<id name="departmentId" type="java.lang.Long">
<column name="departmentId" precision="10" scale="2" />
<generator class="increment" />
</id>
<property name="name" type="java.lang.String">
<column name="name" length="20" />
</property>
<property name="description" type="java.lang.String">
<column name="description" length="255" />
</property>


<many-to-one name="parent" class="Department" column="parentId" lazy="false"/>


<set name="childs" cascade="all" lazy="false" inverse="true">
<key column="parentId"/>
<one-to-many class="Department"/>
</set>

</class>

出错信息

com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`bysj/tab_department`, CONSTRAINT `FK1D92BA3C4CF7CB6A` FOREIGN KEY (`parentId`) REFERENCES `tab_department` (`departmentId`))
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at $Proxy26.executeUpdate(Unknown Source)