前面一节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
1.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,再行测试:还是没有事务加入
2.再将session = sessionFactory.openSession改为 session = sessionFactory.getCurrentSession();
这时候抛出一个异常:
save is not valid without active transaction
上网查找问题:
需要去掉这行:<prop key="hibernate.current_session_context_class">thread</prop>
测试成功
表明openSession取得的session并没有被事务拦截.
3.主键生成策略改为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方法完成");
}
终于成功了,没有问题.