java综合（五）spring与hibernate整合－事务

前面一节spring与hibernate整合中，事务配置并不完整，运行起来后虽然能在表中加入数据，但其实并拦截到事务

System.out.println(session.getTransaction().isActive());

	public void save(User user){
		System.out.println("执行UserDao save方法:");
		//getCurrentSession方法与openSession方法区别
		Session session = sessionFactory.getOppenSession();
		//打印事务是否存在
		System.out.println(session.getTransaction().isActive());
		session.save(user);
		session.close();
		System.out.println("执行UserDao save方法完成");
	}

打印事务是否被激活：false

１.Service层配置修改

原版配置

<bean id="userService" class="com.skymr.sphi.service.impl.UserServiceBean"/>

这样拿到的userService不具备事务功能

需要再进行配置：

	<bean id="userDao" class="com.skymr.sphi.dao.impl.UserDaoBean"/>
	<bean id="userServiceBase" class="com.skymr.sphi.service.impl.UserServiceBean"/>
	<!-- -->
	<bean id="userService" parent="transactionBean">
		<property name="target" ref="userServiceBase"></property>
	</bean> 

transactionBean是spring_annotation-hibernate.xml中配置的抽象类TransactionProxyFactoryBean

这样配置的意思就是userService = userServiceBase继承自transactionBean，让UserServiceBean的实例具有事务功能

修改后加入一个包：aopalliance-1.0.jar，再行测试：还是没有事务加入

２.再将session = sessionFactory.openSession改为 session = sessionFactory.getCurrentSession();

这时候抛出一个异常：

save is not valid without active transaction

上网查找问题：

需要去掉这行：<prop key="hibernate.current_session_context_class">thread</prop> 

测试成功

表明openSession取得的session并没有被事务拦截．

３.主键生成策略改为TABLE方式，抛出异常：

    @GeneratedValue(strategy=GenerationType.TABLE, generator="seq")   
    @TableGenerator(name="seq",table="seq_table1",pkColumnName="SEG_NAME",valueColumnName="id",allocationSize = 1,initialValue=10)

org.springframework.transaction.TransactionSystemException: Could not commit Hibernate transaction; nested exception is org.hibernate.TransactionException: commit failed
	at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:556)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy13.save(Unknown Source)
	at com.skymr.sphi.test.TestMain.saveUserTest(TestMain.java:22)
	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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
	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: org.hibernate.TransactionException: commit failed
	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:185)
	at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:552)
	... 32 more
Caused by: org.hibernate.TransactionException: unable to commit against JDBC connection
	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:116)
	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:178)
	... 33 more
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
	at com.mysql.jdbc.Connection.getMutex(Connection.java:3755)
	at com.mysql.jdbc.Connection.commit(Connection.java:2269)
	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:112)
	... 34 more

又查问题，是因为使用sessionFactory.getCurrentSession()取得session后，把session给关闭了，

修改：

	public void save(User user){
		System.out.println("执行UserDao save方法:");
		//getCurrentSession方法与openSession方法区别
		Session session = sessionFactory.getCurrentSession();
		//打印事务是否存在
		System.out.println(session.getTransaction().isActive());
		session.save(user);
		System.out.println("执行UserDao save方法完成");
	}

终于成功了，没有问题．