SSH报错org.hibernate.TransactionException: nested transactions not supported

我会带着你远行 2023-10-18 22:12 83阅读 0赞

### org.hibernate.TransactionException: nested transactions not supported ###

错误说明：出现这个错误是因为事务嵌套的问题！！！  
代码如下：

private SessionFactory sessionFactory;
        public void setSessionFactory(SessionFactory sessionFactory) {
    		this.sessionFactory = sessionFactory;
    	}
        
    	@SuppressWarnings("unchecked")
    	@Override
    	public List<TbUsers> Login(String account,String password) {
    		Session session = null;
    		Transaction tran = null;
        	List<TbUsers> list = null;
        	try{
        		
        		if(sessionFactory!=null){
        			System.out.println("拿到session");
        		}
        		
        		/*
        		 * openSession是否开始事务均正常执行
        		 * getCurrentSession只有不开始事务才正常
        		 */
        		//session = sessionFactory.openSession();
        		session = sessionFactory.getCurrentSession();
        		tran = session.beginTransaction();//开始事物  
    	        String hqlString = "from TbUsers users where users.account = ?0 and users.password= ?1";
    	        Query query = session.createQuery(hqlString);
    	        query.setString("0", account);
    	        query.setString("1", password);
    			list = query.list();
    			tran.commit();
    	        return list;
        	}
        	catch(Exception e){
        		e.printStackTrace();  
        	}
        	finally{
        		//openSession时需要手动关闭一下
        		//session.close();
        	}
            return list;  
    	}

具体原因暂时不明，用spring4来管理hibernate4的sessionFactory，applicationContext.xml完整配置如下；此配置下：**如果用getCurrentSession获取session会导致事务嵌套发生，网上绝大多数说必须开启事务不知道怎么 来的 ；而openSession是否开启事务都能执行，但是最后必须手动关闭：session.close();否则会连接占满**

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:util="http://www.springframework.org/schema/util" xmlns:jee="http://www.springframework.org/schema/jee"
    	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jpa="http://www.springframework.org/schema/data/jpa"
    	xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:p="http://www.springframework.org/schema/p"
    	xmlns:aop="http://www.springframework.org/schema/aop"
    	xsi:schemaLocation="
    		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
    		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
    		http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd
    		http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd
    		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
    		http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa.xsd
    		http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
    		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
    
    
    	
    	
    
    	
    	<context:property-placeholder location="classpath:c3p0-db.properties" />
    	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
    		destroy-method="close">
    
    		<property name="driverClass" value="${jdbc.driverClass}" />
    		<property name="jdbcUrl" value="${jdbc.jdbcUrl}" />
    		<property name="user" value="${jdbc.user}" />
    		<property name="password" value="${jdbc.password}" />
    
    		<property name="maxPoolSize" value="4"></property>
    		
    		<property name="minPoolSize" value="2" />
    		
    		<property name="initialPoolSize" value="2" />
    		
    		<property name="maxIdleTime" value="60"></property>
    		
    		<property name="checkoutTimeout" value="3000" />
    		
    		<property name="acquireIncrement" value="2" />
    		
    		<property name="acquireRetryAttempts" value="0" />
    		
    		<property name="acquireRetryDelay" value="1000" />
    		
    		<property name="autoCommitOnClose" value="false"></property>
    		
    		<property name="idleConnectionTestPeriod" value="60"></property>
    		
    		<property name="maxStatements" value="100"></property>
    		
    		<property name="maxStatementsPerConnection" value="0"></property>
    
    
    	</bean>
    
    	
    	<bean id="sessionFactory"
    		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    
    		
    		<property name="dataSource" ref="dataSource"></property>
    		
    		<property name="configLocation" value="classpath:hibernate.cfg.xml"></property>
    	</bean>
    
    	
    	<bean id="transactionManager"
    		class="org.springframework.orm.hibernate4.HibernateTransactionManager">
    		<property name="sessionFactory" ref="sessionFactory"></property>
    	</bean>
    
    	
    	<bean id="logDaoImpl" class="demo.ssh.daoImpl.LogDaoImpl">
    		<property name="sessionFactory" ref="sessionFactory"></property>
    	</bean>
    	<bean id="logServiceImpl" class="demo.ssh.serviceImpl.LogServiceImpl">
    	</bean>
    	<bean id="LogAction" class="demo.ssh.action.LogAction">
    	</bean>
    
    	
    
    	
    	
    	<tx:annotation-driven transaction-manager="transactionManager"/>
    	
    	<tx:advice id="txAdvice" transaction-manager="transactionManager">
    
    		<tx:attributes>
    			<tx:method name="find*" read-only="true" />
    			<tx:method name="get*" read-only="true" />
    			<tx:method name="add*" propagation="REQUIRED" />
    			<tx:method name="update*" propagation="REQUIRED" />
    			<tx:method name="delete*" propagation="REQUIRED" />
    			<tx:method name="save*" propagation="REQUIRED" />
    			<tx:method name="test*" propagation="REQUIRED" />
    			<tx:method name="*Transaction" propagation="REQUIRED" />
    			<tx:method name="*" propagation="REQUIRED" />
    		</tx:attributes>
    	</tx:advice>
    	
    	<aop:config expose-proxy="true">
    		<aop:pointcut expression="execution(* demo.ssh.daoImpl.*.*(..))"
    			id="txPointcut" />
    		
    		<aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut" />
    	</aop:config>
    
    </beans>

hibernate.cfg.xml配置如下：

<?xml version='1.0' encoding='utf-8'?>
    
    <!DOCTYPE hibernate-configuration PUBLIC
            "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
            "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
    <hibernate-configuration>
    <session-factory>
    
    	<property name="hibernate.c3p0.idle_test_period">300</property>
    	<property name="hibernate.c3p0.acquire_increment">4</property>
    	<property name="hibernate.c3p0.validate">true</property> -->		
    			
    	
    	
    	
    	
    	<property name="dialect">org.hibernate.dialect.SQLServer2008Dialect</property>
    	
    	
    	<property name="show_sql">false</property>
    	<property name="format_sql">false</property>
    	
    	<property name="connection.autocommit">true</property>
    	
    	<property name="generate_statistics">false</property>  
    	
    	<property name="autoReconnect">true</property>  
    	<property name="max_fech_depth">5</property>  
    	<property name="jdbc.batch_size">50</property>  
    	<property name="jdbc.fetch_size">100</property>
    	
    	<property name="current_session_context_class">org.springframework.orm.hibernate4.SpringSessionContext</property>
    		                
    	
    	<mapping  resource="demo/ssh/entity/TbUsers.hbm.xml"/>
    	
    			
    </session-factory>
    </hibernate-configuration>