• 카테고리

    질문 & 답변
  • 세부 분야

    백엔드

  • 해결 여부

    미해결

중복_회원_예외 오류 질문

23.01.05 18:29 작성 조회수 816

0

제 멤버 서비스 코드

"C:\Program Files\Amazon Corretto\jdk11.0.16_9\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2022.2.1\lib\idea_rt.jar=9425:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2022.2.1\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2022.2.1\lib\idea_rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2022.2.1\plugins\junit\lib\junit5-rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2022.2.1\plugins\junit\lib\junit-rt.jar;C:\Users\pmsuk\Desktop\jpashop\jpashop\out\test\classes;C:\Users\pmsuk\Desktop\jpashop\jpashop\out\test\resources;C:\Users\pmsuk\Desktop\jpashop\jpashop\out\production\classes;C:\Users\pmsuk\Desktop\jpashop\jpashop\out\production\resources;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-data-jpa\2.7.7\bc28a10c4fc39f01e9233db84f132eb4b8c53390\spring-boot-starter-data-jpa-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-thymeleaf\2.7.7\5d80dd18f2f1945e3dc568fa30ac106e329a4bde\spring-boot-starter-thymeleaf-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-validation\2.7.7\b29d0346e75f3d508d32377af0c9694ef5ab5714\spring-boot-starter-validation-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-web\2.7.7\b551cc70136739c9834ed278c25d24efa8abe66e\spring-boot-starter-web-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-devtools\2.7.7\b99143fddbbb93af91875a00a59e4b9847c49113\spring-boot-devtools-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.github.gavlyukovskiy\p6spy-spring-boot-starter\1.8.1\688ddcdba46c6f38353b02443ca17db0fbb1f93\p6spy-spring-boot-starter-1.8.1.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-test\2.7.7\204419b38438a398fe43bed95fb835d4ddeb2d2e\spring-boot-starter-test-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.junit.vintage\junit-vintage-engine\5.8.2\64dde404f2db8b0e2ec6a53d31f4a076e298b1d1\junit-vintage-engine-5.8.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-aop\2.7.7\68062ada4148e4914a3b96046030fbcd5e0a62fa\spring-boot-starter-aop-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-jdbc\2.7.7\404134263ab70e1f41ecc2d0bbf6446f9afc3e02\spring-boot-starter-jdbc-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\jakarta.transaction\jakarta.transaction-api\1.3.3\c4179d48720a1e87202115fbed6089bdc4195405\jakarta.transaction-api-1.3.3.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\jakarta.persistence\jakarta.persistence-api\2.2.3\8f6ea5daedc614f07a3654a455660145286f024e\jakarta.persistence-api-2.2.3.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.hibernate\hibernate-core\5.6.14.Final\71e407089b71ed7c6e99385fd851c308fed7be44\hibernate-core-5.6.14.Final.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-jpa\2.7.6\8d0414f5cca5e31509943cd5f97cacdddd7c7384\spring-data-jpa-2.7.6.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-aspects\5.3.24\e97d36c3e516d3dd0579437428b6e26902da0c88\spring-aspects-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter\2.7.7\dd06582c2b6b911bdf1be4f3a40e7b63a5ae75d7\spring-boot-starter-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.thymeleaf\thymeleaf-spring5\3.0.15.RELEASE\7170e1bcd1588d38c139f7048ebcc262676441c3\thymeleaf-spring5-3.0.15.RELEASE.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.thymeleaf.extras\thymeleaf-extras-java8time\3.0.4.RELEASE\36e7175ddce36c486fff4578b5af7bb32f54f5df\thymeleaf-extras-java8time-3.0.4.RELEASE.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-el\9.0.70\37244bed53a3e5cca5b39611fded5274da79a281\tomcat-embed-el-9.0.70.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.hibernate.validator\hibernate-validator\6.2.5.Final\a68959c06e5f8ff45faff469aa16f232c04af620\hibernate-validator-6.2.5.Final.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-json\2.7.7\3a666cbb67c398d00ff8e372b8a49c2f86d841f\spring-boot-starter-json-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-tomcat\2.7.7\2110ccddc766217bbc3e9194ee637d4ef32e58e9\spring-boot-starter-tomcat-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-webmvc\5.3.24\33d2187c2bf1cb2c222bd1cc18b618736babcf3d\spring-webmvc-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-web\5.3.24\d89bbcaabb1ff247a089875cbc4211bfe96c9a59\spring-web-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-autoconfigure\2.7.7\8da88afca89ce4b1ab5762e6ca35e1bad196ad47\spring-boot-autoconfigure-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot\2.7.7\1fa59eb2fce0363bdf152d7660b784257bfac99b\spring-boot-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.github.gavlyukovskiy\datasource-decorator-spring-boot-autoconfigure\1.8.1\72b16dae8f3855d80c91a78ad5c2cacbf715cdcd\datasource-decorator-spring-boot-autoconfigure-1.8.1.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\p6spy\p6spy\3.9.0\7fedf78cc1e53a623a7b36d1f2705790836400aa\p6spy-3.9.0.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.junit.jupiter\junit-jupiter\5.8.2\5a817b1e63f1217e5c586090c45e681281f097ad\junit-jupiter-5.8.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-test-autoconfigure\2.7.7\ae1417f8f60f4ca378568d965e69a7f043e65397\spring-boot-test-autoconfigure-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-test\2.7.7\aff19a025de03eaa2f465dd5c9bc5fe128da69c9\spring-boot-test-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.jayway.jsonpath\json-path\2.7.0\f9d7d9659f2694e61142046ff8a216c047f263e8\json-path-2.7.0.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\jakarta.xml.bind\jakarta.xml.bind-api\2.3.3\48e3b9cfc10752fba3521d6511f4165bea951801\jakarta.xml.bind-api-2.3.3.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.assertj\assertj-core\3.22.0\c300c0c6a24559f35fa0bd3a5472dc1edcd0111e\assertj-core-3.22.0.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.hamcrest\hamcrest\2.2\1820c0968dba3a11a1b30669bb1f01978a91dedc\hamcrest-2.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.mockito\mockito-junit-jupiter\4.5.1\f81fb60bd69b3a6e5537ae23b883326f01632a61\mockito-junit-jupiter-4.5.1.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.mockito\mockito-core\4.5.1\ed456e623e5afc6f4cee3ae58144e5c45f3b3bf\mockito-core-4.5.1.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.skyscreamer\jsonassert\1.5.1\6d842d0faf4cf6725c509a5e5347d319ee0431c3\jsonassert-1.5.1.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-test\5.3.24\dcad3d7fa11fe832005667ab074a54a9546a59ac\spring-test-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-core\5.3.24\d095c329f30baf2b6d44eccbd2352d7a2f840c72\spring-core-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.xmlunit\xmlunit-core\2.9.0\8959725d90eecfee28acd7110e2bb8460285d876\xmlunit-core-2.9.0.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.junit.platform\junit-platform-engine\1.8.2\b737de09f19864bd136805c84df7999a142fec29\junit-platform-engine-1.8.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\junit\junit\4.13.2\8ac9e16d933b6fb43bc7f576336b8f4d7eb5ba12\junit-4.13.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.apiguardian\apiguardian-api\1.1.2\a231e0d844d2721b0fa1b238006d15c6ded6842a\apiguardian-api-1.1.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-aop\5.3.24\efd01bc1048a2e1b6a7442fbd78170bc02c342b7\spring-aop-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.aspectj\aspectjweaver\1.9.7\158f5c255cd3e4408e795b79f7c3fbae9b53b7ca\aspectjweaver-1.9.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-jdbc\5.3.24\909c19ab470a59b9fd23177d26b8e880733b15d4\spring-jdbc-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.zaxxer\HikariCP\4.0.3\107cbdf0db6780a065f895ae9d8fbf3bb0e1c21f\HikariCP-4.0.3.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\jaxb-runtime\2.3.7\ebcde6a44159eb9e3db721dfe6b45f26e6272341\jaxb-runtime-2.3.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.hibernate.common\hibernate-commons-annotations\5.1.2.Final\e59ffdbc6ad09eeb33507b39ffcf287679a498c8\hibernate-commons-annotations-5.1.2.Final.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.jboss.logging\jboss-logging\3.4.3.Final\c4bd7e12a745c0e7f6cf98c45cdcdf482fd827ea\jboss-logging-3.4.3.Final.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\net.bytebuddy\byte-buddy\1.12.20\6ec3b8bccc4c988790d8cde5baad3b95609ef136\byte-buddy-1.12.20.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\antlr\antlr\2.7.7\83cd2cd674a217ade95a4bb83a8a14f351f48bd0\antlr-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.jboss\jandex\2.4.2.Final\1e1c385990b258ff1a24c801e84aebbacf70eb39\jandex-2.4.2.Final.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.fasterxml\classmate\1.5.1\3fe0bed568c62df5e89f4f174c101eab25345b6c\classmate-1.5.1.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-orm\5.3.24\256e029c2d8200294fe7fb5352ca2d1d7310dcad\spring-orm-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-commons\2.7.6\e3d15a8f4d5ef0d2323569445c66903d0188cb68\spring-data-commons-2.7.6.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-context\5.3.24\e48634d7b8f40d4d0fe978830be0247bfc2ff2cd\spring-context-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-tx\5.3.24\175a2157fce17669af6d4db1d094cb4baaa5c8fd\spring-tx-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-beans\5.3.24\e487ea6de09b9a7c36548028feeafa511a593532\spring-beans-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.slf4j\slf4j-api\1.7.36\6c62681a2f655b49963a5983b8b0950a6120ae14\slf4j-api-1.7.36.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-logging\2.7.7\c71bdb4e93d75b535fef277606868d1d6934c35\spring-boot-starter-logging-2.7.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\jakarta.annotation\jakarta.annotation-api\1.3.5\59eb84ee0d616332ff44aba065f3888cf002cd2d\jakarta.annotation-api-1.3.5.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.yaml\snakeyaml\1.30\8fde7fe2586328ac3c68db92045e1c8759125000\snakeyaml-1.30.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.thymeleaf\thymeleaf\3.0.15.RELEASE\13e3296a03d8a597b734d832ed8656139bf9cdd8\thymeleaf-3.0.15.RELEASE.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\jakarta.validation\jakarta.validation-api\2.0.2\5eacc6522521f7eacb081f95cee1e231648461e7\jakarta.validation-api-2.0.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jsr310\2.13.4\e6d820112871f33cd94a1dcc54eef58874753b5\jackson-datatype-jsr310-2.13.4.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.module\jackson-module-parameter-names\2.13.4\858ccf6624b5fac6044813e845063edb6a62cf37\jackson-module-parameter-names-2.13.4.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jdk8\2.13.4\557dbba5d8dfc7b7f944c58fe084109afcb5670b\jackson-datatype-jdk8-2.13.4.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-databind\2.13.4.2\325c06bdfeb628cfb80ebaaf1a26cc1eb558a585\jackson-databind-2.13.4.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-websocket\9.0.70\3dbd48222828d4123b74abb3664eb84c388e9832\tomcat-embed-websocket-9.0.70.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-core\9.0.70\517f236dc4e45ecec94d8bf1c7037f952ad1e316\tomcat-embed-core-9.0.70.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-expression\5.3.24\ae7410418e7b4bd27a01e3fb1c2fed35b2bc1e84\spring-expression-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.junit.jupiter\junit-jupiter-params\5.8.2\ddeafe92fc263f895bfb73ffeca7fd56e23c2cce\junit-jupiter-params-5.8.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.junit.jupiter\junit-jupiter-api\5.8.2\4c21029217adf07e4c0d0c5e192b6bf610c94bdc\junit-jupiter-api-5.8.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\net.minidev\json-smart\2.4.8\7c62f5f72ab05eb54d40e2abf0360a2fe9ea477f\json-smart-2.4.8.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\jakarta.activation\jakarta.activation-api\1.2.2\99f53adba383cb1bf7c3862844488574b559621f\jakarta.activation-api-1.2.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\net.bytebuddy\byte-buddy-agent\1.12.20\c37341e04a529c7263ff3093ecdceaa4ab39b489\byte-buddy-agent-1.12.20.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.vaadin.external.google\android-json\0.0.20131108.vaadin1\fa26d351fe62a6a17f5cda1287c1c6110dec413f\android-json-0.0.20131108.vaadin1.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.springframework\spring-jcl\5.3.24\2b30878663ceed2af07238dc54e92e5bf001438d\spring-jcl-5.3.24.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.junit.platform\junit-platform-commons\1.8.2\32c8b8617c1342376fd5af2053da6410d8866861\junit-platform-commons-1.8.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.opentest4j\opentest4j\1.2.0\28c11eb91f9b6d8e200631d46e20a7f407f2a046\opentest4j-1.2.0.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\txw2\2.3.7\55cddcac1945150e09b09b0f89d86799652eee82\txw2-2.3.7.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.sun.istack\istack-commons-runtime\3.0.12\cbbe1a62b0cc6c85972e99d52aaee350153dc530\istack-commons-runtime-3.0.12.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-classic\1.2.11\4741689214e9d1e8408b206506cbe76d1c6a7d60\logback-classic-1.2.11.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-to-slf4j\2.17.2\17dd0fae2747d9a28c67bc9534108823d2376b46\log4j-to-slf4j-2.17.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.slf4j\jul-to-slf4j\1.7.36\ed46d81cef9c412a88caef405b58f93a678ff2ca\jul-to-slf4j-1.7.36.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.attoparser\attoparser\2.0.5.RELEASE\a93ad36df9560de3a5312c1d14f69d938099fa64\attoparser-2.0.5.RELEASE.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.unbescape\unbescape\1.1.6.RELEASE\7b90360afb2b860e09e8347112800d12c12b2a13\unbescape-1.1.6.RELEASE.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-annotations\2.13.4\858c6cc78e1f08a885b1613e1d817c829df70a6e\jackson-annotations-2.13.4.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-core\2.13.4\cf934c681294b97ef6d80082faeefbe1edadf56\jackson-core-2.13.4.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\net.minidev\accessors-smart\2.4.8\6e1bee5a530caba91893604d6ab41d0edcecca9a\accessors-smart-2.4.8.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-core\1.2.11\a01230df5ca5c34540cdaa3ad5efb012f1f1f792\logback-core-1.2.11.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-api\2.17.2\f42d6afa111b4dec5d2aea0fe2197240749a4ea6\log4j-api-2.17.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.ow2.asm\asm\9.1\a99500cf6eea30535eeac6be73899d048f8d12a8\asm-9.1.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.h2database\h2\2.1.214\d5c2005c9e3279201e12d4776c948578b16bf8b2\h2-2.1.214.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.junit.jupiter\junit-jupiter-engine\5.8.2\c598b4328d2f397194d11df3b1648d68d7d990e3\junit-jupiter-engine-5.8.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\org.objenesis\objenesis\3.2\7fadf57620c8b8abdf7519533e5527367cb51f09\objenesis-3.2.jar;C:\Users\pmsuk\.gradle\caches\modules-2\files-2.1\com.sun.activation\jakarta.activation\1.2.2\74548703f9851017ce2f556066659438019e7eb5\jakarta.activation-1.2.2.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 jpabook.jpashop.service.MemberServiceTest,중복_회원_예외

18:26:27.444 [main] DEBUG org.springframework.test.context.junit4.SpringJUnit4ClassRunner - SpringJUnit4ClassRunner constructor called with [class jpabook.jpashop.service.MemberServiceTest]

18:26:27.452 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating CacheAwareContextLoaderDelegate from class [org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate]

18:26:27.463 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating BootstrapContext using constructor [public org.springframework.test.context.support.DefaultBootstrapContext(java.lang.Class,org.springframework.test.context.CacheAwareContextLoaderDelegate)]

18:26:27.512 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating TestContextBootstrapper for test class [jpabook.jpashop.service.MemberServiceTest] from class [org.springframework.boot.test.context.SpringBootTestContextBootstrapper]

18:26:27.526 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [jpabook.jpashop.service.MemberServiceTest], using SpringBootContextLoader

18:26:27.532 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [jpabook.jpashop.service.MemberServiceTest]: class path resource [jpabook/jpashop/service/MemberServiceTest-context.xml] does not exist

18:26:27.532 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [jpabook.jpashop.service.MemberServiceTest]: class path resource [jpabook/jpashop/service/MemberServiceTestContext.groovy] does not exist

18:26:27.533 [main] INFO org.springframework.test.context.support.AbstractContextLoader - Could not detect default resource locations for test class [jpabook.jpashop.service.MemberServiceTest]: no resource found for suffixes {-context.xml, Context.groovy}.

18:26:27.533 [main] INFO org.springframework.test.context.support.AnnotationConfigContextLoaderUtils - Could not detect default configuration classes for test class [jpabook.jpashop.service.MemberServiceTest]: MemberServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.

18:26:27.604 [main] DEBUG org.springframework.test.context.support.ActiveProfilesUtils - Could not find an 'annotation declaring class' for annotation type [org.springframework.test.context.ActiveProfiles] and class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.708 [main] DEBUG org.springframework.context.annotation.ClassPathScanningCandidateComponentProvider - Identified candidate component class: file [C:\Users\pmsuk\Desktop\jpashop\jpashop\out\production\classes\jpabook\jpashop\JpashopApplication.class]

18:26:27.710 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Found @SpringBootConfiguration jpabook.jpashop.JpashopApplication for test class jpabook.jpashop.service.MemberServiceTest

18:26:27.853 [main] DEBUG org.springframework.boot.test.context.SpringBootTestContextBootstrapper - @TestExecutionListeners is not present for class [jpabook.jpashop.service.MemberServiceTest]: using defaults.

18:26:27.853 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.boot.test.autoconfigure.webservices.client.MockWebServiceServerTestExecutionListener, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.event.ApplicationEventsTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener, org.springframework.test.context.event.EventPublishingTestExecutionListener]

18:26:27.875 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@4e423aa2, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@7fbdb894, org.springframework.test.context.event.ApplicationEventsTestExecutionListener@3081f72c, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@3148f668, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@6e005dc9, org.springframework.test.context.support.DirtiesContextTestExecutionListener@7ceb3185, org.springframework.test.context.transaction.TransactionalTestExecutionListener@436c81a3, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@3561c410, org.springframework.test.context.event.EventPublishingTestExecutionListener@59e32960, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@7c214cc0, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@5b67bb7e, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@609db546, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@20f5281c, org.springframework.boot.test.autoconfigure.webservices.client.MockWebServiceServerTestExecutionListener@56c4278e, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@301eda63]

18:26:27.877 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.878 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.879 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.879 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.879 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.879 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.888 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.888 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.889 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.890 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.890 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.891 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.897 [main] DEBUG org.springframework.test.context.support.AbstractDirtiesContextTestExecutionListener - Before test class: context [DefaultTestContext@21ba0741 testClass = MemberServiceTest, testInstance = [null], testMethod = [null], testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@58ce9668 testClass = MemberServiceTest, locations = '{}', classes = '{class jpabook.jpashop.JpashopApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@5609159b, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@28975c28, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@236e3f4e, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@69fb6037, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@2525ff7e, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@7c7b252e], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true]], class annotated with @DirtiesContext [false] with mode [null].

18:26:27.899 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [jpabook.jpashop.service.MemberServiceTest]

18:26:27.899 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [jpabook.jpashop.service.MemberServiceTest]

. ____ _

/\\ / ___'_ __ (_)_ _ \ \ \ \

( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \

\\/ ___)| |_)| | | | | || (_| | ) ) ) )

' |____| .__|_| |_|_| |_\__, | / / / /

=========|_|==============|___/=/_/_/_/

:: Spring Boot :: (v2.7.7)

2023-01-05 18:26:28.391 INFO 10632 --- [ main] j.jpashop.service.MemberServiceTest : Starting MemberServiceTest using Java 11.0.16.1 on jins with PID 10632 (started by pmsuk in C:\Users\pmsuk\Desktop\jpashop\jpashop)

2023-01-05 18:26:28.392 INFO 10632 --- [ main] j.jpashop.service.MemberServiceTest : No active profile set, falling back to 1 default profile: "default"

2023-01-05 18:26:29.101 INFO 10632 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.

2023-01-05 18:26:29.122 INFO 10632 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 11 ms. Found 0 JPA repository interfaces.

2023-01-05 18:26:30.114 INFO 10632 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...

2023-01-05 18:26:30.386 INFO 10632 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.

2023-01-05 18:26:30.467 INFO 10632 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]

2023-01-05 18:26:30.553 INFO 10632 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.6.14.Final

2023-01-05 18:26:30.788 INFO 10632 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}

2023-01-05 18:26:30.976 INFO 10632 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

2023-01-05 18:26:31.890 DEBUG 10632 --- [ main] org.hibernate.SQL : drop table if exists category CASCADE

2023-01-05 18:26:31.895 INFO 10632 --- [ main] p6spy : #1672910791895 | took 1ms | statement | connection 2| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists category CASCADE

drop table if exists category CASCADE ;

2023-01-05 18:26:31.896 DEBUG 10632 --- [ main] org.hibernate.SQL : drop table if exists category_item CASCADE

2023-01-05 18:26:31.896 INFO 10632 --- [ main] p6spy : #1672910791896 | took 0ms | statement | connection 2| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists category_item CASCADE

drop table if exists category_item CASCADE ;

2023-01-05 18:26:31.896 DEBUG 10632 --- [ main] org.hibernate.SQL : drop table if exists delivery CASCADE

2023-01-05 18:26:31.896 INFO 10632 --- [ main] p6spy : #1672910791896 | took 0ms | statement | connection 2| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists delivery CASCADE

drop table if exists delivery CASCADE ;

2023-01-05 18:26:31.896 DEBUG 10632 --- [ main] org.hibernate.SQL : drop table if exists item CASCADE

2023-01-05 18:26:31.896 INFO 10632 --- [ main] p6spy : #1672910791896 | took 0ms | statement | connection 2| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists item CASCADE

drop table if exists item CASCADE ;

2023-01-05 18:26:31.896 DEBUG 10632 --- [ main] org.hibernate.SQL : drop table if exists order_item CASCADE

2023-01-05 18:26:31.896 INFO 10632 --- [ main] p6spy : #1672910791896 | took 0ms | statement | connection 2| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists order_item CASCADE

drop table if exists order_item CASCADE ;

2023-01-05 18:26:31.896 DEBUG 10632 --- [ main] org.hibernate.SQL : drop table if exists orders CASCADE

2023-01-05 18:26:31.896 INFO 10632 --- [ main] p6spy : #1672910791896 | took 0ms | statement | connection 2| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists orders CASCADE

drop table if exists orders CASCADE ;

2023-01-05 18:26:31.896 DEBUG 10632 --- [ main] org.hibernate.SQL : drop sequence if exists hibernate_sequence

2023-01-05 18:26:31.897 INFO 10632 --- [ main] p6spy : #1672910791897 | took 0ms | statement | connection 2| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop sequence if exists hibernate_sequence

drop sequence if exists hibernate_sequence;

2023-01-05 18:26:31.899 DEBUG 10632 --- [ main] org.hibernate.SQL : create sequence hibernate_sequence start with 1 increment by 1

2023-01-05 18:26:31.901 INFO 10632 --- [ main] p6spy : #1672910791901 | took 1ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

create sequence hibernate_sequence start with 1 increment by 1

create sequence hibernate_sequence start with 1 increment by 1;

2023-01-05 18:26:31.901 DEBUG 10632 --- [ main] org.hibernate.SQL : create table category (category_id bigint not null, name varchar(255), parent_id bigint, primary key (category_id))

2023-01-05 18:26:31.906 INFO 10632 --- [ main] p6spy : #1672910791906 | took 4ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

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));

2023-01-05 18:26:31.906 DEBUG 10632 --- [ main] org.hibernate.SQL : create table category_item (category_id bigint not null, item_id bigint not null)

2023-01-05 18:26:31.907 INFO 10632 --- [ main] p6spy : #1672910791907 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

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);

2023-01-05 18:26:31.907 DEBUG 10632 --- [ main] org.hibernate.SQL : create table delivery (delivery_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), status varchar(255), primary key (delivery_id))

2023-01-05 18:26:31.907 INFO 10632 --- [ main] p6spy : #1672910791907 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

create table delivery (delivery_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), status varchar(255), primary key (delivery_id))

create table delivery (delivery_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), status varchar(255), primary key (delivery_id));

2023-01-05 18:26:31.908 DEBUG 10632 --- [ main] 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), primary key (item_id))

2023-01-05 18:26:31.908 INFO 10632 --- [ main] p6spy : #1672910791908 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

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), 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), primary key (item_id));

2023-01-05 18:26:31.908 DEBUG 10632 --- [ main] org.hibernate.SQL : create table order_item (order_item_id bigint not null, order_price integer not null, count integer not null, item_id bigint, order_id bigint, primary key (order_item_id))

2023-01-05 18:26:31.909 INFO 10632 --- [ main] p6spy : #1672910791909 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

create table order_item (order_item_id bigint not null, order_price integer not null, count integer not null, item_id bigint, order_id bigint, primary key (order_item_id))

create table order_item (order_item_id bigint not null, order_price integer not null, count integer not null, item_id bigint, order_id bigint, primary key (order_item_id));

2023-01-05 18:26:31.909 DEBUG 10632 --- [ main] org.hibernate.SQL : create table orders (member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), order_id bigint not null, order_date timestamp, status integer, delivery_id bigint, primary key (order_id))

2023-01-05 18:26:31.910 INFO 10632 --- [ main] p6spy : #1672910791910 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

create table orders (member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), order_id bigint not null, order_date timestamp, status integer, delivery_id bigint, primary key (order_id))

create table orders (member_id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), name varchar(255), order_id bigint not null, order_date timestamp, status integer, delivery_id bigint, primary key (order_id));

2023-01-05 18:26:31.910 DEBUG 10632 --- [ main] org.hibernate.SQL : alter table category add constraint FK2y94svpmqttx80mshyny85wqr foreign key (parent_id) references category

2023-01-05 18:26:31.923 INFO 10632 --- [ main] p6spy : #1672910791923 | took 13ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

alter table category add constraint FK2y94svpmqttx80mshyny85wqr foreign key (parent_id) references category

alter table category add constraint FK2y94svpmqttx80mshyny85wqr foreign key (parent_id) references category;

2023-01-05 18:26:31.923 DEBUG 10632 --- [ main] org.hibernate.SQL : alter table category_item add constraint FKu8b4lwqutcdq3363gf6mlujq foreign key (item_id) references item

2023-01-05 18:26:31.924 INFO 10632 --- [ main] p6spy : #1672910791924 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

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;

2023-01-05 18:26:31.924 DEBUG 10632 --- [ main] org.hibernate.SQL : alter table category_item add constraint FKcq2n0opf5shyh84ex1fhukcbh foreign key (category_id) references category

2023-01-05 18:26:31.925 INFO 10632 --- [ main] p6spy : #1672910791925 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

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;

2023-01-05 18:26:31.925 DEBUG 10632 --- [ main] org.hibernate.SQL : alter table order_item add constraint FKija6hjjiit8dprnmvtvgdp6ru foreign key (item_id) references item

2023-01-05 18:26:31.926 INFO 10632 --- [ main] p6spy : #1672910791926 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

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;

2023-01-05 18:26:31.926 DEBUG 10632 --- [ main] org.hibernate.SQL : alter table order_item add constraint FKt4dc2r9nbvbujrljv3e23iibt foreign key (order_id) references orders

2023-01-05 18:26:31.927 INFO 10632 --- [ main] p6spy : #1672910791927 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

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;

2023-01-05 18:26:31.927 DEBUG 10632 --- [ main] org.hibernate.SQL : alter table orders add constraint FKtkrur7wg4d8ax0pwgo0vmy20c foreign key (delivery_id) references delivery

2023-01-05 18:26:31.928 INFO 10632 --- [ main] p6spy : #1672910791928 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

alter table orders add constraint FKtkrur7wg4d8ax0pwgo0vmy20c foreign key (delivery_id) references delivery

alter table orders add constraint FKtkrur7wg4d8ax0pwgo0vmy20c foreign key (delivery_id) references delivery;

2023-01-05 18:26:31.928 DEBUG 10632 --- [ main] org.hibernate.SQL : alter table orders add constraint FK7r0tyht0hnavc7salwjr121tu foreign key (member_id) references orders

2023-01-05 18:26:31.928 INFO 10632 --- [ main] p6spy : #1672910791928 | took 0ms | statement | connection 3| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

alter table orders add constraint FK7r0tyht0hnavc7salwjr121tu foreign key (member_id) references orders

alter table orders add constraint FK7r0tyht0hnavc7salwjr121tu foreign key (member_id) references orders;

2023-01-05 18:26:31.931 INFO 10632 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]

2023-01-05 18:26:31.943 INFO 10632 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'

2023-01-05 18:26:32.311 WARN 10632 --- [ main] 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 warning

2023-01-05 18:26:32.638 INFO 10632 --- [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page: class path resource [static/index.html]

2023-01-05 18:26:33.058 INFO 10632 --- [ main] j.jpashop.service.MemberServiceTest : Started MemberServiceTest in 5.115 seconds (JVM running for 6.149)

2023-01-05 18:26:33.163 INFO 10632 --- [ main] o.s.t.c.transaction.TransactionContext : Began transaction (1) for test context [DefaultTestContext@21ba0741 testClass = MemberServiceTest, testInstance = jpabook.jpashop.service.MemberServiceTest@7ba623d1, testMethod = 중복_회원_예외@MemberServiceTest, testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@58ce9668 testClass = MemberServiceTest, locations = '{}', classes = '{class jpabook.jpashop.JpashopApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@5609159b, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@28975c28, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@236e3f4e, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@69fb6037, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@2525ff7e, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@7c7b252e], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]]; transaction manager [org.springframework.orm.jpa.JpaTransactionManager@6a95c2f6]; rollback [true]

2023-01-05 18:26:33.447 DEBUG 10632 --- [ main] org.hibernate.SQL : select member0_.member_id as member_i1_5_, member0_.city as city2_5_, member0_.street as street3_5_, member0_.zipcode as zipcode4_5_, member0_.name as name5_5_ from orders member0_ where member0_.name=?

2023-01-05 18:26:33.467 INFO 10632 --- [ main] p6spy : #1672910793467 | took 8ms | statement | connection 4| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

select member0_.member_id as member_i1_5_, member0_.city as city2_5_, member0_.street as street3_5_, member0_.zipcode as zipcode4_5_, member0_.name as name5_5_ from orders member0_ where member0_.name=?

select member0_.member_id as member_i1_5_, member0_.city as city2_5_, member0_.street as street3_5_, member0_.zipcode as zipcode4_5_, member0_.name as name5_5_ from orders member0_ where member0_.name='kim';

2023-01-05 18:26:33.483 DEBUG 10632 --- [ main] org.hibernate.SQL : call next value for hibernate_sequence

2023-01-05 18:26:33.485 INFO 10632 --- [ main] p6spy : #1672910793485 | took 1ms | statement | connection 4| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

call next value for hibernate_sequence

call next value for hibernate_sequence;

2023-01-05 18:26:33.535 DEBUG 10632 --- [ main] org.hibernate.SQL : insert into orders (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?)

2023-01-05 18:26:33.537 INFO 10632 --- [ main] p6spy : #1672910793537 | took 1ms | statement | connection 4| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

insert into orders (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?)

insert into orders (city, street, zipcode, name, member_id) values (NULL, NULL, NULL, 'kim', 1);

2023-01-05 18:26:33.537 WARN 10632 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 23502, SQLState: 23502

2023-01-05 18:26:33.538 ERROR 10632 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : NULL not allowed for column "ORDER_ID"; SQL statement:

insert into orders (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?) [23502-214]

2023-01-05 18:26:33.538 INFO 10632 --- [ main] o.h.e.j.b.internal.AbstractBatchImpl : HHH000010: On release of batch it still contained JDBC statements

2023-01-05 18:26:33.552 INFO 10632 --- [ main] p6spy : #1672910793552 | took 0ms | rollback | connection 4| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

;

2023-01-05 18:26:33.555 INFO 10632 --- [ main] o.s.t.c.transaction.TransactionContext : Rolled back transaction for test: [DefaultTestContext@21ba0741 testClass = MemberServiceTest, testInstance = jpabook.jpashop.service.MemberServiceTest@7ba623d1, testMethod = 중복_회원_예외@MemberServiceTest, testException = java.lang.Exception: Unexpected exception, expected<java.lang.IllegalStateException> but was<org.springframework.dao.DataIntegrityViolationException>, mergedContextConfiguration = [WebMergedContextConfiguration@58ce9668 testClass = MemberServiceTest, locations = '{}', classes = '{class jpabook.jpashop.JpashopApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@5609159b, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@28975c28, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@236e3f4e, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@69fb6037, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@2525ff7e, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@7c7b252e], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]]

java.lang.Exception: Unexpected exception, expected<java.lang.IllegalStateException> but was<org.springframework.dao.DataIntegrityViolationException>

at org.junit.internal.runners.statements.ExpectException.evaluate(ExpectException.java:30)

at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)

at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)

at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)

at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)

at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)

at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)

at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)

at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)

at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)

at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)

at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)

at org.junit.runners.ParentRunner.run(ParentRunner.java:413)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)

at org.junit.runner.JUnitCore.run(JUnitCore.java:137)

at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)

at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)

at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)

at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)

at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)

at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)

Caused by: org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement

at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:276)

at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233)

at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:551)

at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)

at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)

at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:152)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)

at jpabook.jpashop.repository.MemberRepository$$EnhancerBySpringCGLIB$$30eb9bc9.findByName(<generated>)

at jpabook.jpashop.service.MemberService.validateDuplicateMember(MemberService.java:30)

at jpabook.jpashop.service.MemberService.join(MemberService.java:24)

at jpabook.jpashop.service.MemberService$$FastClassBySpringCGLIB$$560b731b.invoke(<generated>)

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)

at jpabook.jpashop.service.MemberService$$EnhancerBySpringCGLIB$$8c1a5049.join(<generated>)

at jpabook.jpashop.service.MemberServiceTest.중복_회원_예외(MemberServiceTest.java:49)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)

at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)

at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)

at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)

at org.junit.internal.runners.statements.ExpectException.evaluate(ExpectException.java:19)

... 23 more

Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement

at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)

at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200)

at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3375)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3937)

at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107)

at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)

at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)

at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)

at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)

at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344)

at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:57)

at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)

at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1372)

at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1452)

at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649)

at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617)

at org.hibernate.query.Query.getResultList(Query.java:165)

at jpabook.jpashop.repository.MemberRepository.findByName(MemberRepository.java:33)

at jpabook.jpashop.repository.MemberRepository$$FastClassBySpringCGLIB$$97f1c501.invoke(<generated>)

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)

at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)

... 53 more

Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed for column "ORDER_ID"; SQL statement:

insert into orders (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?) [23502-214]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:508)

at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)

at org.h2.message.DbException.get(DbException.java:223)

at org.h2.message.DbException.get(DbException.java:199)

at org.h2.table.Column.validateConvertUpdateSequence(Column.java:365)

at org.h2.table.Table.convertInsertRow(Table.java:926)

at org.h2.command.dml.Insert.insertRows(Insert.java:167)

at org.h2.command.dml.Insert.update(Insert.java:135)

at org.h2.command.dml.DataChangeStatement.update(DataChangeStatement.java:74)

at org.h2.command.CommandContainer.update(CommandContainer.java:169)

at org.h2.command.Command.executeUpdate(Command.java:252)

at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:209)

at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:169)

at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)

at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)

at com.p6spy.engine.wrapper.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:94)

at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)

... 76 more

2023-01-05 18:26:33.571 INFO 10632 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'

2023-01-05 18:26:33.571 INFO 10632 --- [ionShutdownHook] .SchemaDropperImpl$DelayedDropActionImpl : HHH000477: Starting delayed evictData of schema as part of SessionFactory shut-down'

2023-01-05 18:26:33.572 DEBUG 10632 --- [ionShutdownHook] org.hibernate.SQL : drop table if exists category CASCADE

2023-01-05 18:26:33.574 INFO 10632 --- [ionShutdownHook] p6spy : #1672910793574 | took 1ms | statement | connection 5| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists category CASCADE

drop table if exists category CASCADE ;

2023-01-05 18:26:33.574 DEBUG 10632 --- [ionShutdownHook] org.hibernate.SQL : drop table if exists category_item CASCADE

2023-01-05 18:26:33.575 INFO 10632 --- [ionShutdownHook] p6spy : #1672910793575 | took 0ms | statement | connection 5| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists category_item CASCADE

drop table if exists category_item CASCADE ;

2023-01-05 18:26:33.575 DEBUG 10632 --- [ionShutdownHook] org.hibernate.SQL : drop table if exists delivery CASCADE

2023-01-05 18:26:33.575 INFO 10632 --- [ionShutdownHook] p6spy : #1672910793575 | took 0ms | statement | connection 5| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists delivery CASCADE

drop table if exists delivery CASCADE ;

2023-01-05 18:26:33.575 DEBUG 10632 --- [ionShutdownHook] org.hibernate.SQL : drop table if exists item CASCADE

2023-01-05 18:26:33.576 INFO 10632 --- [ionShutdownHook] p6spy : #1672910793576 | took 0ms | statement | connection 5| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists item CASCADE

drop table if exists item CASCADE ;

2023-01-05 18:26:33.576 DEBUG 10632 --- [ionShutdownHook] org.hibernate.SQL : drop table if exists order_item CASCADE

2023-01-05 18:26:33.576 INFO 10632 --- [ionShutdownHook] p6spy : #1672910793576 | took 0ms | statement | connection 5| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists order_item CASCADE

drop table if exists order_item CASCADE ;

2023-01-05 18:26:33.576 DEBUG 10632 --- [ionShutdownHook] org.hibernate.SQL : drop table if exists orders CASCADE

2023-01-05 18:26:33.576 INFO 10632 --- [ionShutdownHook] p6spy : #1672910793576 | took 0ms | statement | connection 5| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop table if exists orders CASCADE

drop table if exists orders CASCADE ;

2023-01-05 18:26:33.577 DEBUG 10632 --- [ionShutdownHook] org.hibernate.SQL : drop sequence if exists hibernate_sequence

2023-01-05 18:26:33.577 INFO 10632 --- [ionShutdownHook] p6spy : #1672910793577 | took 0ms | statement | connection 5| url jdbc:h2:mem:1a2e493c-75d5-4bb6-8aa3-da3d051bb280

drop sequence if exists hibernate_sequence

drop sequence if exists hibernate_sequence;

2023-01-05 18:26:33.578 INFO 10632 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...

2023-01-05 18:26:33.580 INFO 10632 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.

Process finished with exit code -1

 

어떻게 하면 좋을까요

답변 1

답변을 작성해보세요.

1

David님의 프로필

David

2023.01.06

안녕하세요. pmsuk7028님, 공식 서포터즈 David입니다.

insert into orders (city, street, zipcode, name, member_id) values (?, ?, ?, ?, ?) [23502-214]

Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed for column "ORDER_ID"; SQL statement:

orders 테이블에 데이터 삽입 중 발생한 오류로 보입니다.

Null not allowed 오류의 경우 h2 신버전을 사용할 때 발생하는 문제입니다.

아래 글 답변을 참고해 주세요:)

https://www.inflearn.com/questions/374987

감사합니다.