Cannot change the ExecutorType when there is an existing transaction

https://tomining.tistory.com/178

Transaction 내에서 ExecutorType 변경 불가 오류

 

https://choisblog.tistory.com/81

Spring Batch Error : TransientDataAccessResourceException : Batch Execution Errorsdetails;Cannot change the ExecutorType when t

 

@Repository
public class testMapper {

    @Qualifier("SqlSessionFactory")
    protected SqlSessionFactory sqlSessionFactory;

    public testMapper(SqlSessionFactory sqlSessionFactory) {
        this.sqlSessionFactory = sqlSessionFactory;
    }

    public void updateReqReportTarget(HashMap<String, Object> map) {
        SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
        try {
            sqlSession.update("com.example.batchtest.requestReport.mapper.testMapper.updateReqReportTarget", map);
        } finally {
            sqlSession.commit();
            sqlSession.close();
        }
    }
}

 

@Mapper가 아닌 @Repository를 써야 정상 작동되었다.

 

https://limreus.tistory.com/3

[BE/Spring] @Repository 와 @Mapper 비교하기

https://stackoverflow.com/questions/27996119/what-exactly-is-the-difference-between-a-data-mapper-and-a-repository

What exactly is the difference between a data mapper and a repository?

 

 

https://monny.tistory.com/172

마이바티스 - insert할 때 주의사항

SqlSessionFactory는 autoCommit이 안 되어있어 openSession에 true로 세팅해주거나 commit을 해줘야한다.