Spring 事务传播特性

悠悠 2022-04-18 02:25 197阅读 0赞

事务方法相互调用时，事务是如何传播的，由传播特性指定。相互调用，如 Aservice.methodA()调用了Bservice.methodB()方法，会遵循传播特性。如果是Aservice.methodA1() 调用了同一个类的methodA2()方法，这种不遵守传播特性，只是当作普通方法调用。

package cn.tnt.aop.service;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    
    import cn.tnt.aop.mapper.MsgDao;
    
    @Service
    public class AServiceImpl implements AService{
    	@Autowired
    	private MsgDao msgDao;
    	@Autowired
    	private BService bService;
    	
    	@Transactional
    	@Override
    	public String a1() {
    		System.out.println("================= in one");
    		List query = msgDao.query();
    		System.out.println("================= out one");
    		System.out.println("================= in two");
    //		String b1 = bService.b1();
    		String b1=a2();
    		System.out.println("================= out two");
    		return query+"-------"+b1;
    	}
    	
    	@Transactional(propagation=Propagation.NEVER)
    	@Override
    	public String a2() {
    		System.out.println(1/0);
    		return msgDao.query().toString();
    	}
    
    }

**这种同一个类里的2个方法调用情况 a2() 方法只是当作普通方法调用，他上面的注解 @Transactional(propagation=Propagation.NEVER) 没有任何意义。**

package cn.tnt.aop.service;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    
    import cn.tnt.aop.mapper.MsgDao;
    
    @Service
    public class AServiceImpl implements AService{
    	@Autowired
    	private MsgDao msgDao;
    	@Autowired
    	private BService bService;
    	
    	@Transactional
    	@Override
    	public String a1() {
    		System.out.println("================= in one");
    		List query = msgDao.query();
    		System.out.println("================= out one");
    		System.out.println("================= in two");
    		String b1 = bService.b1();
    //		String b1=a2();
    		System.out.println("================= out two");
    		return query+"-------"+b1;
    	}
    	
    	@Transactional(propagation=Propagation.NEVER)
    	@Override
    	public String a2() {
    		System.out.println(1/0);
    		return msgDao.query().toString();
    	}
    
    }

Aservice.a1()调用Bservice.b1()这种情况遵循定义的传播行为，他们是不同的service。接下来使用这两篇代码分析看一下7种传播行为。

（1）REQUIRED：如果当前存在事务，加入当前事务，如果不存在开启一个新事务运行。

@Transactional(propagation=Propagation.REQUIRED)  
    @Override  
    public String b1() \{  
        List query1 = msgDao.query1();  
        return query1.toString();  
    \}

日志：

2018-11-07 14:42:08 DEBUG [org.springframework.web.servlet.DispatcherServlet] DispatcherServlet with name 'springServlet' processing POST request for [/tnt-service/test/q1]
    2018-11-07 14:42:08 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Looking up handler method for path /test/q1
    2018-11-07 14:42:08 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Returning handler method [public java.lang.String cn.tnt.aop.controller.TestController.query1()]
    2018-11-07 14:42:08 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'testController'
    2018-11-07 14:42:08 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'transactionManager'
    2018-11-07 14:42:08 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Creating new transaction with name [cn.tnt.aop.service.AServiceImpl.a1]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''
    Wed Nov 07 14:42:08 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    2018-11-07 14:42:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Acquired Connection [com.mysql.jdbc.JDBC4Connection@34b2cf16] for JDBC transaction
    2018-11-07 14:42:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Switching JDBC Connection [com.mysql.jdbc.JDBC4Connection@34b2cf16] to manual commit
    ================= in one
    ================= out one
    ================= in two
    2018-11-07 14:42:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Participating in existing transaction
    ================= out two
    2018-11-07 14:42:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Initiating transaction commit
    2018-11-07 14:42:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Committing JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@34b2cf16]
    2018-11-07 14:42:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@34b2cf16] after transaction
    2018-11-07 14:42:09 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Returning JDBC Connection to DataSource
    2018-11-07 14:42:09 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] Invoking ResponseBodyAdvice chain for body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 14:42:09 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] After ResponseBodyAdvice chain body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 14:42:09 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor] Written [{msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}] as "text/plain;charset=ISO-8859-1" using [org.springframework.http.converter.StringHttpMessageConverter@66224026]
    2018-11-07 14:42:09 DEBUG [org.springframework.web.servlet.DispatcherServlet] Null ModelAndView returned to DispatcherServlet with name 'springServlet': assuming HandlerAdapter completed request handling
    2018-11-07 14:42:09 DEBUG [org.springframework.web.servlet.DispatcherServlet] Successfully completed request
    2018-11-07 14:42:09 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'sqlSessionFactory'

Participating in existing transaction 加入当前存在的事务。a1()方法执行时候，创建事务，a1()调用b1()方法，b1 设置的REQUIRED，发现当前存在事务就加入到当前事务。如果a1()没有配置事务，则执行b1()方法时候会创建事务，b1()运行完提交或者回滚事务，仅仅b1()方法在事务范围内。

（2）SUPPORTS：如果当前存在事务，加入当前事务，不存在，以非事务方式运行。

@Transactional(propagation=Propagation.SUPPORTS)  
    @Override  
    public String b1() \{  
        List query1 = msgDao.query1();  
        return query1.toString();  
    \}

日志:

2018-11-07 14:55:28 DEBUG [org.springframework.web.servlet.DispatcherServlet] DispatcherServlet with name 'springServlet' processing POST request for [/tnt-service/test/q1]
    2018-11-07 14:55:28 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Looking up handler method for path /test/q1
    2018-11-07 14:55:28 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Returning handler method [public java.lang.String cn.tnt.aop.controller.TestController.query1()]
    2018-11-07 14:55:28 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'testController'
    2018-11-07 14:55:28 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'transactionManager'
    2018-11-07 14:55:28 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Creating new transaction with name [cn.tnt.aop.service.AServiceImpl.a1]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''
    Wed Nov 07 14:55:28 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    2018-11-07 14:55:29 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Acquired Connection [com.mysql.jdbc.JDBC4Connection@6756bd9e] for JDBC transaction
    2018-11-07 14:55:29 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Switching JDBC Connection [com.mysql.jdbc.JDBC4Connection@6756bd9e] to manual commit
    ================= in one
    ================= out one
    ================= in two
    2018-11-07 14:55:29 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Participating in existing transaction
    ================= out two
    2018-11-07 14:55:29 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Initiating transaction commit
    2018-11-07 14:55:29 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Committing JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@6756bd9e]
    2018-11-07 14:55:29 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@6756bd9e] after transaction
    2018-11-07 14:55:29 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Returning JDBC Connection to DataSource
    2018-11-07 14:55:29 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] Invoking ResponseBodyAdvice chain for body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 14:55:29 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] After ResponseBodyAdvice chain body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 14:55:29 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor] Written [{msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}] as "text/plain;charset=ISO-8859-1" using [org.springframework.http.converter.StringHttpMessageConverter@7a718ec4]
    2018-11-07 14:55:29 DEBUG [org.springframework.web.servlet.DispatcherServlet] Null ModelAndView returned to DispatcherServlet with name 'springServlet': assuming HandlerAdapter completed request handling
    2018-11-07 14:55:29 DEBUG [org.springframework.web.servlet.DispatcherServlet] Successfully completed request
    2018-11-07 14:55:29 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'sqlSessionFactory'

Participating in existing transaction 加入当前事务，如果a1()没有添加事务注解，则调用b1()方法时候，b1()会以非事务方式运行。

（3）MANDATORY:如果当前存在事务，加入当前事务，不存在就抛出异常。

@Transactional(propagation=Propagation.MANDATORY)  
    @Override  
    public String b1() \{  
        List query1 = msgDao.query1();  
        return query1.toString();  
    \}

日志：

2018-11-07 14:59:47 DEBUG [org.springframework.web.servlet.DispatcherServlet] DispatcherServlet with name 'springServlet' processing POST request for [/tnt-service/test/q1]
    2018-11-07 14:59:47 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Looking up handler method for path /test/q1
    2018-11-07 14:59:47 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Returning handler method [public java.lang.String cn.tnt.aop.controller.TestController.query1()]
    2018-11-07 14:59:47 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'testController'
    2018-11-07 14:59:47 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'transactionManager'
    2018-11-07 14:59:47 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Creating new transaction with name [cn.tnt.aop.service.AServiceImpl.a1]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''
    Wed Nov 07 14:59:47 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    2018-11-07 14:59:47 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Acquired Connection [com.mysql.jdbc.JDBC4Connection@5962dbb] for JDBC transaction
    2018-11-07 14:59:47 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Switching JDBC Connection [com.mysql.jdbc.JDBC4Connection@5962dbb] to manual commit
    ================= in one
    ================= out one
    ================= in two
    2018-11-07 14:59:47 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Participating in existing transaction
    ================= out two
    2018-11-07 14:59:47 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Initiating transaction commit
    2018-11-07 14:59:47 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Committing JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@5962dbb]
    2018-11-07 14:59:47 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@5962dbb] after transaction
    2018-11-07 14:59:47 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Returning JDBC Connection to DataSource
    2018-11-07 14:59:47 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] Invoking ResponseBodyAdvice chain for body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 14:59:47 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] After ResponseBodyAdvice chain body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 14:59:47 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor] Written [{msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}] as "text/plain;charset=ISO-8859-1" using [org.springframework.http.converter.StringHttpMessageConverter@4c5022c0]
    2018-11-07 14:59:47 DEBUG [org.springframework.web.servlet.DispatcherServlet] Null ModelAndView returned to DispatcherServlet with name 'springServlet': assuming HandlerAdapter completed request handling
    2018-11-07 14:59:47 DEBUG [org.springframework.web.servlet.DispatcherServlet] Successfully completed request
    2018-11-07 14:59:47 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'sqlSessionFactory'

Participating in existing transaction 加入当前存在的事务。如果把a1(）方法不添加事务注解，则在调用b1()方法时候抛出IllegalTransactionStateException异常。

（4）REQUIRES\_NEW：如果当前存在事务，挂起当前事务，并开启一个新的事务运行，不存在直接开启新的事务运行。

@Transactional(propagation=Propagation.REQUIRES\_NEW)  
    @Override  
    public String b1() \{  
        List query1 = msgDao.query1();  
        return query1.toString();  
    \}

日志：

2018-11-07 15:03:17 DEBUG [org.springframework.web.servlet.DispatcherServlet] DispatcherServlet with name 'springServlet' processing POST request for [/tnt-service/test/q1]
    2018-11-07 15:03:17 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Looking up handler method for path /test/q1
    2018-11-07 15:03:17 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Returning handler method [public java.lang.String cn.tnt.aop.controller.TestController.query1()]
    2018-11-07 15:03:17 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'testController'
    2018-11-07 15:03:17 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'transactionManager'
    2018-11-07 15:03:17 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Creating new transaction with name [cn.tnt.aop.service.AServiceImpl.a1]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''
    Wed Nov 07 15:03:17 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    2018-11-07 15:03:18 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Acquired Connection [com.mysql.jdbc.JDBC4Connection@284dcc3f] for JDBC transaction
    2018-11-07 15:03:18 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Switching JDBC Connection [com.mysql.jdbc.JDBC4Connection@284dcc3f] to manual commit
    ================= in one
    ================= out one
    ================= in two
    2018-11-07 15:03:18 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Suspending current transaction, creating new transaction with name [cn.tnt.aop.service.BServiceImpl.b1]
    Wed Nov 07 15:03:18 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Acquired Connection [com.mysql.jdbc.JDBC4Connection@798e4412] for JDBC transaction
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Switching JDBC Connection [com.mysql.jdbc.JDBC4Connection@798e4412] to manual commit
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Initiating transaction commit
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Committing JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@798e4412]
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@798e4412] after transaction
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Returning JDBC Connection to DataSource
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Resuming suspended transaction after completion of inner transaction
    ================= out two
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Initiating transaction commit
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Committing JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@284dcc3f]
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@284dcc3f] after transaction
    2018-11-07 15:03:19 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Returning JDBC Connection to DataSource
    2018-11-07 15:03:19 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] Invoking ResponseBodyAdvice chain for body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 15:03:19 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] After ResponseBodyAdvice chain body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 15:03:19 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor] Written [{msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}] as "text/plain;charset=ISO-8859-1" using [org.springframework.http.converter.StringHttpMessageConverter@7092c71b]
    2018-11-07 15:03:19 DEBUG [org.springframework.web.servlet.DispatcherServlet] Null ModelAndView returned to DispatcherServlet with name 'springServlet': assuming HandlerAdapter completed request handling
    2018-11-07 15:03:19 DEBUG [org.springframework.web.servlet.DispatcherServlet] Successfully completed request
    2018-11-07 15:03:19 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'sqlSessionFactory'

Suspending current transaction, creating new transaction with name \[cn.tnt.aop.service.BServiceImpl.b1\] 挂起当前事务，创建新的事务。运行a1()方法时候启动一个事务，调用b1()方法时候挂起当前存在的事务，并开启一个新的事务，b1方法的事务提交后，恢复挂起的事务，最后提交第一个事务。这里是运行了2个事务,彼此独立 **但是：如果b1()抛出了异常并且a1()没有捕获那么b1()事务 a1()事务都会回滚，如果a1()捕获消耗了异常则b1回滚a1提交；如果调用b1()没抛异常，a1()在之后的代码出了异常，则b1事务提交，a1事务回滚**。如果a1()没有添加事务注解，则a1()方法不参与事务，b1()方法会在一个事务中运行。

（5）NOT\_SUPPORTED：如果当前存在事务，把当前存在的事务挂起，以非事务方式运行，不存在事务，直接以非事务方式运行。

@Transactional(propagation=Propagation.NOT\_SUPPORTED)  
    @Override  
    public String b1() \{  
        List query1 = msgDao.query1();  
        return query1.toString();  
    \}

日志：

2018-11-07 15:15:08 DEBUG [org.springframework.web.servlet.DispatcherServlet] DispatcherServlet with name 'springServlet' processing POST request for [/tnt-service/test/q1]
    2018-11-07 15:15:08 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Looking up handler method for path /test/q1
    2018-11-07 15:15:08 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Returning handler method [public java.lang.String cn.tnt.aop.controller.TestController.query1()]
    2018-11-07 15:15:08 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'testController'
    2018-11-07 15:15:08 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'transactionManager'
    2018-11-07 15:15:08 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Creating new transaction with name [cn.tnt.aop.service.AServiceImpl.a1]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''
    Wed Nov 07 15:15:08 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Acquired Connection [com.mysql.jdbc.JDBC4Connection@3c634890] for JDBC transaction
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Switching JDBC Connection [com.mysql.jdbc.JDBC4Connection@3c634890] to manual commit
    ================= in one
    ================= out one
    ================= in two
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Suspending current transaction
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Fetching JDBC Connection from DataSource
    Wed Nov 07 15:15:09 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Registering transaction synchronization for JDBC Connection
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Returning JDBC Connection to DataSource
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Resuming suspended transaction after completion of inner transaction
    ================= out two
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Initiating transaction commit
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Committing JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@3c634890]
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@3c634890] after transaction
    2018-11-07 15:15:09 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Returning JDBC Connection to DataSource
    2018-11-07 15:15:09 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] Invoking ResponseBodyAdvice chain for body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 15:15:09 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] After ResponseBodyAdvice chain body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 15:15:09 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor] Written [{msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}] as "text/plain;charset=ISO-8859-1" using [org.springframework.http.converter.StringHttpMessageConverter@fb24a09]
    2018-11-07 15:15:09 DEBUG [org.springframework.web.servlet.DispatcherServlet] Null ModelAndView returned to DispatcherServlet with name 'springServlet': assuming HandlerAdapter completed request handling
    2018-11-07 15:15:09 DEBUG [org.springframework.web.servlet.DispatcherServlet] Successfully completed request
    2018-11-07 15:15:09 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'sqlSessionFactory'

Suspending current transaction a1()方法创建的事务被挂起，b1(）方法执行完后恢复挂起的事务，提交事务，**如果b1()方法抛出异常并且a1没有捕获消耗，依然会导致a1事务的回滚，如果a1捕获消耗了异常，那么a1会提交事务**。如果a1()方法没有添加事务注解，则以非事务运行。

（6）NEVER:如果当前存在事务，抛出异常，不存在以非事务方式运行。

@Transactional(propagation=Propagation.NEVER)  
    @Override  
    public String b1() \{  
        List query1 = msgDao.query1();  
        return query1.toString();  
    \}

日志：

org.springframework.transaction.IllegalTransactionStateException: Existing transaction found for transaction marked with propagation 'never'
    	at org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:401)
    	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)
    	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:439)
    	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
    	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
    	at cn.tnt.aop.service.BServiceImpl$$EnhancerBySpringCGLIB$$68693313.b1(<generated>)
    	at cn.tnt.aop.service.AServiceImpl.a1(AServiceImpl.java:26)
    	at cn.tnt.aop.service.AServiceImpl$$FastClassBySpringCGLIB$$f3d43350.invoke(<generated>)
    	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:267)
    	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
    	at cn.tnt.aop.service.AServiceImpl$$EnhancerBySpringCGLIB$$9cd8c294.a1(<generated>)
    	at cn.tnt.aop.controller.TestController.query1(TestController.java:52)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:483)
    	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
    	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781)
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721)
    	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
    	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
    	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
    	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
    	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
    	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
    	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    	at java.lang.Thread.run(Thread.java:745)
    2018-11-07 15:20:53 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'sqlSessionFactory'

程序抛出了异常，如果把a1(）方法不添加注解事务，则以非事务方式运行。

（7）NESTED：如果当前存在事务，则嵌套在当前事务中，不存在则以REQUIRE方式运行。

@Transactional(propagation=Propagation.NESTED)  
    @Override  
    public String b1() \{  
        List query1 = msgDao.query1();  
          
        return query1.toString();  
    \}  
日志：

2018-11-07 15:47:20 DEBUG [org.springframework.web.servlet.DispatcherServlet] DispatcherServlet with name 'springServlet' processing POST request for [/tnt-service/test/q1]
    2018-11-07 15:47:20 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Looking up handler method for path /test/q1
    2018-11-07 15:47:20 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping] Returning handler method [public java.lang.String cn.tnt.aop.controller.TestController.query1()]
    2018-11-07 15:47:20 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'testController'
    2018-11-07 15:47:20 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'transactionManager'
    2018-11-07 15:47:20 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Creating new transaction with name [cn.tnt.aop.service.AServiceImpl.a1]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''
    Wed Nov 07 15:47:20 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    2018-11-07 15:47:20 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Acquired Connection [com.mysql.jdbc.JDBC4Connection@16d7c9cd] for JDBC transaction
    2018-11-07 15:47:20 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Switching JDBC Connection [com.mysql.jdbc.JDBC4Connection@16d7c9cd] to manual commit
    ================= in one
    ================= out one
    ================= in two
    2018-11-07 15:47:20 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Creating nested transaction with name [cn.tnt.aop.service.BServiceImpl.b1]
    2018-11-07 15:47:20 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Releasing transaction savepoint
    ================= out two
    2018-11-07 15:47:20 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Initiating transaction commit
    2018-11-07 15:47:20 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Committing JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@16d7c9cd]
    2018-11-07 15:47:21 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager] Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@16d7c9cd] after transaction
    2018-11-07 15:47:21 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] Returning JDBC Connection to DataSource
    2018-11-07 15:47:21 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] Invoking ResponseBodyAdvice chain for body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 15:47:21 DEBUG [org.springframework.web.servlet.mvc.method.annotation.ResponseBodyAdviceChain] After ResponseBodyAdvice chain body={msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}
    2018-11-07 15:47:21 DEBUG [org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor] Written [{msg=[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]-------[{ID=1, NAME=msg}, {ID=11, NAME=aaa}, {ID=12, NAME=aaa}, {ID=22, NAME=}, {ID=23, NAME=}]}] as "text/plain;charset=ISO-8859-1" using [org.springframework.http.converter.StringHttpMessageConverter@57ae6aa3]
    2018-11-07 15:47:21 DEBUG [org.springframework.web.servlet.DispatcherServlet] Null ModelAndView returned to DispatcherServlet with name 'springServlet': assuming HandlerAdapter completed request handling
    2018-11-07 15:47:21 DEBUG [org.springframework.web.servlet.DispatcherServlet] Successfully completed request
    2018-11-07 15:47:21 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Returning cached instance of singleton bean 'sqlSessionFactory'

内部事物的回滚提交不影响外部事物回滚提交，外部事物回滚提交影响内部事物回滚提交。如果b1异常，a1捕获消耗后，b1回滚事物，a1提交事物；如果调用b1后 a1之后的代码异常，b1 a1都回滚事物。

REQUIRES\_NEW和NESTED区别：

REQUIRES\_NEW：是2个独立的事务，彼此不影响。

NESTED：是嵌套的事物，内部事物不影响外部事物，外部事物影响内部事物。