회원 가입 시 Insert 쿼리는 만들어지는데 디비에 저장이 안되는 경우
482
작성한 질문수 12
2021-08-27 04:10:11.140 INFO 9552 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
2021-08-27 04:10:11.141 INFO 9552 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
2021-08-27 04:10:11.142 INFO 9552 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 1 ms
2021-08-27 04:10:16.454 DEBUG 9552 --- [nio-8080-exec-2] org.hibernate.SQL :
select
member0_.member_id as member_i1_6_,
member0_.city as city2_6_,
member0_.street as street3_6_,
member0_.zipcode as zipcode4_6_,
member0_.name as name5_6_
from
user member0_
where
member0_.name=?
2021-08-27 04:10:16.462 INFO 9552 --- [nio-8080-exec-2] p6spy : #1630005016462 | took 2ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop
select member0_.member_id as member_i1_6_, member0_.city as city2_6_, member0_.street as street3_6_, member0_.zipcode as zipcode4_6_, member0_.name as name5_6_ from user member0_ where member0_.name=?
select member0_.member_id as member_i1_6_, member0_.city as city2_6_, member0_.street as street3_6_, member0_.zipcode as zipcode4_6_, member0_.name as name5_6_ from user member0_ where member0_.name='dd';
2021-08-27 04:10:16.470 DEBUG 9552 --- [nio-8080-exec-2] org.hibernate.SQL :
call next value for hibernate_sequence
2021-08-27 04:10:16.471 INFO 9552 --- [nio-8080-exec-2] p6spy : #1630005016471 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop
call next value for hibernate_sequence
call next value for hibernate_sequence;
2021-08-27 04:10:16.499 DEBUG 9552 --- [nio-8080-exec-2] org.hibernate.SQL :
insert
into
user
(city, street, zipcode, name, member_id)
values
(?, ?, ?, ?, ?)
2021-08-27 04:10:16.501 INFO 9552 --- [nio-8080-exec-2] p6spy : #1630005016501 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop
insert into user (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?)
insert into user (city, street, zipcode, name, member_id) values ('ddd', 'dd', 'dd', 'dd', 1);
2021-08-27 04:10:16.505 INFO 9552 --- [nio-8080-exec-2] p6spy : #1630005016505 | took 0ms | commit | connection 3| url jdbc:h2:tcp://localhost/~/jpashop
;
2021-08-27 04:10:16.513 INFO 9552 --- [nio-8080-exec-3] j.jpashop.Controller.HomeController : home controller
application.yml 파일입니다!
spring:
datasource:
url: jdbc:h2:tcp://localhost/~/jpashop
username: sa
password:
driver-class-name: org.h2.Driver
jpa:
hibernate:
ddl-auto: create
properties:
hibernate:
#show_sql: true
format_sql: true
logging.level:
org.hibernate.SQL: debug
# org.hibernate.type: trace
MemberController파일입니다!
package jpabook.jpashop.Controller;
import jpabook.jpashop.domain.Address;
import jpabook.jpashop.domain.Member;
import jpabook.jpashop.service.MemberService;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import javax.validation.Valid;
import java.util.List;
@Controller
@RequiredArgsConstructor
public class MemberController {
private final MemberService memberService;
@GetMapping("/members/new")
public String createForm(Model model) { // model은 request, 즉 요청 객체를 의미한다.
model.addAttribute("memberForm", new MemberForm());
return "members/createMemberForm";
} // 화면 이동 시 MemberForm 빈 껍데기 객체를 가져온다. (createMemberForm.html에서 위에서 정의한 MemberForm 객체에 접근할 수 있음)
@PostMapping("/members/new")
public String create(@Valid MemberForm form, BindingResult result) {
// @Valid를 통해 javax의 validation 기능을 사용할 수 있다.(NotEmpty 등의 예외처리 가능!)
// MemberForm에 오류가 발생하면 result에 오류 사항이 저장됨
if (result.hasErrors()) {
return "members/createMemberForm"; }
Address address = new Address(form.getCity(), form.getStreet(),form.getZipcode());
Member member = new Member();
member.setName(form.getName());
member.setAddress(address);
memberService.join(member);
return "redirect:/";
}
@GetMapping("/members") // 스프링 MVC가 제공하는 모델 객체에 보관
public String list(Model model) {
List<Member> members = memberService.findMembers();
model.addAttribute("members", members);
return "members/memberList";
}
}
답변 1
OrderServiceTest 상문주문 테스트 시 update 쿼리 문의
0
40
1
sdk 설정 오류
0
83
2
오탈자 - @Transactional
0
76
1
src/test/resources 테스트 경로 문제
0
75
1
상품 등록후 H2 db 출력 순서 바꿀 수 있나요?
0
74
1
MemberRepositoryTest 실행오류
0
98
1
boot 4.x >>> trasasction rolled back log & p6spy(영한님, 수업 자료 업데이트 해주시면 감사하겠습니다!!)
1
204
2
강의 마지막 QueryDSL 사용 부분 질문있습니다
1
161
2
클라이언트에서 isbn과 author 수정 요청을 한 경우에 대해 질문드립니다.
0
61
1
도메인 모델 패턴 vs 트랜잭션 스크립트 패턴
0
90
1
기본 생성자
0
69
1
h2 DB 연결시 jdbc url 변경 이유가 궁금합니다.
0
109
1
멤버서비스테스트 부분에서 막힙니다.
0
188
4
실무에서도 EntityManager를 이용해서 많이 작업하는 편일까요?
0
130
1
초반에 h2 다운로드 과정 꼭 필요한가요?
0
134
2
자신 필드에도 get으로 접근하는 이유가 있을까요?
0
126
1
24분 27초 연관관계 편의 메서드 위치
0
120
1
단건 주문만 가능하게 한건 의도한 부분이신가요?
0
120
2
빌드 툴, Gradle
0
73
1
h2연결은 된 것 같은데 엔티티 테이블까지 작성 후 확인해보아도 테이블이 안보입니다
0
85
2
Repository에서 EntityManager 주입 방식 차이
0
100
1
롬복과 사용자 정의 setter 메서드
0
80
1
주문 목록 조회 fetch join 질문드립니다
0
93
1
dirty checking 질문드립니다.
0
91
1





