Java多執行緒事務回滾@Transactional失效處理方案

/**
* 測試多執行緒事務.
* @param employeeDOList
*/
@Override
@Transactional
public void saveThread(List<EmployeeDO> employeeDOList) {
try {
//先做刪除操作,如果子執行緒出現異常,此操作不會回滾
this.getBaseMapper().delete(null);
//獲取執行緒池
ExecutorService service = ExecutorConfig.getThreadPool();
//拆分資料,拆分5份
List<List<EmployeeDO>> lists=averageAssign(employeeDOList, 5);
//執行的執行緒
Thread []threadArray = new Thread[lists.size()];
//監控子執行緒執行完畢,再執行主執行緒,要不然會導致主執行緒關閉,子執行緒也會隨著關閉
CountDownLatch countDownLatch = new CountDownLatch(lists.size());
AtomicBoolean atomicBoolean = new AtomicBoolean(true);
for (int i =0;i<lists.size();i++){
if (i==lists.size()-1){
atomicBoolean.set(false);
}
List<EmployeeDO> list = lists.get(i);
threadArray[i] = new Thread(() -> {
try {
//最後一個執行緒丟擲異常
if (!atomicBoolean.get()){
throw new ServiceException("001","出現異常");
}
//批次新增,mybatisPlus中自帶的batch方法
this.saveBatch(list);
}finally {
countDownLatch.countDown();
}

});
}
for (int i = 0; i <lists.size(); i++){
service.execute(threadArray[i]);
}
//當子執行緒執行完畢時,主執行緒再往下執行
countDownLatch.await();
System.out.println("新增完畢");
}catch (Exception e){
log.info("error",e);
throw new ServiceException("002","出現異常");
}finally {
connection.close();
}
}

//測試用例
@RunWith(SpringRunner.class)
@SpringBootTest(classes = { ThreadTest01.class, MainApplication.class})
public class ThreadTest01 {

@Resource
private EmployeeBO employeeBO;

/**
* 測試多執行緒事務.
* @throws InterruptedException
*/
@Test
public void MoreThreadTest2() throws InterruptedException {
int size = 10;
List<EmployeeDO> employeeDOList = new ArrayList<>(size);
for (int i = 0; i<size;i++){
EmployeeDO employeeDO = new EmployeeDO();
employeeDO.setEmployeeName("lol"+i);
employeeDO.setAge(18);
employeeDO.setGender(1);
employeeDO.setIdNumber(i+"XX");
employeeDO.setCreatTime(Calendar.getInstance().getTime());
employeeDOList.add(employeeDO);
}
try {
employeeBO.saveThread(employeeDOList);
System.out.println("新增成功");
}catch (Exception e){
e.printStackTrace();
}
}
}

@Resource
SqlContext sqlContext;
/**
* 測試多執行緒事務.
* @param employeeDOList
*/
@Override
public void saveThread(List<EmployeeDO> employeeDOList) throws SQLException {
// 獲取資料庫連線,獲取對談(內部自有事務)
SqlSession sqlSession = sqlContext.getSqlSession();
Connection connection = sqlSession.getConnection();
try {
// 設定手動提交
connection.setAutoCommit(false);
//獲取mapper
EmployeeMapper employeeMapper = sqlSession.getMapper(EmployeeMapper.class);
//先做刪除操作
employeeMapper.delete(null);
//獲取執行器
ExecutorService service = ExecutorConfig.getThreadPool();
List<Callable<Integer>> callableList = new ArrayList<>();
//拆分list
List<List<EmployeeDO>> lists=averageAssign(employeeDOList, 5);
AtomicBoolean atomicBoolean = new AtomicBoolean(true);
for (int i =0;i<lists.size();i++){
if (i==lists.size()-1){
atomicBoolean.set(false);
}
List<EmployeeDO> list = lists.get(i);
//使用返回結果的callable去執行,
Callable<Integer> callable = () -> {
//讓最後一個執行緒丟擲異常
if (!atomicBoolean.get()){
throw new ServiceException("001","出現異常");
}
return employeeMapper.saveBatch(list);
};
callableList.add(callable);
}
//執行子執行緒
List<Future<Integer>> futures = service.invokeAll(callableList);
for (Future<Integer> future:futures) {
//如果有一個執行不成功,則全部回滾
if (future.get()<=0){
connection.rollback();
return;
}
}
connection.commit();
System.out.println("新增完畢");
}catch (Exception e){
connection.rollback();
log.info("error",e);
throw new ServiceException("002","出現異常");
}finally {
connection.close();
}
}
// sql
<insert id="saveBatch" parameterType="List">
INSERT INTO
employee (employee_id,age,employee_name,birth_date,gender,id_number,creat_time,update_time,status)
values
<foreach collection="list" item="item" index="index" separator=",">
(
#{item.employeeId},
#{item.age},
#{item.employeeName},
#{item.birthDate},
#{item.gender},
#{item.idNumber},
#{item.creatTime},
#{item.updateTime},
#{item.status}
)
</foreach>
</insert>

@Resource
SqlContext sqlContext;
/**
* 測試多執行緒事務.
* @param employeeDOList
*/
@Override
public void saveThread(List<EmployeeDO> employeeDOList) throws SQLException {
// 獲取資料庫連線,獲取對談(內部自有事務)
SqlSession sqlSession = sqlContext.getSqlSession();
Connection connection = sqlSession.getConnection();
try {
// 設定手動提交
connection.setAutoCommit(false);
EmployeeMapper employeeMapper = sqlSession.getMapper(EmployeeMapper.class);
//先做刪除操作
employeeMapper.delete(null);
ExecutorService service = ExecutorConfig.getThreadPool();
List<Callable<Integer>> callableList = new ArrayList<>();
List<List<EmployeeDO>> lists=averageAssign(employeeDOList, 5);
for (int i =0;i<lists.size();i++){
List<EmployeeDO> list = lists.get(i);
Callable<Integer> callable = () -> employeeMapper.saveBatch(list);
callableList.add(callable);
}
//執行子執行緒
List<Future<Integer>> futures = service.invokeAll(callableList);
for (Future<Integer> future:futures) {
if (future.get()<=0){
connection.rollback();
return;
}
}
connection.commit();
System.out.println("新增完畢");
}catch (Exception e){
connection.rollback();
log.info("error",e);
throw new ServiceException("002","出現異常");
// throw new ServiceException(ExceptionCodeEnum.EMPLOYEE_SAVE_OR_UPDATE_ERROR);
}
}