@transactional annotation

DefaultTransactionDefinition def = new DefaultTransactionDefinition();
def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);

// transaction 상태 정보 알려줌 
TransactionStatus status = txManager.getTransaction(def);

// 에러 없으면 commit

   txManager.commit(status);
        } catch (TransactionException ex) {

// 에러 있을 경우 rollback
            txManager.rollback(status);
            LOGGER.error("insertBoard");

public void insertBoard(BoardVO param, List<FileVO> filelist, String[] fileno) {
       
        DefaultTransactionDefinition def = new DefaultTransactionDefinition();
        def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
        TransactionStatus status = txManager.getTransaction(def);
        try {
            if (param.getBrdno() == null || "".equals(param.getBrdno())) {
                sqlSessionTemplate.insert("insertBoard", param);
            } else {
                sqlSessionTemplate.update("updateBoard", param);
            }
            if (fileno != null) {
                HashMap<String, String[]> fparam = new HashMap<String, String[]>();
                fparam.put("fileno", fileno);
                sqlSessionTemplate.insert("deleteBoardFile", fparam);
            }
            for (FileVO f : filelist) {
                f.setParentPK(param.getBrdno());
                sqlSessionTemplate.insert("insertBoardFile", f);
            }
            txManager.commit(status);
        } catch (TransactionException ex) {
            txManager.rollback(status);
            LOGGER.error("insertBoard");
        }
    }

Transactional annotation 사용법

추가 공부

1. Isolation

 

2. Propagation

https://velog.io/@kdhyo/JavaTransactional-Annotation-%EC%95%8C%EA%B3%A0-%EC%93%B0%EC%9E%90-26her30h

[Java]@Transactional Annotation 알고 쓰자

https://data-make.tistory.com/738

[Spring] @Transactional 잘 사용해보기