JPA repository.메서드() 무한루프 질문입니다.

Question

db(mariadb)에서 countVal를 아이피주소가 테이블에 없으면 1증감하는 코드입니다.문제는 서버실행하고 페이지 새로고침하면 콘솔창에 쿼리문이 무한으로 반복됩니다.@Transactional 어노테이션이 없을 경우 update/delete... 어쩌고 어노테이션 넣으라고 나옵니다.@Transactional(isolation=Isolation. 여러개) 넣어봤는데 무한루프는 계속됩니다.이럴 땐 어떻게해야하죠? @Modifying(clearAutomatically = true) @Query("UPDATE Count SET todayVal = todayVal+1 WHERE criteriaVal = 'this is a count val'") public int updateCount(); public Optional findByCriteriaVal(String thisis); @Query("SELECT todayVal from Count") public int findByCountVal(int i); @Modifying(clearAutomatically = true) @Query("UPDATE Count SET totalVal = totalVal+todayVal WHERE criteriaVal = 'this is a count val'") public int updateTotal(); @Modifying(clearAutomatically = true) @Query("UPDATE Count SET todayVal = 0 WHERE criteriaVal = 'this is a count val'") public int updateTodayZero();}private final DummyIPRepository dummyRepository;private final CountRepository countRepository;private final MemberService service;@GetMapping("/today")@Transactionalpublic ResponseEntity setCounter() throws Exception {String clientIP = getUserIp();Count thisis = new Count();String textArg = "this is a count val";thisis.setCriteriaVal(textArg);Optional chkIp = service.readCnt(clientIP);Optional chkCriteriaVal = service.readCriteriaVal(textArg);if(chkIp.isPresent()!=true) {if(chkCriteriaVal.isPresent()!=true) {countRepository.save(thisis);DummyIP ip = DummyIP.builder().ipAddr(clientIP).build();dummyRepository.save(ip);countRepository.updateCount();countRepository.updateTotal();} else {DummyIP ip = DummyIP.builder().ipAddr(clientIP).build();dummyRepository.save(ip);countRepository.updateCount();countRepository.updateTotal();}}int extractsCountNum = countRepository.findByCountVal(1);return new ResponseEntity(extractsCountNum, HttpStatus.OK);}

JPA repository.메서드() 무한루프 질문입니다.

0개의 답변

Q&A 목록