전자정부 4.1 mybatis 오류시 트랜잭션 롤백이 되지 않습니다.

Question

@RequestMapping(value="/admin/post/post/save.do") public String save(ModelMap model,final MultipartHttpServletRequest multiRequest,AdminPostVO adminPostVO,HttpSession session) throws Exception { LoginVO loginVO = (LoginVO) session.getAttribute("LoginVO"); adminPostVO.setRegId(loginVO.getMberId()); adminPostVO.setUpdId(loginVO.getMberId()); adminPostVO.setPostContent("111111111111"); adminPostVO.setPostTitle("32"); adminPostVO.setPostId("11111111111111111111"); int result =adminPostService.saveAdminPost(adminPostVO); adminPostVO.setPostContent("111111111111"); adminPostVO.setPostTitle("32"); adminPostVO.setPostId(null); int result2 =adminPostService.saveAdminPost(adminPostVO); return ""; }package cms.post.service; import cms.post.vo.AdminPostVO; public interface AdminPostService { int saveAdminPost(AdminPostVO adminPostVO); } package cms.post.service.impl; @Service("adminPostService") public class AdminPostServiceImpl extends EgovAbstractServiceImpl implements AdminPostService { @Resource(name = "AdminPostDAO") private AdminPostDAO adminPostDAO; @Override public int saveAdminPost(AdminPostVO adminPostVO) { return adminPostDAO.saveAdminPost(adminPostVO); } }package cms.post.service.impl; @Repository("AdminPostDAO") public class AdminPostDAO extends EgovAbstractMapper { public int saveAdminPost(AdminPostVO adminPostVO) { return insert("saveAdminPost",adminPostVO); } } INSERT INTO lettnpost ( POST_ID ,POST_TITLE ,POST_CONTENT ,VIEWS ,DEL_YN ,SECRET_YN ,APPROV_YN ,ATCH_FILE_ID ,BOARD_ID ,NOTICE_YN ,REG_ID ,REG_DATE ) VALUES ( #{postId} ,#{postTitle} ,#{postContent} ,#{views} ,'N' ,#{secretYn} ,#{approvYn} ,#{atchFileId} ,#{boardId} ,#{noticeYn} ,#{regId} ,NOW() ) ON DUPLICATE KEY UPDATE POST_TITLE = #{postTitle} ,POST_CONTENT = #{postContent} ,VIEWS = #{views} ,SECRET_YN = #{secretYn} ,APPROV_YN = #{approvYn} ,ATCH_FILE_ID = #{atchFileId} ,NOTICE_YN = #{noticeYn} ,UPD_ID = #{updId} ,UPD_DATE = NOW() adminPostVO.setPostId("11111111111111111111"); int result =adminPostService.saveAdminPost(adminPostVO); adminPostVO.setPostContent("111111111111"); adminPostVO.setPostTitle("32"); adminPostVO.setPostId(null); int result2 =adminPostService.saveAdminPost(adminPostVO); <== 고의적 에러 발생시에 현재 상태에서 컨트롤러 단에서 마지막에 에러를 발생시켰을떄 직전에 saveAdminPost 함수에서 넣었던 adminPostVO.setPostId("11111111111111111111"); 부분이 그대로 커밋이 되는 상황이 발생하는데 이거 혹시 어떤 문제 때문인지 알수있을까요 ?

오후 · Answer

@Transactional 어노테이션붙여보세요

전자정부 4.1 mybatis 오류시 트랜잭션 롤백이 되지 않습니다.

1개의 답변

Q&A 목록