/*
* Copyright 2008-2009 the original author or authors.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package net.test.hasor.db._06_transaction;
import net.hasor.data.Transactional;
import net.hasor.data.transaction.Propagation;
import net.hasor.data.transaction.TransactionCallbackWithoutResult;
import net.hasor.data.transaction.TransactionStatus;
import net.hasor.data.transaction.TransactionTemplate;
import net.hasor.plugins.junit.ContextConfiguration;
import net.hasor.plugins.junit.HasorUnitRunner;
import net.test.hasor.db._02_datasource.warp.SingleDataSourceWarp;
import org.junit.Test;
import org.junit.runner.RunWith;
/**
* NESTED:在当前事务中通过Savepoint方式开启一个子事务。
* @version : 2015年11月17日
* @author 赵永春(zyc@hasor.net)
*/
@RunWith(HasorUnitRunner.class)
@ContextConfiguration(value = "jdbc-config.xml", loadModules = SingleDataSourceWarp.class)
public class NESTED_TranTest extends AbstractNativesJDBCTest {
@Test
public void testHasTransactional() throws Throwable {
System.out.println("--->>NESTED -> 前提:T1处于一个事务中,T2开启一个子事务。");
System.out.println("--->>NESTED -> 执行:T2在执行完毕之后,通知监控线程打印数据库记录。结果无任何输出。");
System.out.println("--->>NESTED -> 结论:因为T1、T2位于一个Connection,虽然T2递交了事务,但是主事务T1还未递交因此监控线程无法看到递交的数据。");
System.out.println("--->>NESTED -> 在T2执行完毕之后,由T1发起一次数据查询操作,得到了已经插入的三条数据。");
System.out.println("--->>NESTED -> 结果:T1在递交之前的数据查询有4条记录,此时监控数据查询结果为 0 条。");
System.out.println();
//
TransactionTemplate temp = appContext.getInstance(TransactionTemplate.class);
temp.execute(new TransactionCallbackWithoutResult() {
public void doTransactionWithoutResult(TransactionStatus tranStatus) throws Throwable {
System.out.println("begin T1!");
/*T1 - 默罕默德*/
insertUser_MHMD();
/*T2 - 安妮.贝隆、吴广*/
doTransactional();
/*T1 - 赵飞燕*/
insertUser_ZFY();
//
Thread.sleep(1000);
System.out.println();
System.out.println();
System.out.print("触发一次监控线程的查询.");
printData();
System.out.println("commit T1!");
}
});
//
Thread.sleep(1000);
printData();
}
@Test
public void testNoneTransactional() throws Throwable {
System.out.println("--->>NESTED -> 前提:T1不再事务中,T2开启一个子事务。");
System.out.println("--->>NESTED -> 执行:T2在最后抛出了一个异常,导致T2事务回滚。而T1不受影响。");
System.out.println("--->>NESTED -> 结论:因为T1是非事物方式、T2引发的异常只会回滚T2事务。");
System.out.println("--->>NESTED -> 结果:数据库应存在:“默罕默德”、“赵飞燕”");
System.out.println("--->>NESTED -> - 共计 2 条记录。");
System.out.println();
//
System.out.println("begin T1!");
/*T1 - 默罕默德*/
insertUser_MHMD();
/*T2 - 安妮.贝隆、吴广*/
try {
doTransactionalError();
} catch (Exception e) {
System.out.println(e.getMessage());
}
/*T1 - 赵飞燕*/
insertUser_ZFY();
System.out.println("commit T1!");
//
Thread.sleep(1000);
printData();
}
//
//
//
//
@Transactional(propagation = Propagation.NESTED)
public void doTransactional() throws Throwable {
System.out.println("begin T2!");
/*安妮.贝隆*/
insertUser_ANBL();
/*吴广*/
insertUser_WG();
//
System.out.println("commit T2!");
}
@Transactional(propagation = Propagation.NESTED)
public void doTransactionalError() throws Throwable {
System.out.println("begin T2!");
/*安妮.贝隆*/
insertUser_ANBL();
/*吴广*/
insertUser_WG();
//
throw new Exception("rollback T2");
}
}