博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
java综合(五)spring与hibernate整合-事务
阅读量:3530 次
发布时间:2019-05-20

本文共 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/

你可能感兴趣的文章
零基础R语言快速安装使用
查看>>
大数据技术原理与应用第6讲:云数据库
查看>>
机试题:后缀子串排序
查看>>
大数据技术原理与应用第7讲:MapReduce
查看>>
机试题:并查集——欧拉回路
查看>>
机试题:畅通工程与继续畅通工程(加造价)
查看>>
大数据技术原理与应用第8讲:数据仓库Hive
查看>>
大数据技术原理与应用第8讲:Hadoop再探讨
查看>>
PHP学习记录——CI框架
查看>>
大数据技术原理与应用第10讲:Spark
查看>>
大数据技术原理与应用第11讲:流计算
查看>>
机试题:畅通工程(无造价)
查看>>
大数据技术原理与应用:第12讲 图计算
查看>>
NameError: name 'cross_validation' is not defined
查看>>
机试题:xxx定律
查看>>
怎么做数据的EDA分析?
查看>>
python EDA数据分析例子(二分类问题,源代码)
查看>>
X_train,X_test,y_train,y_test有什么区别?
查看>>
clf.predict_proba(X_train)[:, 1]是什么意思?
查看>>
Ubuntu 下 JDK 的安装(亲测有效)
查看>>