묻고 답해요
164만명의 커뮤니티!! 함께 토론해봐요.
인프런 TOP Writers
-
미해결[C#과 유니티로 만드는 MMORPG 게임 개발 시리즈] Part2: 자료구조와 알고리즘
elapsedTick 의 부등호 방향
const int WAIT_TICK = 1000 / 30if(currentTick - lastTick < WAIT_TICK)continue;에서 부등호의 방향이 반대가 되어야지 강의에서 의도한 의미가 되는것이 아닌가요?흐른 시간이 1/30 초가 될때마다 contiue 되어서화면이 갱신된다는 의미로 이해하는데. 그렇게 되려면if(currentTick - lastTick > WAIT_TICK)continue;이 되어야 하는것이 아닌지요?
-
미해결스프링 입문 - 코드로 배우는 스프링 부트, 웹 MVC, DB 접근 기술
@transactional 테스트케이스
@transactional 이 db를 다시 삭제한다기보다는 아예 반영을 안한다는 거라고 하셨는데, 그러면 테스트를 진행할 때, db 와 연결하는 코드, db값을 보는 코드 등이 있는데 db 에서 값을 가져와서 값이 일치하는지 알려면 db 에 값이 저장이 되어야 하는데, 이런 부분들은 아예 반영 없이 , 저장 없이 어떻게 테스트를 하는 건가요?
-
미해결Vue.js 중급 강좌 - 웹앱 제작으로 배워보는 Vue.js, ES6, Vuex
GIT Repository에 접근은 가능한가요?
영상에 나온대로 계정도 만들고 댓글도 남겼습니다만...https://github.com/joshua1988/vue-intermediate 에 접속해봐도 404에러만 나오네요.혹시 URL이 변경된건지... 제가 놓친게 있는건지 잘 모르겠습니다.GITHUB: boolpae@gmail.com인프런: boolpae@naver.com 입니다.
-
해결됨비전공자를 위한 진짜 입문 올인원 개발 부트캠프
이미지가 안나옵니다..
상품 업로드 창에서 정보들 입력하고상품 등록 하고 가면 이렇게 이미지가 안 뜹니다코드들을 다 선생님이 허브에 올려주신 걸로 바꿔서도 해봤는데 안됩니다 ㅠ 뭐가 잘못된 걸까요제가 다른 게 뭔가 비교 해봤을 때는 서버 터미널 창에 나오는 경로가'upload/~~''upload//~~' 이렇게 가는 거또 dbbrowersql에서 경로가 /가 아닌 원화 표시로 나오는 거이거 2개입니다.
-
미해결초보를 위한 도커 안내서
도커 사용 관련
안녕하세요~Front : next.js / apollo clinet(graphql)Back API : express / apollo server / graphql / mysql현재 위와 같이 개발중에 있고, 도커를 이용해서 aws EC2 서버에 배포를 하려고 합니다. 설명해주신 개념으로 보면, front와 back를 도커를 이용하여 컨테이너를 각각 하나씩 생성해서 aws EC2 가상인스턴스에 업로드를 하는개념인건가요 ?
-
미해결자바스크립트 중고급: 엔진 핵심
[[Scope]] 와 [[Environment]]는 같은 개념인가요
ES6 스펙을 보면 Function 오브젝트의 내부 프로퍼티에 [[Scope]] 는 없고 , 대신 [[Environment]] 가 있던데, ES6로 오면서 개념이 바뀐 것인지 궁금합니다.
-
미해결Node.js로 웹 크롤링하기
로그인 오류
브라우저 또는 앱이 안전하지 않을 수 있습니다. 라고 뜨며 다음 버튼이 클릭되지 않습니다. 해결방법이 있을까요?
-
해결됨[C++과 언리얼로 만드는 MMORPG 게임 개발 시리즈] Part4: 게임 서버
SendBufferRef에 대하여 질문 있습니다.
안녕하세요 루키스님이번 SendBuffer 강의를 들으면서 궁금한 것이 생겨 질문 드립니다.SendBuffer에 자기 자신에 대한 스마트 포인터를 갖도록 해주어 Reference Counting을 해주었는데, 이번 강의의 코드를 복습하면서 분석하다 보니 '왜 SendBuffer에 RefCounting이 필요한가?' 에 대한 의문이 생겼습니다. 일단 제가 이해한 Send의 흐름은 다음과 같습니다.GameSession에서 SendBuffer를 생성하여 원하는 데이터를 복사하여 Send를 호출하면 SendQueue에 일단 Push하여 데이터를 쌓아 놓습니다.그 때 어떠한 쓰레드에서도 그 세션에 대한 RegisterSend를 수행하고 있지 않다면 해당 쓰레드가 RegisterSend를 수행하는데 이때까지 쌓인 데이터를 SendEvent의 버퍼에 담아 WSASend를 수행합니다.그런 다음 IocpCore에서 완료 통지를 받으면 Worker 쓰레드가 Dispatch를 수행하여 ProcessSend를 수행하면서 이 때 SendQueue에 데이터가 더 있다면 그 쓰레드가 RegisterSend를 수행합니다.위의 흐름이 제가 이해한 내용인데 결국 한번에 하나의 RegisterSend가 진행되도록 하는 것이 핵심이며 한 번에 하나만 실행하기 때문에 SendEvent도 재 사용 가능한 것이라고 생각합니다. 그렇다면 이 세션에 대한 SendEvent는 Send되고 있는 동안에는 멀티쓰레드 환경에서 안전하다고 생각 되는데 그렇다면 SendEvent에 담긴 SendBuffer도 안전하여 사라질 걱정을 하지 않아도 되는 것 아닐까 싶습니다.즉, WSASend를 한 번에 하나의 쓰레드만 수행하기 때문에 SendEvent도 재 사용이 가능하고 그 속에 담긴 SendBuffer도 멀티쓰레드 환경으로부터 안전하기 때문에 SendBuffer의 RefCounting이 왜 필요한 것인지 궁금합니다.
-
미해결[리뉴얼] React로 NodeBird SNS 만들기
Post model에 대해 질문드립니다.
만약 게시글 주제가 여러 개인 경우에는 Post를 나눠야 하나요?예를 들어, 연예인이라는 큰 Post가 있고, 하위 Post로 bts, 블랙핑크, 트와이스 등과 관련된 게시글들이 있다고 가정하면1. 연예인이라는 하나의 Post에 하위 Post를 category로 분류하는 것이 좋을까요2. 아니면 하위 Post를 개별적인 스키마로 만드는 것이 좋을까요?
-
미해결데브옵스(DevOps)를 위한 쿠버네티스 마스터
볼륨마운트가 제대로 수행이 안됩니다.
# volume mount :: docker run -v {host path}:{container path}:{permission ro 읽기전용, rw 읽기 및 쓰기} root@ip-10-192-147-31:/var/www># docker run -d -p 8000:80 -v /var/www:/usr/share/nginx/html:ro nginx a028accb69bf2cfc604a36f76e3aa85ee98d2247869c909519026bae7a5a1863 # 마운트 시켜놓은 /var/www 경로에 아무것도 없어서 403 에러가 발생함 root@ip-10-192-147-31:/var/www># curl localhost:8000 <html> <head><title>403 Forbidden</title></head> <body> <center><h1>403 Forbidden</h1></center> <hr><center>nginx/1.23.1</center> </body> </html> * Connection #0 to host localhost left intact # index.html 파일 생성 root@ip-10-192-147-31:/var/www># echo test1234 > index.html root@ip-10-192-147-31:/root># ls -al /var/www/ 합계 4 drwxr-x--- 2 root root 24 9월 2 18:04 . drwxr-xr-x 21 root root 293 9월 2 17:47 .. -rwxrwxrwx 1 root root 9 9월 2 18:04 index.html안녕하세요~ 호스트의 볼륨을 컨테이너에 마운트해주는 실습중 궁금한 점이 생겼습니다.여기까지 해주고, localhost:8000 으로 접속하면 test1234 가 정상적으로 떠야할 거서 같은데요# ...? 왜 안보이지 root@ip-10-192-147-31:/var/www># curl -v localhost:8000 * Trying 127.0.0.1:8000... * Connected to localhost (127.0.0.1) port 8000 (#0) > GET / HTTP/1.1 > Host: localhost:8000 > User-Agent: curl/7.79.1 > Accept: */* > * Mark bundle as not supporting multiuse < HTTP/1.1 403 Forbidden < Server: nginx/1.23.1 < Date: Fri, 02 Sep 2022 09:04:36 GMT < Content-Type: text/html < Content-Length: 153 < Connection: keep-alive < <html> <head><title>403 Forbidden</title></head> <body> <center><h1>403 Forbidden</h1></center> <hr><center>nginx/1.23.1</center> </body> </html> * Connection #0 to host localhost left intact # 컨테이너 안에 들어가면, 볼륨 마운트는 잘 되어 있음 root@b7819c1de150:/usr/share/nginx/html# cat index.html test1234뜨지 않습니다 ㅠㅠ 원인이 무엇일까요?
-
미해결따라하며 배우는 도커와 CI환경 [2023.11 업데이트]
Travis CI 무료플랜 제한으로 강의 수강에 제약이 습니다.
Travis CI 무료플랜 제한으로 Github 연동과 사용에 제약이 있으며 남은 강의 과목에서 Travis CI에 대해 관련있는 부분들이 많습니다.커리큘럼에 따른 강의를 들으며 제약이 상당히 있을것 같습니다만 이를 위해 어떻게 처리하면 좋을지 피드백 부탁드립니다.
-
미해결파이썬 텍스트 분석 입문 - 데이터 수집부터 분석까지
p54 문의드립니다
안녕하세요! 올려주신 pdf 내용대로 따라가고 있는 도중 mecab 부분에서 오류가 잇는것 같아 문의드립니다. 저와 동일한 질문이 있을까 하여 찾아보던중 피디에프 p54에서 105번째가 아닌 74번째에 저도 dicpath의 인자값이 있습니다.이는 다른버전을 다운받아서라고 답변을 남겨주셨는데 제 파이썬 버전은 3.7.9 입니다.따라서 올려주신 mecab설명부분에서 또한 3.7버전, 64운영체제로 진행하였으나 아래그림처럼 74번째에 뜹니다ㅠ이를 어떻게 해결할 수 있을까요,,, 답변부탁드립니다ㅠㅠ
-
미해결[실전 게임 코드 리뷰] 유니티 클리커 게임
xml 관련 문의
안녕하세요 선생님.json대신 xml을 사용하신 이유가 따로 있나요??
-
해결됨실전! 스프링 부트와 JPA 활용2 - API 개발과 성능 최적화
/api/v1/simple-orders에서 무한루프가 발생하지 않고 NullPointerException이 발생합니다.
안녕하세요강의를 차근차근 듣고 있었는데 /api/v1/simple-orders 단계에서 무한루프가 발생하지 않고 NullPointerException이 발생하여 문의드립니다.주신 소스코드와 비교해가면서 무엇이 잘못되었는지도 봤는데, 아직 발견을 하지 못했습니다.ㅠㅠ 에러코드입니다.오후 5:06:10: Executing ':JpaShopApplication.main()'...> Task :compileJava> Task :processResources UP-TO-DATE> Task :classesNote: C:\Users\EUNJEONG\Desktop\github\Inflearn-spring\jpa-shop\src\main\java\jpabook\jpashop\api\MemberApiController.java uses unchecked or unsafe operations.Note: Recompile with -Xlint:unchecked for details.> Task :JpaShopApplication.main()17:06:12.589 [Thread-0] DEBUG org.springframework.boot.devtools.restart.classloader.RestartClassLoader - Created RestartClassLoader org.springframework.boot.devtools.restart.classloader.RestartClassLoader@2df60ff8 . ____ _ /\\ / ___'_ __ (_)_ _ \ \ \ \( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.7.3)2022-09-02 17:06:13.266 INFO 26936 --- [ restartedMain] jpabook.jpashop.JpaShopApplication : Starting JpaShopApplication using Java 11.0.13 on DESKTOP-QKLC6IA with PID 26936 (C:\Users\EUNJEONG\Desktop\github\Inflearn-spring\jpa-shop\build\classes\java\main started by EUNJEONG in C:\Users\EUNJEONG\Desktop\github\Inflearn-spring\jpa-shop)2022-09-02 17:06:13.269 INFO 26936 --- [ restartedMain] jpabook.jpashop.JpaShopApplication : No active profile set, falling back to 1 default profile: "default"2022-09-02 17:06:13.349 INFO 26936 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable2022-09-02 17:06:13.349 INFO 26936 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'2022-09-02 17:06:14.884 INFO 26936 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.2022-09-02 17:06:14.921 INFO 26936 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 14 ms. Found 0 JPA repository interfaces.2022-09-02 17:06:15.891 INFO 26936 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)2022-09-02 17:06:15.906 INFO 26936 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat]2022-09-02 17:06:15.907 INFO 26936 --- [ restartedMain] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.65]2022-09-02 17:06:16.036 INFO 26936 --- [ restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext2022-09-02 17:06:16.036 INFO 26936 --- [ restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2687 ms2022-09-02 17:06:16.248 INFO 26936 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...2022-09-02 17:06:16.355 INFO 26936 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.2022-09-02 17:06:16.371 INFO 26936 --- [ restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:tcp://localhost/~/jpashop'2022-09-02 17:06:16.602 INFO 26936 --- [ restartedMain] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]2022-09-02 17:06:16.667 INFO 26936 --- [ restartedMain] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.6.10.Final2022-09-02 17:06:16.889 INFO 26936 --- [ restartedMain] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}2022-09-02 17:06:16.928 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration boolean -> org.hibernate.type.BooleanType@6403f17a2022-09-02 17:06:16.928 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration boolean -> org.hibernate.type.BooleanType@6403f17a2022-09-02 17:06:16.929 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Boolean -> org.hibernate.type.BooleanType@6403f17a2022-09-02 17:06:16.929 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration numeric_boolean -> org.hibernate.type.NumericBooleanType@353241f72022-09-02 17:06:16.930 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration true_false -> org.hibernate.type.TrueFalseType@bf5a83e2022-09-02 17:06:16.931 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration yes_no -> org.hibernate.type.YesNoType@3f5b85f52022-09-02 17:06:16.932 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration byte -> org.hibernate.type.ByteType@38f5bf172022-09-02 17:06:16.933 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration byte -> org.hibernate.type.ByteType@38f5bf172022-09-02 17:06:16.933 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Byte -> org.hibernate.type.ByteType@38f5bf172022-09-02 17:06:16.934 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration character -> org.hibernate.type.CharacterType@13b5e9dc2022-09-02 17:06:16.934 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration char -> org.hibernate.type.CharacterType@13b5e9dc2022-09-02 17:06:16.935 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Character -> org.hibernate.type.CharacterType@13b5e9dc2022-09-02 17:06:16.936 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration short -> org.hibernate.type.ShortType@4c8837e02022-09-02 17:06:16.936 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration short -> org.hibernate.type.ShortType@4c8837e02022-09-02 17:06:16.936 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Short -> org.hibernate.type.ShortType@4c8837e02022-09-02 17:06:16.938 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration integer -> org.hibernate.type.IntegerType@46a8156f2022-09-02 17:06:16.938 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration int -> org.hibernate.type.IntegerType@46a8156f2022-09-02 17:06:16.938 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Integer -> org.hibernate.type.IntegerType@46a8156f2022-09-02 17:06:16.939 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration long -> org.hibernate.type.LongType@459eea7a2022-09-02 17:06:16.939 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration long -> org.hibernate.type.LongType@459eea7a2022-09-02 17:06:16.939 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Long -> org.hibernate.type.LongType@459eea7a2022-09-02 17:06:16.941 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration float -> org.hibernate.type.FloatType@47767afe2022-09-02 17:06:16.942 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration float -> org.hibernate.type.FloatType@47767afe2022-09-02 17:06:16.942 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Float -> org.hibernate.type.FloatType@47767afe2022-09-02 17:06:16.943 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration double -> org.hibernate.type.DoubleType@301e3192022-09-02 17:06:16.943 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration double -> org.hibernate.type.DoubleType@301e3192022-09-02 17:06:16.944 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Double -> org.hibernate.type.DoubleType@301e3192022-09-02 17:06:16.944 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration big_decimal -> org.hibernate.type.BigDecimalType@159c52352022-09-02 17:06:16.944 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.math.BigDecimal -> org.hibernate.type.BigDecimalType@159c52352022-09-02 17:06:16.945 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration big_integer -> org.hibernate.type.BigIntegerType@36c33a92022-09-02 17:06:16.946 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.math.BigInteger -> org.hibernate.type.BigIntegerType@36c33a92022-09-02 17:06:16.947 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration string -> org.hibernate.type.StringType@5bec0a892022-09-02 17:06:16.947 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.String -> org.hibernate.type.StringType@5bec0a892022-09-02 17:06:16.948 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration nstring -> org.hibernate.type.StringNVarcharType@631511752022-09-02 17:06:16.948 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration ncharacter -> org.hibernate.type.CharacterNCharType@6a1ec0cb2022-09-02 17:06:16.949 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration url -> org.hibernate.type.UrlType@5db22bcf2022-09-02 17:06:16.950 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.net.URL -> org.hibernate.type.UrlType@5db22bcf2022-09-02 17:06:16.951 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration Duration -> org.hibernate.type.DurationType@2085a1902022-09-02 17:06:16.951 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.Duration -> org.hibernate.type.DurationType@2085a1902022-09-02 17:06:16.953 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration Instant -> org.hibernate.type.InstantType@67e67112022-09-02 17:06:16.954 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.Instant -> org.hibernate.type.InstantType@67e67112022-09-02 17:06:16.955 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration LocalDateTime -> org.hibernate.type.LocalDateTimeType@96c6822022-09-02 17:06:16.955 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.LocalDateTime -> org.hibernate.type.LocalDateTimeType@96c6822022-09-02 17:06:16.957 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration LocalDate -> org.hibernate.type.LocalDateType@38afcf3a2022-09-02 17:06:16.957 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.LocalDate -> org.hibernate.type.LocalDateType@38afcf3a2022-09-02 17:06:16.958 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration LocalTime -> org.hibernate.type.LocalTimeType@60aaa402022-09-02 17:06:16.958 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.LocalTime -> org.hibernate.type.LocalTimeType@60aaa402022-09-02 17:06:16.960 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration OffsetDateTime -> org.hibernate.type.OffsetDateTimeType@1803c1d72022-09-02 17:06:16.960 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.OffsetDateTime -> org.hibernate.type.OffsetDateTimeType@1803c1d72022-09-02 17:06:16.961 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration OffsetTime -> org.hibernate.type.OffsetTimeType@aedc5cc2022-09-02 17:06:16.961 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.OffsetTime -> org.hibernate.type.OffsetTimeType@aedc5cc2022-09-02 17:06:16.962 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration ZonedDateTime -> org.hibernate.type.ZonedDateTimeType@7b5384462022-09-02 17:06:16.963 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.ZonedDateTime -> org.hibernate.type.ZonedDateTimeType@7b5384462022-09-02 17:06:16.964 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration date -> org.hibernate.type.DateType@4ded30b02022-09-02 17:06:16.964 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Date -> org.hibernate.type.DateType@4ded30b02022-09-02 17:06:16.965 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration time -> org.hibernate.type.TimeType@27c352e72022-09-02 17:06:16.965 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Time -> org.hibernate.type.TimeType@27c352e72022-09-02 17:06:16.966 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration timestamp -> org.hibernate.type.TimestampType@6ea47aa62022-09-02 17:06:16.966 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Timestamp -> org.hibernate.type.TimestampType@6ea47aa62022-09-02 17:06:16.966 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Date -> org.hibernate.type.TimestampType@6ea47aa62022-09-02 17:06:16.967 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration dbtimestamp -> org.hibernate.type.DbTimestampType@1841901c2022-09-02 17:06:16.969 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration calendar -> org.hibernate.type.CalendarType@620b21b62022-09-02 17:06:16.969 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Calendar -> org.hibernate.type.CalendarType@620b21b62022-09-02 17:06:16.969 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.GregorianCalendar -> org.hibernate.type.CalendarType@620b21b62022-09-02 17:06:16.970 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration calendar_date -> org.hibernate.type.CalendarDateType@1db7f3032022-09-02 17:06:16.970 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration calendar_time -> org.hibernate.type.CalendarTimeType@7fc72f612022-09-02 17:06:16.972 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration locale -> org.hibernate.type.LocaleType@33082bc82022-09-02 17:06:16.972 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Locale -> org.hibernate.type.LocaleType@33082bc82022-09-02 17:06:16.974 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration currency -> org.hibernate.type.CurrencyType@309e9cff2022-09-02 17:06:16.974 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Currency -> org.hibernate.type.CurrencyType@309e9cff2022-09-02 17:06:16.975 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration timezone -> org.hibernate.type.TimeZoneType@1fb09ad72022-09-02 17:06:16.975 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.TimeZone -> org.hibernate.type.TimeZoneType@1fb09ad72022-09-02 17:06:16.976 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration class -> org.hibernate.type.ClassType@42b173ec2022-09-02 17:06:16.976 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Class -> org.hibernate.type.ClassType@42b173ec2022-09-02 17:06:16.977 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration uuid-binary -> org.hibernate.type.UUIDBinaryType@9c30afa2022-09-02 17:06:16.977 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.UUID -> org.hibernate.type.UUIDBinaryType@9c30afa2022-09-02 17:06:16.978 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration uuid-char -> org.hibernate.type.UUIDCharType@71cd9ba12022-09-02 17:06:16.979 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration binary -> org.hibernate.type.BinaryType@15cd7c6a2022-09-02 17:06:16.979 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration byte[] -> org.hibernate.type.BinaryType@15cd7c6a2022-09-02 17:06:16.979 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration [B -> org.hibernate.type.BinaryType@15cd7c6a2022-09-02 17:06:16.980 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration wrapper-binary -> org.hibernate.type.WrapperBinaryType@18c9f06c2022-09-02 17:06:16.980 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration Byte[] -> org.hibernate.type.WrapperBinaryType@18c9f06c2022-09-02 17:06:16.980 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration [Ljava.lang.Byte; -> org.hibernate.type.WrapperBinaryType@18c9f06c2022-09-02 17:06:16.981 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration row_version -> org.hibernate.type.RowVersionType@7928f85d2022-09-02 17:06:16.981 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration image -> org.hibernate.type.ImageType@4e1b40fa2022-09-02 17:06:16.982 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration characters -> org.hibernate.type.CharArrayType@6aa9a8e82022-09-02 17:06:16.982 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration char[] -> org.hibernate.type.CharArrayType@6aa9a8e82022-09-02 17:06:16.982 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration [C -> org.hibernate.type.CharArrayType@6aa9a8e82022-09-02 17:06:16.983 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration wrapper-characters -> org.hibernate.type.CharacterArrayType@3e2fcf012022-09-02 17:06:16.983 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration [Ljava.lang.Character; -> org.hibernate.type.CharacterArrayType@3e2fcf012022-09-02 17:06:16.983 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration Character[] -> org.hibernate.type.CharacterArrayType@3e2fcf012022-09-02 17:06:16.984 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration text -> org.hibernate.type.TextType@17f9dfd2022-09-02 17:06:16.985 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration ntext -> org.hibernate.type.NTextType@5f1ea47f2022-09-02 17:06:16.987 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration blob -> org.hibernate.type.BlobType@5537f97b2022-09-02 17:06:16.987 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Blob -> org.hibernate.type.BlobType@5537f97b2022-09-02 17:06:16.987 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration materialized_blob -> org.hibernate.type.MaterializedBlobType@49a4fbb2022-09-02 17:06:16.989 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration clob -> org.hibernate.type.ClobType@1586c2812022-09-02 17:06:16.989 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Clob -> org.hibernate.type.ClobType@1586c2812022-09-02 17:06:16.990 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration nclob -> org.hibernate.type.NClobType@728233b82022-09-02 17:06:16.990 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.NClob -> org.hibernate.type.NClobType@728233b82022-09-02 17:06:16.991 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration materialized_clob -> org.hibernate.type.MaterializedClobType@7f6d685a2022-09-02 17:06:16.991 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration materialized_nclob -> org.hibernate.type.MaterializedNClobType@3fd21eae2022-09-02 17:06:16.992 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration serializable -> org.hibernate.type.SerializableType@27a532d12022-09-02 17:06:16.996 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration object -> org.hibernate.type.ObjectType@328f6b112022-09-02 17:06:16.996 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Object -> org.hibernate.type.ObjectType@328f6b112022-09-02 17:06:16.996 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_date -> org.hibernate.type.AdaptedImmutableType@1e18cee72022-09-02 17:06:16.996 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_time -> org.hibernate.type.AdaptedImmutableType@1a0eeb9b2022-09-02 17:06:16.996 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_timestamp -> org.hibernate.type.AdaptedImmutableType@6e2992962022-09-02 17:06:16.997 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_dbtimestamp -> org.hibernate.type.AdaptedImmutableType@e48566e2022-09-02 17:06:16.997 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_calendar -> org.hibernate.type.AdaptedImmutableType@56ffdeb62022-09-02 17:06:16.997 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_calendar_date -> org.hibernate.type.AdaptedImmutableType@3bc0b5c12022-09-02 17:06:16.997 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_binary -> org.hibernate.type.AdaptedImmutableType@19df2d0d2022-09-02 17:06:16.997 DEBUG 26936 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_serializable -> org.hibernate.type.AdaptedImmutableType@55e8e37e2022-09-02 17:06:17.091 INFO 26936 --- [ restartedMain] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.H2Dialect2022-09-02 17:06:17.128 DEBUG 26936 --- [ restartedMain] o.h.type.spi.TypeConfiguration$Scope : Scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration@2913b3fb] to MetadataBuildingContext [org.hibernate.boot.internal.MetadataBuildingContextRootImpl@24490647]2022-09-02 17:06:17.357 INFO 26936 --- [ restartedMain] org.hibernate.tuple.PojoInstantiator : HHH000182: No default (no-argument) constructor for class: jpabook.jpashop.domain.DeliveryStatus (class must be instantiated by Interceptor)2022-09-02 17:06:17.563 DEBUG 26936 --- [ restartedMain] org.hibernate.type.EnumType : Using NAMED-based conversion for Enum jpabook.jpashop.domain.OrderStatus2022-09-02 17:06:17.564 DEBUG 26936 --- [ restartedMain] o.h.type.spi.TypeConfiguration$Scope : Scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration@2913b3fb] to SessionFactoryImpl [org.hibernate.internal.SessionFactoryImpl@4ea503a7]2022-09-02 17:06:18.014 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : drop table if exists category CASCADE 2022-09-02 17:06:18.032 INFO 26936 --- [ restartedMain] p6spy : #1662105978032 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop drop table if exists category CASCADE drop table if exists category CASCADE ;2022-09-02 17:06:18.032 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : drop table if exists category_item CASCADE 2022-09-02 17:06:18.033 INFO 26936 --- [ restartedMain] p6spy : #1662105978033 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop drop table if exists category_item CASCADE drop table if exists category_item CASCADE ;2022-09-02 17:06:18.033 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : drop table if exists delivery CASCADE 2022-09-02 17:06:18.033 INFO 26936 --- [ restartedMain] p6spy : #1662105978033 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop drop table if exists delivery CASCADE drop table if exists delivery CASCADE ;2022-09-02 17:06:18.033 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : drop table if exists item CASCADE 2022-09-02 17:06:18.033 INFO 26936 --- [ restartedMain] p6spy : #1662105978033 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop drop table if exists item CASCADE drop table if exists item CASCADE ;2022-09-02 17:06:18.033 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : drop table if exists member CASCADE 2022-09-02 17:06:18.033 INFO 26936 --- [ restartedMain] p6spy : #1662105978033 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop drop table if exists member CASCADE drop table if exists member CASCADE ;2022-09-02 17:06:18.033 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : drop table if exists order_item CASCADE 2022-09-02 17:06:18.034 INFO 26936 --- [ restartedMain] p6spy : #1662105978034 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop drop table if exists order_item CASCADE drop table if exists order_item CASCADE ;2022-09-02 17:06:18.034 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : drop table if exists orders CASCADE 2022-09-02 17:06:18.034 INFO 26936 --- [ restartedMain] p6spy : #1662105978034 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop drop table if exists orders CASCADE drop table if exists orders CASCADE ;2022-09-02 17:06:18.034 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : drop sequence if exists hibernate_sequence2022-09-02 17:06:18.034 INFO 26936 --- [ restartedMain] p6spy : #1662105978034 | took 0ms | statement | connection 2| url jdbc:h2:tcp://localhost/~/jpashop drop sequence if exists hibernate_sequence drop sequence if exists hibernate_sequence;2022-09-02 17:06:18.037 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : create sequence hibernate_sequence start with 1 increment by 12022-09-02 17:06:18.038 INFO 26936 --- [ restartedMain] p6spy : #1662105978038 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashopcreate sequence hibernate_sequence start with 1 increment by 1create sequence hibernate_sequence start with 1 increment by 1;2022-09-02 17:06:18.038 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : create table category ( category_id bigint not null, name varchar(255), parent_id bigint, primary key (category_id) )2022-09-02 17:06:18.039 INFO 26936 --- [ restartedMain] p6spy : #1662105978039 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop create table category ( category_id bigint not null, name varchar(255), parent_id bigint, primary key (category_id) ) create table category ( category_id bigint not null, name varchar(255), parent_id bigint, primary key (category_id) );2022-09-02 17:06:18.039 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : create table category_item ( category_id bigint not null, item_id bigint not null )2022-09-02 17:06:18.039 INFO 26936 --- [ restartedMain] p6spy : #1662105978039 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop create table category_item ( category_id bigint not null, item_id bigint not null ) create table category_item ( category_id bigint not null, item_id bigint not null );2022-09-02 17:06:18.040 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : create table delivery ( delivery_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), primary key (delivery_id) )2022-09-02 17:06:18.040 INFO 26936 --- [ restartedMain] p6spy : #1662105978040 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop create table delivery ( delivery_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), primary key (delivery_id) ) create table delivery ( delivery_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), primary key (delivery_id) );2022-09-02 17:06:18.040 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : create table item ( dtype varchar(31) not null, item_id bigint not null, name varchar(255), price integer not null, stock_quantity integer not null, artist varchar(255), etc varchar(255), author varchar(255), isbn varchar(255), actor varchar(255), director varchar(255), primary key (item_id) )2022-09-02 17:06:18.041 INFO 26936 --- [ restartedMain] p6spy : #1662105978041 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop create table item ( dtype varchar(31) not null, item_id bigint not null, name varchar(255), price integer not null, stock_quantity integer not null, artist varchar(255), etc varchar(255), author varchar(255), isbn varchar(255), actor varchar(255), director varchar(255), primary key (item_id) ) create table item ( dtype varchar(31) not null, item_id bigint not null, name varchar(255), price integer not null, stock_quantity integer not null, artist varchar(255), etc varchar(255), author varchar(255), isbn varchar(255), actor varchar(255), director varchar(255), primary key (item_id) );2022-09-02 17:06:18.041 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : create table member ( member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), primary key (member_id) )2022-09-02 17:06:18.042 INFO 26936 --- [ restartedMain] p6spy : #1662105978041 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop create table member ( member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), primary key (member_id) ) create table member ( member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), primary key (member_id) );2022-09-02 17:06:18.042 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : create table order_item ( order_item_id bigint not null, count integer not null, order_price integer not null, item_id bigint, order_id bigint, primary key (order_item_id) )2022-09-02 17:06:18.042 INFO 26936 --- [ restartedMain] p6spy : #1662105978042 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop create table order_item ( order_item_id bigint not null, count integer not null, order_price integer not null, item_id bigint, order_id bigint, primary key (order_item_id) ) create table order_item ( order_item_id bigint not null, count integer not null, order_price integer not null, item_id bigint, order_id bigint, primary key (order_item_id) );2022-09-02 17:06:18.042 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : create table orders ( order_id bigint not null, order_date timestamp, status varchar(255), delivery_id bigint, member_id bigint, primary key (order_id) )2022-09-02 17:06:18.043 INFO 26936 --- [ restartedMain] p6spy : #1662105978043 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop create table orders ( order_id bigint not null, order_date timestamp, status varchar(255), delivery_id bigint, member_id bigint, primary key (order_id) ) create table orders ( order_id bigint not null, order_date timestamp, status varchar(255), delivery_id bigint, member_id bigint, primary key (order_id) );2022-09-02 17:06:18.043 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : alter table category add constraint FK2y94svpmqttx80mshyny85wqr foreign key (parent_id) references category2022-09-02 17:06:18.048 INFO 26936 --- [ restartedMain] p6spy : #1662105978048 | took 4ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop alter table category add constraint FK2y94svpmqttx80mshyny85wqr foreign key (parent_id) references category alter table category add constraint FK2y94svpmqttx80mshyny85wqr foreign key (parent_id) references category;2022-09-02 17:06:18.048 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : alter table category_item add constraint FKu8b4lwqutcdq3363gf6mlujq foreign key (item_id) references item2022-09-02 17:06:18.049 INFO 26936 --- [ restartedMain] p6spy : #1662105978049 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop alter table category_item add constraint FKu8b4lwqutcdq3363gf6mlujq foreign key (item_id) references item alter table category_item add constraint FKu8b4lwqutcdq3363gf6mlujq foreign key (item_id) references item;2022-09-02 17:06:18.049 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : alter table category_item add constraint FKcq2n0opf5shyh84ex1fhukcbh foreign key (category_id) references category2022-09-02 17:06:18.050 INFO 26936 --- [ restartedMain] p6spy : #1662105978050 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop alter table category_item add constraint FKcq2n0opf5shyh84ex1fhukcbh foreign key (category_id) references category alter table category_item add constraint FKcq2n0opf5shyh84ex1fhukcbh foreign key (category_id) references category;2022-09-02 17:06:18.050 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : alter table order_item add constraint FKija6hjjiit8dprnmvtvgdp6ru foreign key (item_id) references item2022-09-02 17:06:18.052 INFO 26936 --- [ restartedMain] p6spy : #1662105978052 | took 1ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop alter table order_item add constraint FKija6hjjiit8dprnmvtvgdp6ru foreign key (item_id) references item alter table order_item add constraint FKija6hjjiit8dprnmvtvgdp6ru foreign key (item_id) references item;2022-09-02 17:06:18.052 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : alter table order_item add constraint FKt4dc2r9nbvbujrljv3e23iibt foreign key (order_id) references orders2022-09-02 17:06:18.053 INFO 26936 --- [ restartedMain] p6spy : #1662105978053 | took 1ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop alter table order_item add constraint FKt4dc2r9nbvbujrljv3e23iibt foreign key (order_id) references orders alter table order_item add constraint FKt4dc2r9nbvbujrljv3e23iibt foreign key (order_id) references orders;2022-09-02 17:06:18.053 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : alter table orders add constraint FKtkrur7wg4d8ax0pwgo0vmy20c foreign key (delivery_id) references delivery2022-09-02 17:06:18.055 INFO 26936 --- [ restartedMain] p6spy : #1662105978055 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop alter table orders add constraint FKtkrur7wg4d8ax0pwgo0vmy20c foreign key (delivery_id) references delivery alter table orders add constraint FKtkrur7wg4d8ax0pwgo0vmy20c foreign key (delivery_id) references delivery;2022-09-02 17:06:18.055 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : alter table orders add constraint FKpktxwhj3x9m4gth5ff6bkqgeb foreign key (member_id) references member2022-09-02 17:06:18.055 INFO 26936 --- [ restartedMain] p6spy : #1662105978055 | took 0ms | statement | connection 3| url jdbc:h2:tcp://localhost/~/jpashop alter table orders add constraint FKpktxwhj3x9m4gth5ff6bkqgeb foreign key (member_id) references member alter table orders add constraint FKpktxwhj3x9m4gth5ff6bkqgeb foreign key (member_id) references member;2022-09-02 17:06:18.056 INFO 26936 --- [ restartedMain] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]2022-09-02 17:06:18.063 TRACE 26936 --- [ restartedMain] o.h.type.spi.TypeConfiguration$Scope : Handling #sessionFactoryCreated from [org.hibernate.internal.SessionFactoryImpl@4ea503a7] for TypeConfiguration2022-09-02 17:06:18.064 INFO 26936 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'Init1class jpabook.jpashop.InitDb$InitService2022-09-02 17:06:18.220 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.239 INFO 26936 --- [ restartedMain] p6spy : #1662105978239 | took 10ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.264 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.264 INFO 26936 --- [ restartedMain] p6spy : #1662105978264 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.265 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.266 INFO 26936 --- [ restartedMain] p6spy : #1662105978266 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.266 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.266 INFO 26936 --- [ restartedMain] p6spy : #1662105978266 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.267 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.269 INFO 26936 --- [ restartedMain] p6spy : #1662105978269 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.271 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.272 INFO 26936 --- [ restartedMain] p6spy : #1662105978272 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.272 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.272 INFO 26936 --- [ restartedMain] p6spy : #1662105978272 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.299 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into member (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?)2022-09-02 17:06:18.301 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [서울]2022-09-02 17:06:18.301 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [VARCHAR] - [1]2022-09-02 17:06:18.301 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [VARCHAR] - [1111]2022-09-02 17:06:18.301 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [userA]2022-09-02 17:06:18.302 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [BIGINT] - [1]2022-09-02 17:06:18.304 INFO 26936 --- [ restartedMain] p6spy : #1662105978304 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopinsert into member (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?)insert into member (city, street, zipcode, name, member_id) values ('서울', '1', '1111', 'userA', 1);2022-09-02 17:06:18.305 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?)2022-09-02 17:06:18.305 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [JPA1 BOOK]2022-09-02 17:06:18.306 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [INTEGER] - [10000]2022-09-02 17:06:18.306 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [INTEGER] - [100]2022-09-02 17:06:18.306 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [null]2022-09-02 17:06:18.307 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [null]2022-09-02 17:06:18.307 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [2]2022-09-02 17:06:18.307 INFO 26936 --- [ restartedMain] p6spy : #1662105978307 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopinsert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?)insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values ('JPA1 BOOK', 10000, 100, NULL, NULL, 'B', 2);2022-09-02 17:06:18.307 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?)2022-09-02 17:06:18.308 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [JPA2 BOOK]2022-09-02 17:06:18.308 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [INTEGER] - [20000]2022-09-02 17:06:18.308 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [INTEGER] - [100]2022-09-02 17:06:18.308 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [null]2022-09-02 17:06:18.308 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [null]2022-09-02 17:06:18.308 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [3]2022-09-02 17:06:18.308 INFO 26936 --- [ restartedMain] p6spy : #1662105978308 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopinsert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?)insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values ('JPA2 BOOK', 20000, 100, NULL, NULL, 'B', 3);2022-09-02 17:06:18.309 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into delivery (city, street, zipcode, delivery_id) values (?, ?, ?, ?)2022-09-02 17:06:18.310 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [서울]2022-09-02 17:06:18.310 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [VARCHAR] - [1]2022-09-02 17:06:18.310 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [VARCHAR] - [1111]2022-09-02 17:06:18.310 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [BIGINT] - [5]2022-09-02 17:06:18.310 INFO 26936 --- [ restartedMain] p6spy : #1662105978310 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopinsert into delivery (city, street, zipcode, delivery_id) values (?, ?, ?, ?)insert into delivery (city, street, zipcode, delivery_id) values ('서울', '1', '1111', 5);2022-09-02 17:06:18.311 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into orders (delivery_id, member_id, order_date, status, order_id) values (?, ?, ?, ?, ?)2022-09-02 17:06:18.311 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [5]2022-09-02 17:06:18.311 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [1]2022-09-02 17:06:18.311 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [TIMESTAMP] - [2022-09-02T17:06:18.266087900]2022-09-02 17:06:18.312 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [ORDER]2022-09-02 17:06:18.313 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [BIGINT] - [4]2022-09-02 17:06:18.314 INFO 26936 --- [ restartedMain] p6spy : #1662105978314 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopinsert into orders (delivery_id, member_id, order_date, status, order_id) values (?, ?, ?, ?, ?)insert into orders (delivery_id, member_id, order_date, status, order_id) values (5, 1, '2022-09-02T17:06:18.266+0900', 'ORDER', 4);2022-09-02 17:06:18.314 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?)2022-09-02 17:06:18.315 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [INTEGER] - [1]2022-09-02 17:06:18.315 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [2]2022-09-02 17:06:18.315 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [BIGINT] - [4]2022-09-02 17:06:18.315 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [INTEGER] - [10000]2022-09-02 17:06:18.315 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [BIGINT] - [6]2022-09-02 17:06:18.316 INFO 26936 --- [ restartedMain] p6spy : #1662105978316 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopinsert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?)insert into order_item (count, item_id, order_id, order_price, order_item_id) values (1, 2, 4, 10000, 6);2022-09-02 17:06:18.316 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?)2022-09-02 17:06:18.316 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [INTEGER] - [2]2022-09-02 17:06:18.317 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [3]2022-09-02 17:06:18.317 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [BIGINT] - [4]2022-09-02 17:06:18.317 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [INTEGER] - [20000]2022-09-02 17:06:18.317 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [BIGINT] - [7]2022-09-02 17:06:18.317 INFO 26936 --- [ restartedMain] p6spy : #1662105978317 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopinsert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?)insert into order_item (count, item_id, order_id, order_price, order_item_id) values (2, 3, 4, 20000, 7);2022-09-02 17:06:18.319 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : update item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=?2022-09-02 17:06:18.320 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [JPA1 BOOK]2022-09-02 17:06:18.320 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [INTEGER] - [10000]2022-09-02 17:06:18.321 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [INTEGER] - [99]2022-09-02 17:06:18.321 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [null]2022-09-02 17:06:18.321 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [null]2022-09-02 17:06:18.321 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [2]2022-09-02 17:06:18.322 INFO 26936 --- [ restartedMain] p6spy : #1662105978322 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopupdate item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=?update item set name='JPA1 BOOK', price=10000, stock_quantity=99, author=NULL, isbn=NULL where item_id=2;2022-09-02 17:06:18.324 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : update item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=?2022-09-02 17:06:18.324 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [JPA2 BOOK]2022-09-02 17:06:18.325 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [INTEGER] - [20000]2022-09-02 17:06:18.325 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [INTEGER] - [98]2022-09-02 17:06:18.325 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [null]2022-09-02 17:06:18.325 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [null]2022-09-02 17:06:18.325 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [3]2022-09-02 17:06:18.325 INFO 26936 --- [ restartedMain] p6spy : #1662105978325 | took 0ms | statement | connection 4| url jdbc:h2:tcp://localhost/~/jpashopupdate item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=?update item set name='JPA2 BOOK', price=20000, stock_quantity=98, author=NULL, isbn=NULL where item_id=3;2022-09-02 17:06:18.329 INFO 26936 --- [ restartedMain] p6spy : #1662105978329 | took 0ms | commit | connection 4| url jdbc:h2:tcp://localhost/~/jpashop;2022-09-02 17:06:18.331 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.332 INFO 26936 --- [ restartedMain] p6spy : #1662105978332 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.332 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.332 INFO 26936 --- [ restartedMain] p6spy : #1662105978332 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.332 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.333 INFO 26936 --- [ restartedMain] p6spy : #1662105978333 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.333 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.333 INFO 26936 --- [ restartedMain] p6spy : #1662105978333 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.334 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.334 INFO 26936 --- [ restartedMain] p6spy : #1662105978334 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.334 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.335 INFO 26936 --- [ restartedMain] p6spy : #1662105978335 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.336 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : call next value for hibernate_sequence2022-09-02 17:06:18.337 INFO 26936 --- [ restartedMain] p6spy : #1662105978337 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopcall next value for hibernate_sequencecall next value for hibernate_sequence;2022-09-02 17:06:18.338 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into member (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?)2022-09-02 17:06:18.339 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [진주]2022-09-02 17:06:18.339 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [VARCHAR] - [2]2022-09-02 17:06:18.340 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [VARCHAR] - [2222]2022-09-02 17:06:18.340 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [userB]2022-09-02 17:06:18.340 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [BIGINT] - [8]2022-09-02 17:06:18.340 INFO 26936 --- [ restartedMain] p6spy : #1662105978340 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopinsert into member (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?)insert into member (city, street, zipcode, name, member_id) values ('진주', '2', '2222', 'userB', 8);2022-09-02 17:06:18.340 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?)2022-09-02 17:06:18.341 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [SPRING1 BOOK]2022-09-02 17:06:18.341 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [INTEGER] - [20000]2022-09-02 17:06:18.341 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [INTEGER] - [200]2022-09-02 17:06:18.341 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [null]2022-09-02 17:06:18.341 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [null]2022-09-02 17:06:18.341 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [9]2022-09-02 17:06:18.342 INFO 26936 --- [ restartedMain] p6spy : #1662105978342 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopinsert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?)insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values ('SPRING1 BOOK', 20000, 200, NULL, NULL, 'B', 9);2022-09-02 17:06:18.342 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?)2022-09-02 17:06:18.342 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [SPRING2 BOOK]2022-09-02 17:06:18.342 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [INTEGER] - [40000]2022-09-02 17:06:18.342 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [INTEGER] - [300]2022-09-02 17:06:18.343 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [null]2022-09-02 17:06:18.343 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [null]2022-09-02 17:06:18.343 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [10]2022-09-02 17:06:18.343 INFO 26936 --- [ restartedMain] p6spy : #1662105978343 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopinsert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values (?, ?, ?, ?, ?, 'B', ?)insert into item (name, price, stock_quantity, author, isbn, dtype, item_id) values ('SPRING2 BOOK', 40000, 300, NULL, NULL, 'B', 10);2022-09-02 17:06:18.344 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into delivery (city, street, zipcode, delivery_id) values (?, ?, ?, ?)2022-09-02 17:06:18.344 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [진주]2022-09-02 17:06:18.344 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [VARCHAR] - [2]2022-09-02 17:06:18.344 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [VARCHAR] - [2222]2022-09-02 17:06:18.344 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [BIGINT] - [12]2022-09-02 17:06:18.345 INFO 26936 --- [ restartedMain] p6spy : #1662105978345 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopinsert into delivery (city, street, zipcode, delivery_id) values (?, ?, ?, ?)insert into delivery (city, street, zipcode, delivery_id) values ('진주', '2', '2222', 12);2022-09-02 17:06:18.345 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into orders (delivery_id, member_id, order_date, status, order_id) values (?, ?, ?, ?, ?)2022-09-02 17:06:18.345 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [12]2022-09-02 17:06:18.346 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [8]2022-09-02 17:06:18.346 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [TIMESTAMP] - [2022-09-02T17:06:18.333837100]2022-09-02 17:06:18.346 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [ORDER]2022-09-02 17:06:18.346 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [BIGINT] - [11]2022-09-02 17:06:18.347 INFO 26936 --- [ restartedMain] p6spy : #1662105978347 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopinsert into orders (delivery_id, member_id, order_date, status, order_id) values (?, ?, ?, ?, ?)insert into orders (delivery_id, member_id, order_date, status, order_id) values (12, 8, '2022-09-02T17:06:18.333+0900', 'ORDER', 11);2022-09-02 17:06:18.348 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?)2022-09-02 17:06:18.348 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [INTEGER] - [3]2022-09-02 17:06:18.348 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [9]2022-09-02 17:06:18.348 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [BIGINT] - [11]2022-09-02 17:06:18.348 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [INTEGER] - [20000]2022-09-02 17:06:18.348 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [BIGINT] - [13]2022-09-02 17:06:18.348 INFO 26936 --- [ restartedMain] p6spy : #1662105978348 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopinsert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?)insert into order_item (count, item_id, order_id, order_price, order_item_id) values (3, 9, 11, 20000, 13);2022-09-02 17:06:18.349 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : insert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?)2022-09-02 17:06:18.349 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [INTEGER] - [4]2022-09-02 17:06:18.349 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [BIGINT] - [10]2022-09-02 17:06:18.349 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [BIGINT] - [11]2022-09-02 17:06:18.349 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [INTEGER] - [40000]2022-09-02 17:06:18.349 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [BIGINT] - [14]2022-09-02 17:06:18.350 INFO 26936 --- [ restartedMain] p6spy : #1662105978350 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopinsert into order_item (count, item_id, order_id, order_price, order_item_id) values (?, ?, ?, ?, ?)insert into order_item (count, item_id, order_id, order_price, order_item_id) values (4, 10, 11, 40000, 14);2022-09-02 17:06:18.350 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : update item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=?2022-09-02 17:06:18.352 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [SPRING1 BOOK]2022-09-02 17:06:18.352 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [INTEGER] - [20000]2022-09-02 17:06:18.352 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [INTEGER] - [197]2022-09-02 17:06:18.352 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [null]2022-09-02 17:06:18.353 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [null]2022-09-02 17:06:18.353 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [9]2022-09-02 17:06:18.353 INFO 26936 --- [ restartedMain] p6spy : #1662105978353 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopupdate item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=?update item set name='SPRING1 BOOK', price=20000, stock_quantity=197, author=NULL, isbn=NULL where item_id=9;2022-09-02 17:06:18.354 DEBUG 26936 --- [ restartedMain] org.hibernate.SQL : update item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=?2022-09-02 17:06:18.354 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [SPRING2 BOOK]2022-09-02 17:06:18.354 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [INTEGER] - [40000]2022-09-02 17:06:18.354 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [INTEGER] - [296]2022-09-02 17:06:18.354 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [null]2022-09-02 17:06:18.354 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [null]2022-09-02 17:06:18.355 TRACE 26936 --- [ restartedMain] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [BIGINT] - [10]2022-09-02 17:06:18.355 INFO 26936 --- [ restartedMain] p6spy : #1662105978355 | took 0ms | statement | connection 5| url jdbc:h2:tcp://localhost/~/jpashopupdate item set name=?, price=?, stock_quantity=?, author=?, isbn=? where item_id=?update item set name='SPRING2 BOOK', price=40000, stock_quantity=296, author=NULL, isbn=NULL where item_id=10;2022-09-02 17:06:18.355 INFO 26936 --- [ restartedMain] p6spy : #1662105978355 | took 0ms | commit | connection 5| url jdbc:h2:tcp://localhost/~/jpashop;2022-09-02 17:06:18.465 WARN 26936 --- [ restartedMain] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning2022-09-02 17:06:18.669 INFO 26936 --- [ restartedMain] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page: class path resource [static/index.html]2022-09-02 17:06:18.916 INFO 26936 --- [ restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 357292022-09-02 17:06:18.966 INFO 26936 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path ''2022-09-02 17:06:18.979 INFO 26936 --- [ restartedMain] jpabook.jpashop.JpaShopApplication : Started JpaShopApplication in 6.365 seconds (JVM running for 7.151)2022-09-02 17:07:07.896 INFO 26936 --- [nio-8080-exec-2] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'2022-09-02 17:07:07.897 INFO 26936 --- [nio-8080-exec-2] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'2022-09-02 17:07:07.898 INFO 26936 --- [nio-8080-exec-2] o.s.web.servlet.DispatcherServlet : Completed initialization in 1 ms2022-09-02 17:07:07.956 ERROR 26936 --- [nio-8080-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root causejava.lang.NullPointerException: null at jpabook.jpashop.api.OrderSimpleApiController.ordersV1(OrderSimpleApiController.java:30) ~[main/:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-5.3.22.jar:5.3.22] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) ~[spring-web-5.3.22.jar:5.3.22] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) ~[spring-webmvc-5.3.22.jar:5.3.22] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.22.jar:5.3.22] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.22.jar:5.3.22] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.22.jar:5.3.22] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1070) ~[spring-webmvc-5.3.22.jar:5.3.22] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) ~[spring-webmvc-5.3.22.jar:5.3.22] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.22.jar:5.3.22] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.3.22.jar:5.3.22] at javax.servlet.http.HttpServlet.service(HttpServlet.java:655) ~[tomcat-embed-core-9.0.65.jar:4.0.FR] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.22.jar:5.3.22] at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) ~[tomcat-embed-core-9.0.65.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.65.jar:9.0.65] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.3.22.jar:5.3.22] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.22.jar:5.3.22] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.3.22.jar:5.3.22] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.22.jar:5.3.22] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.22.jar:5.3.22] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.22.jar:5.3.22] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.65.jar:9.0.65] at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na]
-
미해결파이썬 알고리즘 문제풀이 입문(코딩테스트 대비)
DFS 함수 탈출
안녕하세요 선생님 강의 열심히 듣고 있는 학생입니다 ! 강의 듣고 나서 복습하다가 아래와 같이 풀었는데요.이 경우에 sum과 total-sum 조건을 비교하는 부분을 한 번만 통과하면 바로 DFS함수를 끝내는 방법이 있을까요?return을 해도 계속 통과를 해서 질문 드립니다 ! 감사합니다. def DFS(L, sum): global answer if L==len(nums): if sum == total-sum: answer = "YES" else: DFS(L+1, sum+nums[L]) DFS(L+1, sum) if __name__ == "__main__": n = int(input()) nums = list(map(int, input().split())) answer = "NO" total = sum(nums) DFS(0, 0) print(answer)
-
미해결ESXi 가상 인프라 구축과 보안 솔루션을 활용한 이상징후 탐지 모니터링
pfsense 룰 설정 시 오류 발생 관련하여 문의드립니다.
안녕하세요.pfsense 룰 설정 시 오류 발생 관련하여 문의드립니다.발생되는 오류 현황호스트 PC에서 pfsense 관리 페이지에서 룰 설정 시 호스트 PC에서 관리 페이지 접근이 불가한 상황 발생되며, pfsense 터미널에서 "pfctl -d" 명령어 입력 시 관리 페이지 접근이 가능함(아무 룰 설정 시 접근이 불가(호스트 PC에서 pfsense 관리 페이지 접근 관련된 룰 설정이 아니여도 접근이 안됨)) ("pfctl -d" 명령어는 정책 비활성화인 것으로 추정)
-
미해결실전! 스프링 부트와 JPA 활용1 - 웹 애플리케이션 개발
orderForm Post
질문1.orderForm을 Post로 보냈는데 왜 content type이 text/html 인가요?? application/x-www-form-urlencoded 아닌가요? 그리고 Form 데이터는 어디있나요 보이지 않습니다.2.@RequestParam은 form형식의 데이터나 url형식으로 받아야하는데 어떻게 "memberId"처럼 필드값을 바로 받을 수 있나요?? 구글링을 해봐도 잘 안나옵니다. 혹시 키워드 가르쳐주시면 직접 찾아보겠습니다. Controller@PostMapping("/order") public String order(@RequestParam("memberId") Long memberId, @RequestParam("itemId") Long itemId, @RequestParam("count") int count){ orderService.order(memberId, itemId, count); return "redirect:/orders"; }
-
미해결비전공자를 위한 진짜 입문 올인원 개발 부트캠프
어처구니 없는 질문인건 알지만..
메인페이지 에서는 이미지에 /를 삽입해도 들어가고 / 을 안해도 이미지가 정상적으로 출력이되는데 왜 상세페이지에서는 /가 없으면 이미지가 출력이 안되는지 궁금합니다. 이미지 소스를 안에 봐도 똑같이 local3000/images/products/~ 이렇게 되잇는데 왜 어떤곳에서는 들어가지 않고 어떤 곳에서는 들어가는지 궁금합니다밑에 분에 저랑 비슷한 질문에 답변 하셧을때 답변을 실제로 react에서는 public 폴더에 파일들을 넣게 되면 절대 경로(/를 붙여서 시작하는 경로)와 상대 경로(/를 안붙인 경로)가 동일한 위치를 가르키게 됩니다.즉 두 경우 모두 사용될 수 있습니다 :) 저도 수업을 진행하면서 저도 혼동해서 사용한 것 같네요 이렇게 답변을 하셧는데 둘다 public 안에 잇는 image 폴더를 가져와서 둘다 생략이 가능해야 하는 부분 아닌가요!? 궁금합니다!
-
미해결안드로이드 모바일 앱 모의해킹과 시큐어코딩
취약한 로깅 메커니즘
취약한 로깅 메커니즘 대응 방안 중 첫번째 방안인 '앱 배포시 사용되는 로그관련 코드를 제거한다'는 배포할 때 로그 관련 코드 제거하는 것이 어렵다고 하셨는데 어떤 부분이 왜 어려운지 궁금합니다!
-
미해결스프링 시큐리티
invalidSessionUrl
현재 부트 5.7버전을 사용하면서 SecurityFilterChain을 빈으로 등록하면서 기본 API들을 구현하고 있는데 sessionManagement() 부분에서 invalidSessionUrl 메소드 자체가 없어진거 같은데 5.7 이후부터는 이 메소드를 활용하지 못하는건가요?
