本文共 5700 字,大约阅读时间需要 19 分钟。
前面一节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层配置修改
原版配置
这样拿到的userService不具备事务功能
需要再进行配置:
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 moreCaused 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 moreCaused 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方法完成"); }终于成功了,没有问题.
转载地址:http://wnihj.baihongyu.com/