hibernate一对多删除问题

Hibernate: select emsdepartm0_.department_id as department1_0_0_, emsdepartm0_.department_code as department2_0_0_, emsdepartm0_.department_name as department3_0_0_, emsdepartm0_.department_remark as department4_0_0_ from ems_department emsdepartm0_ where emsdepartm0_.department_id=?
Hibernate: delete from ems_department where department_id=?
21:02:05,859  WARN JDBCExceptionReporter:71 - SQL Error: 1451, SQLState: 23000
21:02:05,875 ERROR JDBCExceptionReporter:72 - Cannot delete or update a parent row: a foreign key constraint fails (`ems/ems_user`, CONSTRAINT `FK4B8CE2BF6DE6CB4B` FOREIGN KEY (`department_id`) REFERENCES `ems_department` (`department_id`))
21:02:05,875 ERROR AbstractFlushingEventListener:301 - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
 at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
 at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:558)
 at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:540)
 at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:510)
 at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:310)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
 at $Proxy9.delete(Unknown Source)
 at cn.com.kingkit.ems.service.DepartmentServiceTest.testDepartmentAndUser_delete(DepartmentServiceTest.java:41)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at junit.framework.TestCase.runTest(TestCase.java:154)
 at junit.framework.TestCase.runBare(TestCase.java:127)
 at junit.framework.TestResult$1.protect(TestResult.java:106)
 at junit.framework.TestResult.runProtected(TestResult.java:124)
 at junit.framework.TestResult.run(TestResult.java:109)
 at junit.framework.TestCase.run(TestCase.java:118)
 at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
 at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`ems/ems_user`, CONSTRAINT `FK4B8CE2BF6DE6CB4B` FOREIGN KEY (`department_id`) REFERENCES `ems_department` (`department_id`))
 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
 ... 32 more

 

 

 

EmsDepartment---->EmsUser : one-to-many.

hbm文件如下:

 

EmsDepartment.hbm.xml:

 

 <set name="emsUsers" inverse="true" cascade="delete">
            <key>
                <column name="department_id" />
            </key>
            <one-to-many class="cn.com.kingkit.ems.userManage.model.EmsUser" />
 </set>

 

EmsUser.hbm.xml:

 

 <many-to-one name="emsDepartment" class="cn.com.kingkit.ems.departmentManage.model.EmsDepartment"

             fetch="select" lazy="false" cascade="save-update">
            <column name="department_id"/>
</many-to-one>

 

测试代码如下:

BeanFactory factory = null;
	IDepartmentService service = null;	
	protected void setUp() throws Exception {
		//加载资源
		this.factory = new ClassPathXmlApplicationContext(new String[] {
				"applicationContext-actions.xml",
				"applicationContext-beans.xml",
				"applicationContext-common.xml"});
		this.service = (IDepartmentService)this.factory.getBean("departmentService");
	}
	
	
	public void testDepartmentAndUser_delete(){
		EmsDepartment department = new EmsDepartment();
		department.setDepartmentId("402881e61f50c42c011f50c435030001");		
		this.service.delete(department);
	}

 

搞了半天,原来问题出现在

EmsDepartment department = new EmsDepartment();

department.setDepartmentId("402881e61f50c42c011f50c435030001");
this.service.delete(department);
因为department 为new的实例,在hibernate对象的三种状态中属于瞬时态(Transient),这样级联删除是不行的.

知道了原因,改回来了就成了:

  EmsDepartment department = new EmsDepartment();
  department.setDepartmentId("402881e61f4fff76011f4fff7f680001");
  EmsDepartment d = (EmsDepartment)this.service.findById(department);
  this.service.delete(d);