17日目Transaction Manager 3/Fastキャンパスチャレンジ

@Test
void isolationTest(){
	Book book = new Book();
	book.setName("JPA강의");
	
	bookRepository.save(book);
    
	bookService.get(1L); //DB를 지우고 바로 테스트를 하기 때문에 book의 정보가 1번

	System.out.println(">>> " + bookRepository.findAll()); 
}

@Transactional(isolation = Isolation.READ_UNCOMMITTED) //지정
public void get(Long id){
	System.out.println(">>> "+bookRepository.findById(id));
	System.out.println(">>> "+bookRepository.findByAll());

	System.out.println(">>> "+bookRepository.findByAId(id));
	System.out.println(">>> "+bookRepository.findByAll());

}

mysql> start transaction;
Query Ok, 0 rows affacted (0.00sec)

mysql> update book set category='none';
Query Ok, 0 rows affacted (0.00sec)
Rows matched: 1 Changed: 1 Warnings:0

mysql> rollback;
Query Ok, 0 rows affacted (0.00sec)

@Transactional(isolation = Isolation.READ_UNCOMMITTED) //지정
public void get(Long id){
	System.out.println(">>> "+bookRepository.findById(id));
	System.out.println(">>> "+bookRepository.findByAll());

	System.out.println(">>> "+bookRepository.findByAId(id));
	System.out.println(">>> "+bookRepository.findByAll());

	Book book = bookRepository.findById(id).get();
	book.setName("바뀔까?");
	bookRepository.save(book);
}

mysql> start transaction;
Query Ok, 0 rows affacted (0.00sec)

mysql> update book set category='none';
Query Ok, 0 rows affacted (0.00sec)
Rows matched: 1 Changed: 1 Warnings:0

mysql> commit;
Query Ok, 0 rows affacted (0.00sec)