search

jojoldu / freelec-springboot2-webservice

1.07k stars 458 forks source link

[오류] p.190 구글, 네이버 로그인 오류 #683

Open beomth opened 3 years ago

beomth commented 3 years ago

기존에 올라온 질문이 아닌지 먼저 검색해주세요!

가장 자주 나온 제보

어떤 오류인가요?

오류설명: 신택스 오류라고 뜨는데, 어디가 잘못되었는지 잘 모르겠어요...

프로젝트 주소

Github에 오류가 난 프로젝트를 올려주세요.
Github 주소를 작성해주지 않으시면 답변해드릴수가 없어요!

오류 로그

C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\bin\java.exe "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.1.3\lib\idea_rt.jar=62043:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.1.3\bin" -Dfile.encoding=UTF-8 -classpath C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\charsets.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\access-bridge-64.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\cldrdata.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\dnsns.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\jaccess.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\localedata.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\nashorn.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunec.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunjce_provider.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunmscapi.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunpkcs11.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\zipfs.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jce.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jfr.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jsse.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\management-agent.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\resources.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\rt.jar;C:\Users\onvit\Desktop\intellijToGit\out\production\classes;C:\Users\onvit\Desktop\intellijToGit\out\production\resources;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-data-jpa\2.3.1.RELEASE\5531a4cbd506f13a0b4483ed73c2e75a03d8da46\spring-boot-starter-data-jpa-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-mustache\2.3.1.RELEASE\a8678f002dc2b870fa8fe03278b8b30f1f7e9afe\spring-boot-starter-mustache-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-oauth2-client\2.3.1.RELEASE\3c89db40f21bbaa48341398bddfde1dbe2d89803\spring-boot-starter-oauth2-client-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-web\2.3.1.RELEASE\555c4f90141cdbc7637145e413bca0d622ba6796\spring-boot-starter-web-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.h2database\h2\1.4.200\f7533fe7cb8e99c87a43d325a77b4b678ad9031a\h2-1.4.200.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.session\spring-session-jdbc\2.3.0.RELEASE\7238cdd5b37ecd0ae441f1126b2336500e3633f\spring-session-jdbc-2.3.0.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.mariadb.jdbc\mariadb-java-client\2.6.0\7ada3fc7b30ae8fa4616f47ef6d505bdda933605\mariadb-java-client-2.6.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-aop\2.3.1.RELEASE\f42e23091d29bde8d1356e45cf13ad32dae51437\spring-boot-starter-aop-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-jdbc\2.3.1.RELEASE\800b64e76588ea88761ad9108cde762204805d66\spring-boot-starter-jdbc-2.3.1.RELEASE.jar;C:\Users\onvit.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\onvit.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\onvit.gradle\caches\modules-2\files-2.1\org.hibernate\hibernate-core\5.4.17.Final\3b90ecf6fe93a27a27de9671c9fb25d03ba3def7\hibernate-core-5.4.17.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-jpa\2.3.1.RELEASE\1b5e106add569913f0c776aca62f85d8e9ca8cee\spring-data-jpa-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-aspects\5.2.7.RELEASE\eb48f4ae3e1525179e1ccd10c0e09cfe5c27b8bb\spring-aspects-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter\2.3.1.RELEASE\e0d28696fea064578cb01da346232284f922eba4\spring-boot-starter-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.samskivert\jmustache\1.15\7b3b15951d13b774c76db2f4e14d977952f8b4d8\jmustache-1.15.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-client\5.3.3.RELEASE\1cb3848eb37222f851783c9b2355e1ada3144141\spring-security-oauth2-client-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-jose\5.3.3.RELEASE\ec95bc5b24451ab014fd98bf1bcd692b2d567bff\spring-security-oauth2-jose-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.sun.mail\jakarta.mail\1.6.5\d08124137cf42397d00b71b5985fd1dc248ac07f\jakarta.mail-1.6.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-config\5.3.3.RELEASE\4df881cc253f63e6aaff9dd66528c2dc18ca61e8\spring-security-config-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-core\5.3.3.RELEASE\abdd5a67b3fdc2f4a63023c3f60bbbf21c7c08cf\spring-security-core-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-json\2.3.1.RELEASE\8342003919c7e5a2470072595ea190cb8a9552c0\spring-boot-starter-json-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-tomcat\2.3.1.RELEASE\5b599d0da04e724479c22daa47f9bfd62533a2e9\spring-boot-starter-tomcat-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-webmvc\5.2.7.RELEASE\dcd97bcb0a2aa33f272b0031e4771134e327d942\spring-webmvc-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-web\5.2.7.RELEASE\50a27c77e1731f3b7af5c2ae7caf6fe59bcc309\spring-web-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.session\spring-session-core\2.3.0.RELEASE\f7cde6e3ceccad5c4f45a11c1cf6c36703888823\spring-session-core-2.3.0.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-context\5.2.7.RELEASE\7fd9c4ea311a5d9ab92770be7fc93cc53db334f9\spring-context-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-jdbc\5.2.7.RELEASE\847d31c90479a34e4e1fe7eeeb47ac89adce3438\spring-jdbc-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-aop\5.2.7.RELEASE\9cf69f8e888091684c05f0a287bb638502e90725\spring-aop-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.aspectj\aspectjweaver\1.9.5\1740dc9140103b796d1722668805fd4cf852780c\aspectjweaver-1.9.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.zaxxer\HikariCP\3.4.5\aa1a2c00aae8e4ba8308e19940711bb9525b103d\HikariCP-3.4.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\antlr\antlr\2.7.7\83cd2cd674a217ade95a4bb83a8a14f351f48bd0\antlr-2.7.7.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\net.bytebuddy\byte-buddy\1.10.11\16ac7e0d4afef10ac30db377e8151aff66a90e1c\byte-buddy-1.10.11.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml\classmate\1.5.1\3fe0bed568c62df5e89f4f174c101eab25345b6c\classmate-1.5.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\jaxb-runtime\2.3.3\c46b68a6e3a2d84ba4eb14c6a8a1a9a7be4048bc\jaxb-runtime-2.3.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.hibernate.common\hibernate-commons-annotations\5.1.0.Final\700aeedc4a2089816621948f0379e17cbd17d5db\hibernate-commons-annotations-5.1.0.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.jboss.logging\jboss-logging\3.4.1.Final\40fd4d696c55793e996d1ff3c475833f836c2498\jboss-logging-3.4.1.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.javassist\javassist\3.24.0-GA\d7466fc2e3af7c023e95c510f06448ad29b225b3\javassist-3.24.0-GA.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.jboss\jandex\2.1.3.Final\cd56603e39eb1421560b71daa584348ecfd9e0b8\jandex-2.1.3.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.dom4j\dom4j\2.1.3\a75914155a9f5808963170ec20653668a2ffd2fd\dom4j-2.1.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-orm\5.2.7.RELEASE\32a76d825d8782ff278abe124ded9620444b4a74\spring-orm-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-commons\2.3.1.RELEASE\5ae66c24c223315d5b31a45590d293e9145c18e9\spring-data-commons-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-tx\5.2.7.RELEASE\66faebf0da41c67b67d082efc98e92c40e83e6b\spring-tx-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-beans\5.2.7.RELEASE\5465ab17688ed62254fdef411cf883fd5c3b77a\spring-beans-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-core\5.2.7.RELEASE\56e14a3a5e2813534b5db2da1502cd58ab5bc61d\spring-core-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.slf4j\slf4j-api\1.7.30\b5a4b6d16ab13e34a88fae84c35cd5d68cac922c\slf4j-api-1.7.30.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-autoconfigure\2.3.1.RELEASE\6d679d6ba26235a0e81ca1d58f9c1024d9427411\spring-boot-autoconfigure-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot\2.3.1.RELEASE\ce8d8b6838ecceb68962b975b18682f4237ccf71\spring-boot-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-logging\2.3.1.RELEASE\3f242a91ffddf7485fde1367e1354c7e13024c8\spring-boot-starter-logging-2.3.1.RELEASE.jar;C:\Users\onvit.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\onvit.gradle\caches\modules-2\files-2.1\org.yaml\snakeyaml\1.26\a78a8747147d2c5807683e76ec2b633e95c14fe9\snakeyaml-1.26.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-core\5.3.3.RELEASE\28aaf647a4afa4b4edd7693c0d9dba7b65fcb3e6\spring-security-oauth2-core-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-web\5.3.3.RELEASE\a7edf55294e312f4c09e372c333e94d96bcf7c70\spring-security-web-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\oauth2-oidc-sdk\7.1.1\e59759a715b08d084b21d8b2a43fb3bf5545387d\oauth2-oidc-sdk-7.1.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\nimbus-jose-jwt\8.18.1\b0078ab0deaa356e017719d62388a2aee3e18e4d\nimbus-jose-jwt-8.18.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.sun.activation\jakarta.activation\1.2.2\74548703f9851017ce2f556066659438019e7eb5\jakarta.activation-1.2.2.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-expression\5.2.7.RELEASE\c98d7b10f959f9bedfbbbd4d723cf7a1f17a1f71\spring-expression-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jsr310\2.11.0\168b2d0e11478b9f0a1bfccd62d6b5e8547b1e6f\jackson-datatype-jsr310-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jdk8\2.11.0\cca91d6375258fd7ff2a6abb7bf91eef492bd606\jackson-datatype-jdk8-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.module\jackson-module-parameter-names\2.11.0\950a1e9a7c1093e7ffd92b216d5a0667f1e39058\jackson-module-parameter-names-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-databind\2.11.0\8f5aaf3878b0647ff3a16610af53b1a5c05d9f15\jackson-databind-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish\jakarta.el\3.0.3\dab46ee1ee23f7197c13d7c40fce14817c9017df\jakarta.el-3.0.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-websocket\9.0.36\33fa5038aa66be6e9cc188000c2188aa4dd33c85\tomcat-embed-websocket-9.0.36.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-core\9.0.36\cf6574dd9c4764e60c548b69da52fc07a5a0a9bd\tomcat-embed-core-9.0.36.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-jcl\5.2.7.RELEASE\72282e1f89c58284632220437b5a1e8066c53d7d\spring-jcl-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\txw2\2.3.3\12f70b0ea4fc1ad45315e842f63f7c9a46f46530\txw2-2.3.3.jar;C:\Users\onvit.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\onvit.gradle\caches\modules-2\files-2.1\com.sun.istack\istack-commons-runtime\3.0.11\4293b5f4e4e89d598f62bb2ba73b32132e7c3a27\istack-commons-runtime-3.0.11.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-to-slf4j\2.13.3\966f6fd1af4959d6b12bfa880121d4a2b164f857\log4j-to-slf4j-2.13.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-classic\1.2.3\7c4f3c474fb2c041d8028740440937705ebb473a\logback-classic-1.2.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.slf4j\jul-to-slf4j\1.7.30\d58bebff8cbf70ff52b59208586095f467656c30\jul-to-slf4j-1.7.30.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.github.stephenc.jcip\jcip-annotations\1.0-1\ef31541dd28ae2cefdd17c7ebf352d93e9058c63\jcip-annotations-1.0-1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\content-type\2.0\12ebb1f6b7794684e4c56918fe59df3d7aab72b0\content-type-2.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\net.minidev\json-smart\1.3.1\69b3835e96d282ec85fc2e1517b8164c45ed639e\json-smart-1.3.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\lang-tag\1.4.4\1db9a709239ae473a69b5424c7e78d0b7108229d\lang-tag-1.4.4.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-annotations\2.11.0\c626020ae55d19c690d25cb51c1532ba76e5890f\jackson-annotations-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-core\2.11.0\f84302e14648f9f63c0c73951054aeb2ff0b810a\jackson-core-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-api\2.13.3\ec1508160b93d274b1add34419b897bae84c6ca9\log4j-api-2.13.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-core\1.2.3\864344400c3d4d92dfeb0a305dc87d953677c03c\logback-core-1.2.3.jar com.jojoldu.book.springboot.Application

. _ _ /\ / '_ () \ \ \ \ ( ( )\ | ' | '| | ' \/ ` | \ \ \ \ \/ _)| |)| | | | | || (| | ) ) ) ) ' |__| .|| ||| |\, | / / / / =========|_|==============|__/=//// :: Spring Boot :: (v2.3.1.RELEASE)

2021-07-14 14:30:19.508 INFO 936 --- [ main] com.jojoldu.book.springboot.Application : Starting Application on DESKTOP-0ED418T with PID 936 (C:\Users\onvit\Desktop\intellijToGit\out\production\classes started by onvit in C:\Users\onvit\Desktop\intellijToGit) 2021-07-14 14:30:19.512 INFO 936 --- [ main] com.jojoldu.book.springboot.Application : The following profiles are active: oauth 2021-07-14 14:30:20.247 INFO 936 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFERRED mode. 2021-07-14 14:30:20.308 INFO 936 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 54ms. Found 2 JPA repository interfaces. 2021-07-14 14:30:21.041 INFO 936 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2021-07-14 14:30:21.054 INFO 936 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2021-07-14 14:30:21.054 INFO 936 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.36] 2021-07-14 14:30:21.163 INFO 936 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2021-07-14 14:30:21.163 INFO 936 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1594 ms 2021-07-14 14:30:21.204 INFO 936 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-07-14 14:30:21.427 INFO 936 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-07-14 14:30:21.433 INFO 936 --- [ main] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:91108773-3f80-46d7-8f49-aa5aea512812' 2021-07-14 14:30:21.607 INFO 936 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2021-07-14 14:30:21.671 INFO 936 --- [ task-1] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2021-07-14 14:30:21.737 INFO 936 --- [ task-1] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.4.17.Final 2021-07-14 14:30:21.851 WARN 936 --- [ 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 2021-07-14 14:30:21.917 INFO 936 --- [ task-1] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.0.Final} 2021-07-14 14:30:22.039 INFO 936 --- [ task-1] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect Hibernate: drop table if exists posts Hibernate: drop table if exists user Hibernate: create table posts (id bigint not null auto_increment, create_date datetime, modified_date datetime, author varchar(255), content TEXT not null, title varchar(500) not null, primary key (id)) engine=InnoDB 2021-07-14 14:30:22.706 WARN 936 --- [ task-1] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "create table posts (id bigint not null auto_increment, create_date datetime, modified_date datetime, author varchar(255), content TEXT not null, title varchar(500) not null, primary key (id)) engine=InnoDB" via JDBC Statement

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table posts (id bigint not null auto_increment, create_date datetime, modified_date datetime, author varchar(255), content TEXT not null, title varchar(500) not null, primary key (id)) engine=InnoDB" via JDBC Statement at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:439) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:423) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:314) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:166) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:135) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:121) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:156) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:316) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) [spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) [spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE] at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_292] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_292] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_292] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_292] Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE POSTS (ID BIGINT NOT NULL AUTO_INCREMENT, CREATE_DATE DATETIME, MODIFIED_DATE DATETIME, AUTHOR VARCHAR(255), CONTENT TEXT NOT NULL, TITLE VARCHAR(500) NOT NULL, PRIMARY KEY (ID)) ENGINE=[*]INNODB"; expected "identifier"; SQL statement: create table posts (id bigint not null auto_increment, create_date datetime, modified_date datetime, author varchar(255), content TEXT not null, title varchar(500) not null, primary key (id)) engine=InnoDB [42001-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:453) ~[h2-1.4.200.jar:1.4.200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200] at org.h2.message.DbException.getSyntaxError(DbException.java:243) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.readColumnIdentifier(Parser.java:4976) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.readUniqueIdentifier(Parser.java:4962) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parseCreateTable(Parser.java:8387) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parseCreate(Parser.java:6276) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parsePrepared(Parser.java:903) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parse(Parser.java:843) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parse(Parser.java:815) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.prepareCommand(Parser.java:738) ~[h2-1.4.200.jar:1.4.200] at org.h2.engine.Session.prepareLocal(Session.java:657) ~[h2-1.4.200.jar:1.4.200] at org.h2.engine.Session.prepareCommand(Session.java:595) ~[h2-1.4.200.jar:1.4.200] at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235) ~[h2-1.4.200.jar:1.4.200] at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:212) ~[h2-1.4.200.jar:1.4.200] at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201) ~[h2-1.4.200.jar:1.4.200] at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-3.4.5.jar:na] at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-3.4.5.jar:na] at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final] ... 18 common frames omitted

Hibernate: create table user (id bigint not null auto_increment, create_date datetime, modified_date datetime, email varchar(255) not null, name varchar(255) not null, picture varchar(255), role varchar(255) not null, primary key (id)) engine=InnoDB 2021-07-14 14:30:22.707 WARN 936 --- [ task-1] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "create table user (id bigint not null auto_increment, create_date datetime, modified_date datetime, email varchar(255) not null, name varchar(255) not null, picture varchar(255), role varchar(255) not null, primary key (id)) engine=InnoDB" via JDBC Statement

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table user (id bigint not null auto_increment, create_date datetime, modified_date datetime, email varchar(255) not null, name varchar(255) not null, picture varchar(255), role varchar(255) not null, primary key (id)) engine=InnoDB" via JDBC Statement at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:439) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:423) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:314) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:166) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:135) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:121) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:156) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:316) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259) [hibernate-core-5.4.17.Final.jar:5.4.17.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) [spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) [spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE] at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_292] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_292] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_292] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_292] Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE USER (ID BIGINT NOT NULL AUTO_INCREMENT, CREATE_DATE DATETIME, MODIFIED_DATE DATETIME, EMAIL VARCHAR(255) NOT NULL, NAME VARCHAR(255) NOT NULL, PICTURE VARCHAR(255), ROLE VARCHAR(255) NOT NULL, PRIMARY KEY (ID)) ENGINE=[*]INNODB"; expected "identifier"; SQL statement: create table user (id bigint not null auto_increment, create_date datetime, modified_date datetime, email varchar(255) not null, name varchar(255) not null, picture varchar(255), role varchar(255) not null, primary key (id)) engine=InnoDB [42001-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:453) ~[h2-1.4.200.jar:1.4.200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200] at org.h2.message.DbException.getSyntaxError(DbException.java:243) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.readColumnIdentifier(Parser.java:4976) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.readUniqueIdentifier(Parser.java:4962) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parseCreateTable(Parser.java:8387) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parseCreate(Parser.java:6276) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parsePrepared(Parser.java:903) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parse(Parser.java:843) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.parse(Parser.java:815) ~[h2-1.4.200.jar:1.4.200] at org.h2.command.Parser.prepareCommand(Parser.java:738) ~[h2-1.4.200.jar:1.4.200] at org.h2.engine.Session.prepareLocal(Session.java:657) ~[h2-1.4.200.jar:1.4.200] at org.h2.engine.Session.prepareCommand(Session.java:595) ~[h2-1.4.200.jar:1.4.200] at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235) ~[h2-1.4.200.jar:1.4.200] at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:212) ~[h2-1.4.200.jar:1.4.200] at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201) ~[h2-1.4.200.jar:1.4.200] at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-3.4.5.jar:na] at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-3.4.5.jar:na] at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final] ... 18 common frames omitted

2021-07-14 14:30:22.709 INFO 936 --- [ task-1] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 2021-07-14 14:30:22.715 INFO 936 --- [ task-1] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2021-07-14 14:30:22.896 INFO 936 --- [ main] o.s.s.web.DefaultSecurityFilterChain : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@2a334bac, org.springframework.security.web.context.SecurityContextPersistenceFilter@43bf5397, org.springframework.security.web.header.HeaderWriterFilter@68ed3f30, org.springframework.security.web.authentication.logout.LogoutFilter@7da31a40, org.springframework.security.oauth2.client.web.OAuth2AuthorizationRequestRedirectFilter@119b0892, org.springframework.security.oauth2.client.web.OAuth2LoginAuthenticationFilter@50448409, org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter@47b11ec7, org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter@470d183, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@58015e56, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@1e3e1014, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@7f9fc8bd, org.springframework.security.web.session.SessionManagementFilter@590adb41, org.springframework.security.web.access.ExceptionTranslationFilter@3d19d85, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@6e3ecf5c] 2021-07-14 14:30:23.254 INFO 936 --- [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page template: index 2021-07-14 14:30:23.394 INFO 936 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path '' 2021-07-14 14:30:23.395 INFO 936 --- [ main] DeferredRepositoryInitializationListener : Triggering deferred initialization of Spring Data repositories… 2021-07-14 14:30:23.891 INFO 936 --- [ main] DeferredRepositoryInitializationListener : Spring Data repositories initialized! 2021-07-14 14:30:23.898 INFO 936 --- [ main] s.a.ScheduledAnnotationBeanPostProcessor : No TaskScheduler/ScheduledExecutorService bean found for scheduled processing 2021-07-14 14:30:23.906 INFO 936 --- [ main] com.jojoldu.book.springboot.Application : Started Application in 4.825 seconds (JVM running for 5.29)

어떤 오류인지 캡쳐해주세요. image

soulduo commented 3 years ago

테이블 생성문 마지막에 engine=InnoDB가 붙으면서 생기는 오류일 겁니다.

application.properties 내용을 다음과 같이 수정해 보세요.

spring.jpa.show_sql=truespring.h2.console.enabled=true spring.session.store-type=jdbc spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL57Dialect spring.jpa.properties.hibernate.dialect.storage_engine=innodb spring.datasource.hikari.jdbc-url=jdbc:h2:mem://localhost/~/testdb;MODE=MYSQL

h2-database의 접속 주소(JDBC URL)는 'jdbc:h2:mem://localhost/~/testdb'로 입력하시면 됩니다.

beomth commented 3 years ago

우선 정말 빠른 피드백 감사합니다 ㅠㅠ

spring.jpa.show_sql=true spring.session.store-type=jdbc spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL57Dialect spring.jpa.properties.hibernate.dialect.storage_engine=innodb spring.datasource.hikari.jdbc-url=jdbc:h2:mem://localhost/~/testdb;MODE=MYSQL

를 application.properties에 추가하고, 다시 실행했는데 또 오류가 떳습니다!

C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\bin\java.exe "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.1.3\lib\idea_rt.jar=60791:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.1.3\bin" -Dfile.encoding=UTF-8 -classpath C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\charsets.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\access-bridge-64.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\cldrdata.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\dnsns.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\jaccess.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\localedata.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\nashorn.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunec.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunjce_provider.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunmscapi.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunpkcs11.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\zipfs.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jce.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jfr.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jsse.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\management-agent.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\resources.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\rt.jar;C:\Users\onvit\Desktop\intellijToGit\out\production\classes;C:\Users\onvit\Desktop\intellijToGit\out\production\resources;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-data-jpa\2.3.1.RELEASE\5531a4cbd506f13a0b4483ed73c2e75a03d8da46\spring-boot-starter-data-jpa-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-mustache\2.3.1.RELEASE\a8678f002dc2b870fa8fe03278b8b30f1f7e9afe\spring-boot-starter-mustache-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-oauth2-client\2.3.1.RELEASE\3c89db40f21bbaa48341398bddfde1dbe2d89803\spring-boot-starter-oauth2-client-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-web\2.3.1.RELEASE\555c4f90141cdbc7637145e413bca0d622ba6796\spring-boot-starter-web-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.h2database\h2\1.4.200\f7533fe7cb8e99c87a43d325a77b4b678ad9031a\h2-1.4.200.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.session\spring-session-jdbc\2.3.0.RELEASE\7238cdd5b37ecd0ae441f1126b2336500e3633f\spring-session-jdbc-2.3.0.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.mariadb.jdbc\mariadb-java-client\2.6.0\7ada3fc7b30ae8fa4616f47ef6d505bdda933605\mariadb-java-client-2.6.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-aop\2.3.1.RELEASE\f42e23091d29bde8d1356e45cf13ad32dae51437\spring-boot-starter-aop-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-jdbc\2.3.1.RELEASE\800b64e76588ea88761ad9108cde762204805d66\spring-boot-starter-jdbc-2.3.1.RELEASE.jar;C:\Users\onvit.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\onvit.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\onvit.gradle\caches\modules-2\files-2.1\org.hibernate\hibernate-core\5.4.17.Final\3b90ecf6fe93a27a27de9671c9fb25d03ba3def7\hibernate-core-5.4.17.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-jpa\2.3.1.RELEASE\1b5e106add569913f0c776aca62f85d8e9ca8cee\spring-data-jpa-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-aspects\5.2.7.RELEASE\eb48f4ae3e1525179e1ccd10c0e09cfe5c27b8bb\spring-aspects-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter\2.3.1.RELEASE\e0d28696fea064578cb01da346232284f922eba4\spring-boot-starter-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.samskivert\jmustache\1.15\7b3b15951d13b774c76db2f4e14d977952f8b4d8\jmustache-1.15.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-client\5.3.3.RELEASE\1cb3848eb37222f851783c9b2355e1ada3144141\spring-security-oauth2-client-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-jose\5.3.3.RELEASE\ec95bc5b24451ab014fd98bf1bcd692b2d567bff\spring-security-oauth2-jose-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.sun.mail\jakarta.mail\1.6.5\d08124137cf42397d00b71b5985fd1dc248ac07f\jakarta.mail-1.6.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-config\5.3.3.RELEASE\4df881cc253f63e6aaff9dd66528c2dc18ca61e8\spring-security-config-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-core\5.3.3.RELEASE\abdd5a67b3fdc2f4a63023c3f60bbbf21c7c08cf\spring-security-core-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-json\2.3.1.RELEASE\8342003919c7e5a2470072595ea190cb8a9552c0\spring-boot-starter-json-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-tomcat\2.3.1.RELEASE\5b599d0da04e724479c22daa47f9bfd62533a2e9\spring-boot-starter-tomcat-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-webmvc\5.2.7.RELEASE\dcd97bcb0a2aa33f272b0031e4771134e327d942\spring-webmvc-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-web\5.2.7.RELEASE\50a27c77e1731f3b7af5c2ae7caf6fe59bcc309\spring-web-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.session\spring-session-core\2.3.0.RELEASE\f7cde6e3ceccad5c4f45a11c1cf6c36703888823\spring-session-core-2.3.0.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-context\5.2.7.RELEASE\7fd9c4ea311a5d9ab92770be7fc93cc53db334f9\spring-context-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-jdbc\5.2.7.RELEASE\847d31c90479a34e4e1fe7eeeb47ac89adce3438\spring-jdbc-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-aop\5.2.7.RELEASE\9cf69f8e888091684c05f0a287bb638502e90725\spring-aop-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.aspectj\aspectjweaver\1.9.5\1740dc9140103b796d1722668805fd4cf852780c\aspectjweaver-1.9.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.zaxxer\HikariCP\3.4.5\aa1a2c00aae8e4ba8308e19940711bb9525b103d\HikariCP-3.4.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\antlr\antlr\2.7.7\83cd2cd674a217ade95a4bb83a8a14f351f48bd0\antlr-2.7.7.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\net.bytebuddy\byte-buddy\1.10.11\16ac7e0d4afef10ac30db377e8151aff66a90e1c\byte-buddy-1.10.11.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml\classmate\1.5.1\3fe0bed568c62df5e89f4f174c101eab25345b6c\classmate-1.5.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\jaxb-runtime\2.3.3\c46b68a6e3a2d84ba4eb14c6a8a1a9a7be4048bc\jaxb-runtime-2.3.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.hibernate.common\hibernate-commons-annotations\5.1.0.Final\700aeedc4a2089816621948f0379e17cbd17d5db\hibernate-commons-annotations-5.1.0.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.jboss.logging\jboss-logging\3.4.1.Final\40fd4d696c55793e996d1ff3c475833f836c2498\jboss-logging-3.4.1.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.javassist\javassist\3.24.0-GA\d7466fc2e3af7c023e95c510f06448ad29b225b3\javassist-3.24.0-GA.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.jboss\jandex\2.1.3.Final\cd56603e39eb1421560b71daa584348ecfd9e0b8\jandex-2.1.3.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.dom4j\dom4j\2.1.3\a75914155a9f5808963170ec20653668a2ffd2fd\dom4j-2.1.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-orm\5.2.7.RELEASE\32a76d825d8782ff278abe124ded9620444b4a74\spring-orm-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-commons\2.3.1.RELEASE\5ae66c24c223315d5b31a45590d293e9145c18e9\spring-data-commons-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-tx\5.2.7.RELEASE\66faebf0da41c67b67d082efc98e92c40e83e6b\spring-tx-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-beans\5.2.7.RELEASE\5465ab17688ed62254fdef411cf883fd5c3b77a\spring-beans-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-core\5.2.7.RELEASE\56e14a3a5e2813534b5db2da1502cd58ab5bc61d\spring-core-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.slf4j\slf4j-api\1.7.30\b5a4b6d16ab13e34a88fae84c35cd5d68cac922c\slf4j-api-1.7.30.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-autoconfigure\2.3.1.RELEASE\6d679d6ba26235a0e81ca1d58f9c1024d9427411\spring-boot-autoconfigure-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot\2.3.1.RELEASE\ce8d8b6838ecceb68962b975b18682f4237ccf71\spring-boot-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-logging\2.3.1.RELEASE\3f242a91ffddf7485fde1367e1354c7e13024c8\spring-boot-starter-logging-2.3.1.RELEASE.jar;C:\Users\onvit.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\onvit.gradle\caches\modules-2\files-2.1\org.yaml\snakeyaml\1.26\a78a8747147d2c5807683e76ec2b633e95c14fe9\snakeyaml-1.26.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-core\5.3.3.RELEASE\28aaf647a4afa4b4edd7693c0d9dba7b65fcb3e6\spring-security-oauth2-core-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-web\5.3.3.RELEASE\a7edf55294e312f4c09e372c333e94d96bcf7c70\spring-security-web-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\oauth2-oidc-sdk\7.1.1\e59759a715b08d084b21d8b2a43fb3bf5545387d\oauth2-oidc-sdk-7.1.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\nimbus-jose-jwt\8.18.1\b0078ab0deaa356e017719d62388a2aee3e18e4d\nimbus-jose-jwt-8.18.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.sun.activation\jakarta.activation\1.2.2\74548703f9851017ce2f556066659438019e7eb5\jakarta.activation-1.2.2.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-expression\5.2.7.RELEASE\c98d7b10f959f9bedfbbbd4d723cf7a1f17a1f71\spring-expression-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jsr310\2.11.0\168b2d0e11478b9f0a1bfccd62d6b5e8547b1e6f\jackson-datatype-jsr310-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jdk8\2.11.0\cca91d6375258fd7ff2a6abb7bf91eef492bd606\jackson-datatype-jdk8-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.module\jackson-module-parameter-names\2.11.0\950a1e9a7c1093e7ffd92b216d5a0667f1e39058\jackson-module-parameter-names-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-databind\2.11.0\8f5aaf3878b0647ff3a16610af53b1a5c05d9f15\jackson-databind-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish\jakarta.el\3.0.3\dab46ee1ee23f7197c13d7c40fce14817c9017df\jakarta.el-3.0.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-websocket\9.0.36\33fa5038aa66be6e9cc188000c2188aa4dd33c85\tomcat-embed-websocket-9.0.36.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-core\9.0.36\cf6574dd9c4764e60c548b69da52fc07a5a0a9bd\tomcat-embed-core-9.0.36.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-jcl\5.2.7.RELEASE\72282e1f89c58284632220437b5a1e8066c53d7d\spring-jcl-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\txw2\2.3.3\12f70b0ea4fc1ad45315e842f63f7c9a46f46530\txw2-2.3.3.jar;C:\Users\onvit.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\onvit.gradle\caches\modules-2\files-2.1\com.sun.istack\istack-commons-runtime\3.0.11\4293b5f4e4e89d598f62bb2ba73b32132e7c3a27\istack-commons-runtime-3.0.11.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-to-slf4j\2.13.3\966f6fd1af4959d6b12bfa880121d4a2b164f857\log4j-to-slf4j-2.13.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-classic\1.2.3\7c4f3c474fb2c041d8028740440937705ebb473a\logback-classic-1.2.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.slf4j\jul-to-slf4j\1.7.30\d58bebff8cbf70ff52b59208586095f467656c30\jul-to-slf4j-1.7.30.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.github.stephenc.jcip\jcip-annotations\1.0-1\ef31541dd28ae2cefdd17c7ebf352d93e9058c63\jcip-annotations-1.0-1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\content-type\2.0\12ebb1f6b7794684e4c56918fe59df3d7aab72b0\content-type-2.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\net.minidev\json-smart\1.3.1\69b3835e96d282ec85fc2e1517b8164c45ed639e\json-smart-1.3.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\lang-tag\1.4.4\1db9a709239ae473a69b5424c7e78d0b7108229d\lang-tag-1.4.4.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-annotations\2.11.0\c626020ae55d19c690d25cb51c1532ba76e5890f\jackson-annotations-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-core\2.11.0\f84302e14648f9f63c0c73951054aeb2ff0b810a\jackson-core-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-api\2.13.3\ec1508160b93d274b1add34419b897bae84c6ca9\log4j-api-2.13.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-core\1.2.3\864344400c3d4d92dfeb0a305dc87d953677c03c\logback-core-1.2.3.jar com.jojoldu.book.springboot.Application

. _ _ /\ / '_ () \ \ \ \ ( ( )\ | ' | '| | ' \/ ` | \ \ \ \ \/ _)| |)| | | | | || (| | ) ) ) ) ' |__| .|| ||| |\, | / / / / =========|_|==============|__/=//// :: Spring Boot :: (v2.3.1.RELEASE)

2021-07-14 15:29:25.728 INFO 1364 --- [ main] com.jojoldu.book.springboot.Application : Starting Application on DESKTOP-0ED418T with PID 1364 (C:\Users\onvit\Desktop\intellijToGit\out\production\classes started by onvit in C:\Users\onvit\Desktop\intellijToGit) 2021-07-14 15:29:25.728 INFO 1364 --- [ main] com.jojoldu.book.springboot.Application : No active profile set, falling back to default profiles: default 2021-07-14 15:29:26.839 INFO 1364 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFERRED mode. 2021-07-14 15:29:26.901 INFO 1364 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 52ms. Found 2 JPA repository interfaces. 2021-07-14 15:29:27.651 INFO 1364 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2021-07-14 15:29:27.667 INFO 1364 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2021-07-14 15:29:27.667 INFO 1364 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.36] 2021-07-14 15:29:27.760 INFO 1364 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2021-07-14 15:29:27.760 INFO 1364 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1954 ms 2021-07-14 15:29:27.995 INFO 1364 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2021-07-14 15:29:28.010 INFO 1364 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-07-14 15:29:28.245 INFO 1364 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-07-14 15:29:28.323 INFO 1364 --- [ task-1] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2021-07-14 15:29:28.385 INFO 1364 --- [ task-1] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.4.17.Final 2021-07-14 15:29:28.510 WARN 1364 --- [ 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 2021-07-14 15:29:28.587 INFO 1364 --- [ task-1] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.0.Final} 2021-07-14 15:29:28.696 INFO 1364 --- [ task-1] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL57Dialect Hibernate: drop table if exists posts Hibernate: drop table if exists user Hibernate: create table posts (id bigint not null auto_increment, create_date datetime(6), modified_date datetime(6), author varchar(255), content TEXT not null, title varchar(500) not null, primary key (id)) engine=InnoDB Hibernate: create table user (id bigint not null auto_increment, create_date datetime(6), modified_date datetime(6), email varchar(255) not null, name varchar(255) not null, picture varchar(255), role varchar(255) not null, primary key (id)) engine=InnoDB 2021-07-14 15:29:29.337 INFO 1364 --- [ task-1] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 2021-07-14 15:29:29.352 INFO 1364 --- [ task-1] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2021-07-14 15:29:29.430 INFO 1364 --- [ main] .s.s.UserDetailsServiceAutoConfiguration :

Using generated security password: 6ab53b12-1331-4e48-85d6-877d449a9f34

2021-07-14 15:29:29.493 WARN 1364 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'springSecurityFilterChain' defined in class path resource [org/springframework/security/config/annotation/web/configuration/WebSecurityConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.servlet.Filter]: Factory method 'springSecurityFilterChain' threw exception; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'org.springframework.security.oauth2.client.registration.ClientRegistrationRepository' available 2021-07-14 15:29:29.493 INFO 1364 --- [ main] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' 2021-07-14 15:29:29.493 INFO 1364 --- [ main] .SchemaDropperImpl$DelayedDropActionImpl : HHH000477: Starting delayed evictData of schema as part of SessionFactory shut-down' Hibernate: drop table if exists posts Hibernate: drop table if exists user 2021-07-14 15:29:29.509 INFO 1364 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'applicationTaskExecutor' 2021-07-14 15:29:29.509 INFO 1364 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2021-07-14 15:29:29.509 INFO 1364 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. 2021-07-14 15:29:29.509 INFO 1364 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat] 2021-07-14 15:29:29.524 INFO 1364 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2021-07-14 15:29:29.665 ERROR 1364 --- [ main] o.s.b.d.LoggingFailureAnalysisReporter :

APPLICATION FAILED TO START

Description:

Method springSecurityFilterChain in org.springframework.security.config.annotation.web.configuration.WebSecurityConfiguration required a bean of type 'org.springframework.security.oauth2.client.registration.ClientRegistrationRepository' that could not be found.

The following candidates were found but could not be injected:

Action:

Consider revisiting the entries above or defining a bean of type 'org.springframework.security.oauth2.client.registration.ClientRegistrationRepository' in your configuration.

Process finished with exit code 1

soulduo commented 3 years ago

저도 책보고 학습중인 부분에서 때낸거라 다소 진행 상황에 따른 차이가 발생한 듯한데.

OAuth2 인증 관련된 부분 떄문 같네요.

spring.session.store-type=jdbc <- 이부분을 지워보시겠어요?

beomth commented 3 years ago

그 부분 지워도 오류가 발생합니다..!!

C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\bin\java.exe "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.1.3\lib\idea_rt.jar=62692:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.1.3\bin" -Dfile.encoding=UTF-8 -classpath C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\charsets.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\access-bridge-64.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\cldrdata.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\dnsns.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\jaccess.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\localedata.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\nashorn.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunec.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunjce_provider.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunmscapi.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunpkcs11.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\zipfs.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jce.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jfr.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jsse.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\management-agent.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\resources.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\rt.jar;C:\Users\onvit\Desktop\intellijToGit\out\production\classes;C:\Users\onvit\Desktop\intellijToGit\out\production\resources;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-data-jpa\2.3.1.RELEASE\5531a4cbd506f13a0b4483ed73c2e75a03d8da46\spring-boot-starter-data-jpa-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-mustache\2.3.1.RELEASE\a8678f002dc2b870fa8fe03278b8b30f1f7e9afe\spring-boot-starter-mustache-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-oauth2-client\2.3.1.RELEASE\3c89db40f21bbaa48341398bddfde1dbe2d89803\spring-boot-starter-oauth2-client-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-web\2.3.1.RELEASE\555c4f90141cdbc7637145e413bca0d622ba6796\spring-boot-starter-web-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.h2database\h2\1.4.200\f7533fe7cb8e99c87a43d325a77b4b678ad9031a\h2-1.4.200.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.session\spring-session-jdbc\2.3.0.RELEASE\7238cdd5b37ecd0ae441f1126b2336500e3633f\spring-session-jdbc-2.3.0.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.mariadb.jdbc\mariadb-java-client\2.6.0\7ada3fc7b30ae8fa4616f47ef6d505bdda933605\mariadb-java-client-2.6.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-aop\2.3.1.RELEASE\f42e23091d29bde8d1356e45cf13ad32dae51437\spring-boot-starter-aop-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-jdbc\2.3.1.RELEASE\800b64e76588ea88761ad9108cde762204805d66\spring-boot-starter-jdbc-2.3.1.RELEASE.jar;C:\Users\onvit.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\onvit.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\onvit.gradle\caches\modules-2\files-2.1\org.hibernate\hibernate-core\5.4.17.Final\3b90ecf6fe93a27a27de9671c9fb25d03ba3def7\hibernate-core-5.4.17.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-jpa\2.3.1.RELEASE\1b5e106add569913f0c776aca62f85d8e9ca8cee\spring-data-jpa-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-aspects\5.2.7.RELEASE\eb48f4ae3e1525179e1ccd10c0e09cfe5c27b8bb\spring-aspects-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter\2.3.1.RELEASE\e0d28696fea064578cb01da346232284f922eba4\spring-boot-starter-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.samskivert\jmustache\1.15\7b3b15951d13b774c76db2f4e14d977952f8b4d8\jmustache-1.15.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-client\5.3.3.RELEASE\1cb3848eb37222f851783c9b2355e1ada3144141\spring-security-oauth2-client-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-jose\5.3.3.RELEASE\ec95bc5b24451ab014fd98bf1bcd692b2d567bff\spring-security-oauth2-jose-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.sun.mail\jakarta.mail\1.6.5\d08124137cf42397d00b71b5985fd1dc248ac07f\jakarta.mail-1.6.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-config\5.3.3.RELEASE\4df881cc253f63e6aaff9dd66528c2dc18ca61e8\spring-security-config-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-core\5.3.3.RELEASE\abdd5a67b3fdc2f4a63023c3f60bbbf21c7c08cf\spring-security-core-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-json\2.3.1.RELEASE\8342003919c7e5a2470072595ea190cb8a9552c0\spring-boot-starter-json-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-tomcat\2.3.1.RELEASE\5b599d0da04e724479c22daa47f9bfd62533a2e9\spring-boot-starter-tomcat-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-webmvc\5.2.7.RELEASE\dcd97bcb0a2aa33f272b0031e4771134e327d942\spring-webmvc-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-web\5.2.7.RELEASE\50a27c77e1731f3b7af5c2ae7caf6fe59bcc309\spring-web-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.session\spring-session-core\2.3.0.RELEASE\f7cde6e3ceccad5c4f45a11c1cf6c36703888823\spring-session-core-2.3.0.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-context\5.2.7.RELEASE\7fd9c4ea311a5d9ab92770be7fc93cc53db334f9\spring-context-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-jdbc\5.2.7.RELEASE\847d31c90479a34e4e1fe7eeeb47ac89adce3438\spring-jdbc-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-aop\5.2.7.RELEASE\9cf69f8e888091684c05f0a287bb638502e90725\spring-aop-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.aspectj\aspectjweaver\1.9.5\1740dc9140103b796d1722668805fd4cf852780c\aspectjweaver-1.9.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.zaxxer\HikariCP\3.4.5\aa1a2c00aae8e4ba8308e19940711bb9525b103d\HikariCP-3.4.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\antlr\antlr\2.7.7\83cd2cd674a217ade95a4bb83a8a14f351f48bd0\antlr-2.7.7.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\net.bytebuddy\byte-buddy\1.10.11\16ac7e0d4afef10ac30db377e8151aff66a90e1c\byte-buddy-1.10.11.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml\classmate\1.5.1\3fe0bed568c62df5e89f4f174c101eab25345b6c\classmate-1.5.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\jaxb-runtime\2.3.3\c46b68a6e3a2d84ba4eb14c6a8a1a9a7be4048bc\jaxb-runtime-2.3.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.hibernate.common\hibernate-commons-annotations\5.1.0.Final\700aeedc4a2089816621948f0379e17cbd17d5db\hibernate-commons-annotations-5.1.0.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.jboss.logging\jboss-logging\3.4.1.Final\40fd4d696c55793e996d1ff3c475833f836c2498\jboss-logging-3.4.1.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.javassist\javassist\3.24.0-GA\d7466fc2e3af7c023e95c510f06448ad29b225b3\javassist-3.24.0-GA.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.jboss\jandex\2.1.3.Final\cd56603e39eb1421560b71daa584348ecfd9e0b8\jandex-2.1.3.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.dom4j\dom4j\2.1.3\a75914155a9f5808963170ec20653668a2ffd2fd\dom4j-2.1.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-orm\5.2.7.RELEASE\32a76d825d8782ff278abe124ded9620444b4a74\spring-orm-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-commons\2.3.1.RELEASE\5ae66c24c223315d5b31a45590d293e9145c18e9\spring-data-commons-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-tx\5.2.7.RELEASE\66faebf0da41c67b67d082efc98e92c40e83e6b\spring-tx-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-beans\5.2.7.RELEASE\5465ab17688ed62254fdef411cf883fd5c3b77a\spring-beans-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-core\5.2.7.RELEASE\56e14a3a5e2813534b5db2da1502cd58ab5bc61d\spring-core-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.slf4j\slf4j-api\1.7.30\b5a4b6d16ab13e34a88fae84c35cd5d68cac922c\slf4j-api-1.7.30.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-autoconfigure\2.3.1.RELEASE\6d679d6ba26235a0e81ca1d58f9c1024d9427411\spring-boot-autoconfigure-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot\2.3.1.RELEASE\ce8d8b6838ecceb68962b975b18682f4237ccf71\spring-boot-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-logging\2.3.1.RELEASE\3f242a91ffddf7485fde1367e1354c7e13024c8\spring-boot-starter-logging-2.3.1.RELEASE.jar;C:\Users\onvit.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\onvit.gradle\caches\modules-2\files-2.1\org.yaml\snakeyaml\1.26\a78a8747147d2c5807683e76ec2b633e95c14fe9\snakeyaml-1.26.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-core\5.3.3.RELEASE\28aaf647a4afa4b4edd7693c0d9dba7b65fcb3e6\spring-security-oauth2-core-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-web\5.3.3.RELEASE\a7edf55294e312f4c09e372c333e94d96bcf7c70\spring-security-web-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\oauth2-oidc-sdk\7.1.1\e59759a715b08d084b21d8b2a43fb3bf5545387d\oauth2-oidc-sdk-7.1.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\nimbus-jose-jwt\8.18.1\b0078ab0deaa356e017719d62388a2aee3e18e4d\nimbus-jose-jwt-8.18.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.sun.activation\jakarta.activation\1.2.2\74548703f9851017ce2f556066659438019e7eb5\jakarta.activation-1.2.2.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-expression\5.2.7.RELEASE\c98d7b10f959f9bedfbbbd4d723cf7a1f17a1f71\spring-expression-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jsr310\2.11.0\168b2d0e11478b9f0a1bfccd62d6b5e8547b1e6f\jackson-datatype-jsr310-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jdk8\2.11.0\cca91d6375258fd7ff2a6abb7bf91eef492bd606\jackson-datatype-jdk8-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.module\jackson-module-parameter-names\2.11.0\950a1e9a7c1093e7ffd92b216d5a0667f1e39058\jackson-module-parameter-names-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-databind\2.11.0\8f5aaf3878b0647ff3a16610af53b1a5c05d9f15\jackson-databind-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish\jakarta.el\3.0.3\dab46ee1ee23f7197c13d7c40fce14817c9017df\jakarta.el-3.0.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-websocket\9.0.36\33fa5038aa66be6e9cc188000c2188aa4dd33c85\tomcat-embed-websocket-9.0.36.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-core\9.0.36\cf6574dd9c4764e60c548b69da52fc07a5a0a9bd\tomcat-embed-core-9.0.36.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-jcl\5.2.7.RELEASE\72282e1f89c58284632220437b5a1e8066c53d7d\spring-jcl-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\txw2\2.3.3\12f70b0ea4fc1ad45315e842f63f7c9a46f46530\txw2-2.3.3.jar;C:\Users\onvit.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\onvit.gradle\caches\modules-2\files-2.1\com.sun.istack\istack-commons-runtime\3.0.11\4293b5f4e4e89d598f62bb2ba73b32132e7c3a27\istack-commons-runtime-3.0.11.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-to-slf4j\2.13.3\966f6fd1af4959d6b12bfa880121d4a2b164f857\log4j-to-slf4j-2.13.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-classic\1.2.3\7c4f3c474fb2c041d8028740440937705ebb473a\logback-classic-1.2.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.slf4j\jul-to-slf4j\1.7.30\d58bebff8cbf70ff52b59208586095f467656c30\jul-to-slf4j-1.7.30.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.github.stephenc.jcip\jcip-annotations\1.0-1\ef31541dd28ae2cefdd17c7ebf352d93e9058c63\jcip-annotations-1.0-1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\content-type\2.0\12ebb1f6b7794684e4c56918fe59df3d7aab72b0\content-type-2.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\net.minidev\json-smart\1.3.1\69b3835e96d282ec85fc2e1517b8164c45ed639e\json-smart-1.3.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\lang-tag\1.4.4\1db9a709239ae473a69b5424c7e78d0b7108229d\lang-tag-1.4.4.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-annotations\2.11.0\c626020ae55d19c690d25cb51c1532ba76e5890f\jackson-annotations-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-core\2.11.0\f84302e14648f9f63c0c73951054aeb2ff0b810a\jackson-core-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-api\2.13.3\ec1508160b93d274b1add34419b897bae84c6ca9\log4j-api-2.13.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-core\1.2.3\864344400c3d4d92dfeb0a305dc87d953677c03c\logback-core-1.2.3.jar com.jojoldu.book.springboot.Application

. _ _ /\ / '_ () \ \ \ \ ( ( )\ | ' | '| | ' \/ ` | \ \ \ \ \/ _)| |)| | | | | || (| | ) ) ) ) ' |__| .|| ||| |\, | / / / / =========|_|==============|__/=//// :: Spring Boot :: (v2.3.1.RELEASE)

2021-07-14 16:15:20.987 INFO 11256 --- [ main] com.jojoldu.book.springboot.Application : Starting Application on DESKTOP-0ED418T with PID 11256 (C:\Users\onvit\Desktop\intellijToGit\out\production\classes started by onvit in C:\Users\onvit\Desktop\intellijToGit) 2021-07-14 16:15:21.002 INFO 11256 --- [ main] com.jojoldu.book.springboot.Application : No active profile set, falling back to default profiles: default 2021-07-14 16:15:21.721 INFO 11256 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFERRED mode. 2021-07-14 16:15:21.783 INFO 11256 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 51ms. Found 2 JPA repository interfaces. 2021-07-14 16:15:22.486 INFO 11256 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2021-07-14 16:15:22.502 INFO 11256 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2021-07-14 16:15:22.502 INFO 11256 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.36] 2021-07-14 16:15:22.596 INFO 11256 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2021-07-14 16:15:22.596 INFO 11256 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1531 ms 2021-07-14 16:15:22.814 INFO 11256 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2021-07-14 16:15:22.830 INFO 11256 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-07-14 16:15:23.096 INFO 11256 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-07-14 16:15:23.158 INFO 11256 --- [ task-1] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2021-07-14 16:15:23.221 INFO 11256 --- [ task-1] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.4.17.Final 2021-07-14 16:15:23.330 WARN 11256 --- [ 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 2021-07-14 16:15:23.408 INFO 11256 --- [ task-1] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.0.Final} 2021-07-14 16:15:23.533 INFO 11256 --- [ task-1] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL57Dialect Hibernate: drop table if exists posts Hibernate: drop table if exists user Hibernate: create table posts (id bigint not null auto_increment, create_date datetime(6), modified_date datetime(6), author varchar(255), content TEXT not null, title varchar(500) not null, primary key (id)) engine=InnoDB Hibernate: create table user (id bigint not null auto_increment, create_date datetime(6), modified_date datetime(6), email varchar(255) not null, name varchar(255) not null, picture varchar(255), role varchar(255) not null, primary key (id)) engine=InnoDB 2021-07-14 16:15:24.142 INFO 11256 --- [ task-1] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 2021-07-14 16:15:24.142 INFO 11256 --- [ task-1] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2021-07-14 16:15:24.220 INFO 11256 --- [ main] .s.s.UserDetailsServiceAutoConfiguration :

Using generated security password: c48edbfe-4ff1-4739-b2ee-194f0aa748a6

2021-07-14 16:15:24.298 WARN 11256 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'springSecurityFilterChain' defined in class path resource [org/springframework/security/config/annotation/web/configuration/WebSecurityConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.servlet.Filter]: Factory method 'springSecurityFilterChain' threw exception; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'org.springframework.security.oauth2.client.registration.ClientRegistrationRepository' available 2021-07-14 16:15:24.298 INFO 11256 --- [ main] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' 2021-07-14 16:15:24.298 INFO 11256 --- [ main] .SchemaDropperImpl$DelayedDropActionImpl : HHH000477: Starting delayed evictData of schema as part of SessionFactory shut-down' Hibernate: drop table if exists posts Hibernate: drop table if exists user 2021-07-14 16:15:24.314 INFO 11256 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'applicationTaskExecutor' 2021-07-14 16:15:24.314 INFO 11256 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2021-07-14 16:15:24.314 INFO 11256 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. 2021-07-14 16:15:24.314 INFO 11256 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat] 2021-07-14 16:15:24.330 INFO 11256 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2021-07-14 16:15:24.423 ERROR 11256 --- [ main] o.s.b.d.LoggingFailureAnalysisReporter :

APPLICATION FAILED TO START

Description:

Method springSecurityFilterChain in org.springframework.security.config.annotation.web.configuration.WebSecurityConfiguration required a bean of type 'org.springframework.security.oauth2.client.registration.ClientRegistrationRepository' that could not be found.

The following candidates were found but could not be injected:

Action:

Consider revisiting the entries above or defining a bean of type 'org.springframework.security.oauth2.client.registration.ClientRegistrationRepository' in your configuration.

Process finished with exit code 1

soulduo commented 3 years ago

Hibernate: drop table if exists posts Hibernate: drop table if exists user Hibernate: create table posts (id bigint not null auto_increment, create_date datetime(6), modified_date datetime(6), author varchar(255), content TEXT not null, title varchar(500) not null, primary key (id)) engine=InnoDB Hibernate: create table user (id bigint not null auto_increment, create_date datetime(6), modified_date datetime(6), email varchar(255) not null, name varchar(255) not null, picture varchar(255), role varchar(255) not null, primary key (id)) engine=InnoDB 2021-07-14 16:15:24.142 INFO 11256 --- [ task-1] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 2021-07-14 16:15:24.142 INFO 11256 --- [ task-1] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2021-07-14 16:15:24.220 INFO 11256 --- [ main] .s.s.UserDetailsServiceAutoConfiguration :

Using generated security password: c48edbfe-4ff1-4739-b2ee-194f0aa748a6

위 로그로 보아 DB 생성관련 오류는 일단 넘어갔네요.

구글 로그인 구현을 진행중이신데 책을 보고 코드를 다시 점검하셔야 할 것 같네요.

application-oauth.properties 은 생성되었고 아래 설정은 제대로 들어가 있는지

spring.security.oauth2.client.registration.google.client-id={발급받으신클라이언트ID spring.security.oauth2.client.registration.google.client-Secret={발급받으신시크릿키} spring.security.oauth2.client.registration.google.scope=profile,email

application-oauth.properties 파일이 생성되어있다면

application.properties 에 해당 파일에 아래 설정이 추가되어있는지(include) 체크해보시기 바랍니다.

spring.profiles.include=oauth

beomth commented 3 years ago

와.............................. 성공했습니다....... 진짜진짜 너무 감사합니다 ㅠㅠ 몇년전 프로젝트라서, 아무도 안보실 줄 알았는데 이렇게 빠르게 답해주시다니... 그리고 피드백도 너무 구체적으로 해주셔서 해결 할 수 있었습니다!!

감사합니다!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

soulduo commented 3 years ago

잘 되었다니 다행이네요. 저도 학습중이라... 제가 겪어던 부분이랑 겹치는 부분이 있었기에 빨리 알려드릴 수 있었네요.

책이 나온지는 좀 되어서 앞으로 학습에도 난관(?)이 좀 있을거 같은데 잘 해결하시면서 학습 잘 하시길 바래요. 그럼 이만 슈슝

beomth commented 3 years ago

soulduo님!! 분명 어제까지만해도 h2 -console창 데이터베이스에도 접속이 됐는데, 오늘 다시 켜보니 접속이 안됩니다...ㅠㅠ

C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\bin\java.exe "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.1.3\lib\idea_rt.jar=60590:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2021.1.3\bin" -Dfile.encoding=UTF-8 -classpath C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\charsets.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\access-bridge-64.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\cldrdata.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\dnsns.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\jaccess.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\localedata.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\nashorn.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunec.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunjce_provider.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunmscapi.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\sunpkcs11.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\ext\zipfs.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jce.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jfr.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\jsse.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\management-agent.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\resources.jar;C:\Users\onvit\Desktop\java-1.8.0-openjdk-1.8.0.292-1.b10.ojdkbuild.windows.x86_64\jre\lib\rt.jar;C:\Users\onvit\Desktop\intell\out\production\classes;C:\Users\onvit\Desktop\intell\out\production\resources;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-data-jpa\2.3.1.RELEASE\5531a4cbd506f13a0b4483ed73c2e75a03d8da46\spring-boot-starter-data-jpa-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-mustache\2.3.1.RELEASE\a8678f002dc2b870fa8fe03278b8b30f1f7e9afe\spring-boot-starter-mustache-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-oauth2-client\2.3.1.RELEASE\3c89db40f21bbaa48341398bddfde1dbe2d89803\spring-boot-starter-oauth2-client-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-web\2.3.1.RELEASE\555c4f90141cdbc7637145e413bca0d622ba6796\spring-boot-starter-web-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.h2database\h2\1.4.200\f7533fe7cb8e99c87a43d325a77b4b678ad9031a\h2-1.4.200.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.session\spring-session-jdbc\2.3.0.RELEASE\7238cdd5b37ecd0ae441f1126b2336500e3633f\spring-session-jdbc-2.3.0.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.mariadb.jdbc\mariadb-java-client\2.6.0\7ada3fc7b30ae8fa4616f47ef6d505bdda933605\mariadb-java-client-2.6.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-aop\2.3.1.RELEASE\f42e23091d29bde8d1356e45cf13ad32dae51437\spring-boot-starter-aop-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-jdbc\2.3.1.RELEASE\800b64e76588ea88761ad9108cde762204805d66\spring-boot-starter-jdbc-2.3.1.RELEASE.jar;C:\Users\onvit.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\onvit.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\onvit.gradle\caches\modules-2\files-2.1\org.hibernate\hibernate-core\5.4.17.Final\3b90ecf6fe93a27a27de9671c9fb25d03ba3def7\hibernate-core-5.4.17.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-jpa\2.3.1.RELEASE\1b5e106add569913f0c776aca62f85d8e9ca8cee\spring-data-jpa-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-aspects\5.2.7.RELEASE\eb48f4ae3e1525179e1ccd10c0e09cfe5c27b8bb\spring-aspects-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter\2.3.1.RELEASE\e0d28696fea064578cb01da346232284f922eba4\spring-boot-starter-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.samskivert\jmustache\1.15\7b3b15951d13b774c76db2f4e14d977952f8b4d8\jmustache-1.15.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-client\5.3.3.RELEASE\1cb3848eb37222f851783c9b2355e1ada3144141\spring-security-oauth2-client-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-jose\5.3.3.RELEASE\ec95bc5b24451ab014fd98bf1bcd692b2d567bff\spring-security-oauth2-jose-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.sun.mail\jakarta.mail\1.6.5\d08124137cf42397d00b71b5985fd1dc248ac07f\jakarta.mail-1.6.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-config\5.3.3.RELEASE\4df881cc253f63e6aaff9dd66528c2dc18ca61e8\spring-security-config-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-core\5.3.3.RELEASE\abdd5a67b3fdc2f4a63023c3f60bbbf21c7c08cf\spring-security-core-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-json\2.3.1.RELEASE\8342003919c7e5a2470072595ea190cb8a9552c0\spring-boot-starter-json-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-tomcat\2.3.1.RELEASE\5b599d0da04e724479c22daa47f9bfd62533a2e9\spring-boot-starter-tomcat-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-webmvc\5.2.7.RELEASE\dcd97bcb0a2aa33f272b0031e4771134e327d942\spring-webmvc-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-web\5.2.7.RELEASE\50a27c77e1731f3b7af5c2ae7caf6fe59bcc309\spring-web-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.session\spring-session-core\2.3.0.RELEASE\f7cde6e3ceccad5c4f45a11c1cf6c36703888823\spring-session-core-2.3.0.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-context\5.2.7.RELEASE\7fd9c4ea311a5d9ab92770be7fc93cc53db334f9\spring-context-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-jdbc\5.2.7.RELEASE\847d31c90479a34e4e1fe7eeeb47ac89adce3438\spring-jdbc-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-aop\5.2.7.RELEASE\9cf69f8e888091684c05f0a287bb638502e90725\spring-aop-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.aspectj\aspectjweaver\1.9.5\1740dc9140103b796d1722668805fd4cf852780c\aspectjweaver-1.9.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.zaxxer\HikariCP\3.4.5\aa1a2c00aae8e4ba8308e19940711bb9525b103d\HikariCP-3.4.5.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\antlr\antlr\2.7.7\83cd2cd674a217ade95a4bb83a8a14f351f48bd0\antlr-2.7.7.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\net.bytebuddy\byte-buddy\1.10.11\16ac7e0d4afef10ac30db377e8151aff66a90e1c\byte-buddy-1.10.11.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml\classmate\1.5.1\3fe0bed568c62df5e89f4f174c101eab25345b6c\classmate-1.5.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\jaxb-runtime\2.3.3\c46b68a6e3a2d84ba4eb14c6a8a1a9a7be4048bc\jaxb-runtime-2.3.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.hibernate.common\hibernate-commons-annotations\5.1.0.Final\700aeedc4a2089816621948f0379e17cbd17d5db\hibernate-commons-annotations-5.1.0.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.jboss.logging\jboss-logging\3.4.1.Final\40fd4d696c55793e996d1ff3c475833f836c2498\jboss-logging-3.4.1.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.javassist\javassist\3.24.0-GA\d7466fc2e3af7c023e95c510f06448ad29b225b3\javassist-3.24.0-GA.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.jboss\jandex\2.1.3.Final\cd56603e39eb1421560b71daa584348ecfd9e0b8\jandex-2.1.3.Final.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.dom4j\dom4j\2.1.3\a75914155a9f5808963170ec20653668a2ffd2fd\dom4j-2.1.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-orm\5.2.7.RELEASE\32a76d825d8782ff278abe124ded9620444b4a74\spring-orm-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.data\spring-data-commons\2.3.1.RELEASE\5ae66c24c223315d5b31a45590d293e9145c18e9\spring-data-commons-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-tx\5.2.7.RELEASE\66faebf0da41c67b67d082efc98e92c40e83e6b\spring-tx-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-beans\5.2.7.RELEASE\5465ab17688ed62254fdef411cf883fd5c3b77a\spring-beans-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-core\5.2.7.RELEASE\56e14a3a5e2813534b5db2da1502cd58ab5bc61d\spring-core-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.slf4j\slf4j-api\1.7.30\b5a4b6d16ab13e34a88fae84c35cd5d68cac922c\slf4j-api-1.7.30.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-autoconfigure\2.3.1.RELEASE\6d679d6ba26235a0e81ca1d58f9c1024d9427411\spring-boot-autoconfigure-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot\2.3.1.RELEASE\ce8d8b6838ecceb68962b975b18682f4237ccf71\spring-boot-2.3.1.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.boot\spring-boot-starter-logging\2.3.1.RELEASE\3f242a91ffddf7485fde1367e1354c7e13024c8\spring-boot-starter-logging-2.3.1.RELEASE.jar;C:\Users\onvit.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\onvit.gradle\caches\modules-2\files-2.1\org.yaml\snakeyaml\1.26\a78a8747147d2c5807683e76ec2b633e95c14fe9\snakeyaml-1.26.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-oauth2-core\5.3.3.RELEASE\28aaf647a4afa4b4edd7693c0d9dba7b65fcb3e6\spring-security-oauth2-core-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework.security\spring-security-web\5.3.3.RELEASE\a7edf55294e312f4c09e372c333e94d96bcf7c70\spring-security-web-5.3.3.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\oauth2-oidc-sdk\7.1.1\e59759a715b08d084b21d8b2a43fb3bf5545387d\oauth2-oidc-sdk-7.1.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\nimbus-jose-jwt\8.18.1\b0078ab0deaa356e017719d62388a2aee3e18e4d\nimbus-jose-jwt-8.18.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.sun.activation\jakarta.activation\1.2.2\74548703f9851017ce2f556066659438019e7eb5\jakarta.activation-1.2.2.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-expression\5.2.7.RELEASE\c98d7b10f959f9bedfbbbd4d723cf7a1f17a1f71\spring-expression-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jsr310\2.11.0\168b2d0e11478b9f0a1bfccd62d6b5e8547b1e6f\jackson-datatype-jsr310-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.datatype\jackson-datatype-jdk8\2.11.0\cca91d6375258fd7ff2a6abb7bf91eef492bd606\jackson-datatype-jdk8-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.module\jackson-module-parameter-names\2.11.0\950a1e9a7c1093e7ffd92b216d5a0667f1e39058\jackson-module-parameter-names-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-databind\2.11.0\8f5aaf3878b0647ff3a16610af53b1a5c05d9f15\jackson-databind-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish\jakarta.el\3.0.3\dab46ee1ee23f7197c13d7c40fce14817c9017df\jakarta.el-3.0.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-websocket\9.0.36\33fa5038aa66be6e9cc188000c2188aa4dd33c85\tomcat-embed-websocket-9.0.36.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.tomcat.embed\tomcat-embed-core\9.0.36\cf6574dd9c4764e60c548b69da52fc07a5a0a9bd\tomcat-embed-core-9.0.36.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.springframework\spring-jcl\5.2.7.RELEASE\72282e1f89c58284632220437b5a1e8066c53d7d\spring-jcl-5.2.7.RELEASE.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.glassfish.jaxb\txw2\2.3.3\12f70b0ea4fc1ad45315e842f63f7c9a46f46530\txw2-2.3.3.jar;C:\Users\onvit.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\onvit.gradle\caches\modules-2\files-2.1\com.sun.istack\istack-commons-runtime\3.0.11\4293b5f4e4e89d598f62bb2ba73b32132e7c3a27\istack-commons-runtime-3.0.11.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-to-slf4j\2.13.3\966f6fd1af4959d6b12bfa880121d4a2b164f857\log4j-to-slf4j-2.13.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-classic\1.2.3\7c4f3c474fb2c041d8028740440937705ebb473a\logback-classic-1.2.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.slf4j\jul-to-slf4j\1.7.30\d58bebff8cbf70ff52b59208586095f467656c30\jul-to-slf4j-1.7.30.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.github.stephenc.jcip\jcip-annotations\1.0-1\ef31541dd28ae2cefdd17c7ebf352d93e9058c63\jcip-annotations-1.0-1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\content-type\2.0\12ebb1f6b7794684e4c56918fe59df3d7aab72b0\content-type-2.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\net.minidev\json-smart\1.3.1\69b3835e96d282ec85fc2e1517b8164c45ed639e\json-smart-1.3.1.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.nimbusds\lang-tag\1.4.4\1db9a709239ae473a69b5424c7e78d0b7108229d\lang-tag-1.4.4.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-annotations\2.11.0\c626020ae55d19c690d25cb51c1532ba76e5890f\jackson-annotations-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\com.fasterxml.jackson.core\jackson-core\2.11.0\f84302e14648f9f63c0c73951054aeb2ff0b810a\jackson-core-2.11.0.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\org.apache.logging.log4j\log4j-api\2.13.3\ec1508160b93d274b1add34419b897bae84c6ca9\log4j-api-2.13.3.jar;C:\Users\onvit.gradle\caches\modules-2\files-2.1\ch.qos.logback\logback-core\1.2.3\864344400c3d4d92dfeb0a305dc87d953677c03c\logback-core-1.2.3.jar com.jojoldu.book.springboot.Application

. _ _ /\ / '_ () \ \ \ \ ( ( )\ | ' | '| | ' \/ ` | \ \ \ \ \/ _)| |)| | | | | || (| | ) ) ) ) ' |__| .|| ||| |\, | / / / / =========|_|==============|__/=//// :: Spring Boot :: (v2.3.1.RELEASE)

2021-07-15 13:14:17.871 INFO 10572 --- [ main] com.jojoldu.book.springboot.Application : Starting Application on DESKTOP-0ED418T with PID 10572 (C:\Users\onvit\Desktop\intell\out\production\classes started by onvit in C:\Users\onvit\Desktop\intell) 2021-07-15 13:14:17.874 INFO 10572 --- [ main] com.jojoldu.book.springboot.Application : The following profiles are active: oauth 2021-07-15 13:14:18.587 INFO 10572 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFERRED mode. 2021-07-15 13:14:18.652 INFO 10572 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 57ms. Found 2 JPA repository interfaces. 2021-07-15 13:14:19.352 INFO 10572 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2021-07-15 13:14:19.362 INFO 10572 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2021-07-15 13:14:19.362 INFO 10572 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.36] 2021-07-15 13:14:19.462 INFO 10572 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2021-07-15 13:14:19.462 INFO 10572 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1520 ms 2021-07-15 13:14:19.680 INFO 10572 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2021-07-15 13:14:19.691 INFO 10572 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-07-15 13:14:19.937 INFO 10572 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-07-15 13:14:20.004 INFO 10572 --- [ task-1] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2021-07-15 13:14:20.070 INFO 10572 --- [ task-1] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.4.17.Final 2021-07-15 13:14:20.188 WARN 10572 --- [ 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 2021-07-15 13:14:20.257 INFO 10572 --- [ task-1] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.0.Final} 2021-07-15 13:14:20.371 INFO 10572 --- [ task-1] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL57Dialect Hibernate: drop table if exists posts Hibernate: drop table if exists user Hibernate: create table posts (id bigint not null auto_increment, create_date datetime(6), modified_date datetime(6), author varchar(255), content TEXT not null, title varchar(500) not null, primary key (id)) engine=InnoDB Hibernate: create table user (id bigint not null auto_increment, create_date datetime(6), modified_date datetime(6), email varchar(255) not null, name varchar(255) not null, picture varchar(255), role varchar(255) not null, primary key (id)) engine=InnoDB 2021-07-15 13:14:21.037 INFO 10572 --- [ task-1] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 2021-07-15 13:14:21.043 INFO 10572 --- [ task-1] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2021-07-15 13:14:21.208 INFO 10572 --- [ main] o.s.s.web.DefaultSecurityFilterChain : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@5626d18c, org.springframework.security.web.context.SecurityContextPersistenceFilter@5984feef, org.springframework.security.web.header.HeaderWriterFilter@4a8e6e89, org.springframework.security.web.authentication.logout.LogoutFilter@2ae62bb6, org.springframework.security.oauth2.client.web.OAuth2AuthorizationRequestRedirectFilter@5f14761c, org.springframework.security.oauth2.client.web.OAuth2LoginAuthenticationFilter@6f8aba08, org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter@3762c4fc, org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter@45e9b12d, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@23a918c7, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@2f4ba1ae, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@3dc95b8b, org.springframework.security.web.session.SessionManagementFilter@63d5874f, org.springframework.security.web.access.ExceptionTranslationFilter@1e1b061, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@76b47204] 2021-07-15 13:14:21.397 INFO 10572 --- [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page template: index 2021-07-15 13:14:21.556 INFO 10572 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path '' 2021-07-15 13:14:21.557 INFO 10572 --- [ main] DeferredRepositoryInitializationListener : Triggering deferred initialization of Spring Data repositories… 2021-07-15 13:14:22.073 INFO 10572 --- [ main] DeferredRepositoryInitializationListener : Spring Data repositories initialized! 2021-07-15 13:14:22.080 INFO 10572 --- [ main] s.a.ScheduledAnnotationBeanPostProcessor : No TaskScheduler/ScheduledExecutorService bean found for scheduled processing 2021-07-15 13:14:22.087 INFO 10572 --- [ main] com.jojoldu.book.springboot.Application : Started Application in 4.658 seconds (JVM running for 5.208) 2021-07-15 13:14:24.968 INFO 10572 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2021-07-15 13:14:24.968 INFO 10572 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2021-07-15 13:14:24.981 INFO 10572 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 13 ms

soulduo commented 3 years ago

DB도 잘 생성되었고 톰캣도 잘 작동하는 듯한데 브라우저 화면에 에러는 어떻게 뜨나요?

소스 코드 자체의 문제가 아닐 수도 있습니다.

브라우저 에러 코드를 아래와 매칭해 보고 원인을 유추해보세요.

https://developer.mozilla.org/ko/docs/Web/HTTP/Status

혹은 기억을 더듬어 분명 변경하신 부분이 없는지 다시 한번 생각해보시길 바래요.

사소한 부분에서 어이없게도 작동이 안되고 오동작하는 게 컴퓨터이다 보니...

beomth commented 3 years ago

제가 h2의 url을 properties에 적은 것과 다른 주소를 적어서 그랬었습니다..!! 답해주셔서 감사합니다!!