ailed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

/Users/jojungeun/Library/Java/JavaVirtualMachines/corretto-11.0.19/Contents/Home/bin/java -javaagent:/Applications/IntelliJ IDEA CE.app/Contents/lib/idea_rt.jar=52641:/Applications/IntelliJ IDEA CE.app/Contents/bin -Dfile.encoding=UTF-8 -classpath /Users/jojungeun/Documents/member/out/production/classes:/Users/jojungeun/Documents/member/out/production/resources:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-data-jpa/2.7.13/98aba6063ce411ae5e7ce263ce7c7012427559a6/spring-boot-starter-data-jpa-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-thymeleaf/2.7.13/b36514a2ba8b03510ea3163c7c1611d60a3adaeb/spring-boot-starter-thymeleaf-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-web/2.7.13/707bd743fa544ca06a78a657465c1ca0f5084ea4/spring-boot-starter-web-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-aop/2.7.13/bf09e5f88e4bed249795bf28b42d75d3df0391a1/spring-boot-starter-aop-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-jdbc/2.7.13/1b5dce56ea6f5657c0aada8d342beedfbdc6a65c/spring-boot-starter-jdbc-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/jakarta.transaction/jakarta.transaction-api/1.3.3/c4179d48720a1e87202115fbed6089bdc4195405/jakarta.transaction-api-1.3.3.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/jakarta.persistence/jakarta.persistence-api/2.2.3/8f6ea5daedc614f07a3654a455660145286f024e/jakarta.persistence-api-2.2.3.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.hibernate/hibernate-core/5.6.15.Final/ab14b7cef1fdff654ca81923048a6034d6c7cfa7/hibernate-core-5.6.15.Final.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.data/spring-data-jpa/2.7.13/cbbd710b12238366d3b7a79ecb429125665047da/spring-data-jpa-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-aspects/5.3.28/11670ae516772497e443a836421417d43422b12/spring-aspects-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter/2.7.13/5617ca04b06778877fb80d146dd2d0dd6adb23a8/spring-boot-starter-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.thymeleaf/thymeleaf-spring5/3.0.15.RELEASE/7170e1bcd1588d38c139f7048ebcc262676441c3/thymeleaf-spring5-3.0.15.RELEASE.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.thymeleaf.extras/thymeleaf-extras-java8time/3.0.4.RELEASE/36e7175ddce36c486fff4578b5af7bb32f54f5df/thymeleaf-extras-java8time-3.0.4.RELEASE.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-json/2.7.13/2fc4c73e9b8602e57d2ffc37545cc2822e948322/spring-boot-starter-json-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-tomcat/2.7.13/43a53425042f52d01a6c1557598863880c0d0042/spring-boot-starter-tomcat-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-webmvc/5.3.28/688bde13678e86028062f01dbcdf301308c449e7/spring-webmvc-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-web/5.3.28/e15c861a248f5ba41dd1ebc691e582bb5f3a2813/spring-web-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-aop/5.3.28/aada0ea72a3efee5f02f264f90329f7eddedf321/spring-aop-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.aspectj/aspectjweaver/1.9.7/158f5c255cd3e4408e795b79f7c3fbae9b53b7ca/aspectjweaver-1.9.7.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.zaxxer/HikariCP/4.0.3/107cbdf0db6780a065f895ae9d8fbf3bb0e1c21f/HikariCP-4.0.3.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-jdbc/5.3.28/9cff07e670a77c3943e77c7dc0120be0aa3d926e/spring-jdbc-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.hibernate.common/hibernate-commons-annotations/5.1.2.Final/e59ffdbc6ad09eeb33507b39ffcf287679a498c8/hibernate-commons-annotations-5.1.2.Final.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.jboss.logging/jboss-logging/3.4.3.Final/c4bd7e12a745c0e7f6cf98c45cdcdf482fd827ea/jboss-logging-3.4.3.Final.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/net.bytebuddy/byte-buddy/1.12.23/d470526e8c4566c04e9ae5d3ccb62d1a7aa58986/byte-buddy-1.12.23.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/antlr/antlr/2.7.7/83cd2cd674a217ade95a4bb83a8a14f351f48bd0/antlr-2.7.7.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.jboss/jandex/2.4.2.Final/1e1c385990b258ff1a24c801e84aebbacf70eb39/jandex-2.4.2.Final.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.fasterxml/classmate/1.5.1/3fe0bed568c62df5e89f4f174c101eab25345b6c/classmate-1.5.1.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.glassfish.jaxb/jaxb-runtime/2.3.8/c90a335a07c60db986f29d35b0f8ac0a18f0f989/jaxb-runtime-2.3.8.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-context/5.3.28/edf8ebfd637e3e10ec7fed697eb69f2a5229748a/spring-context-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-orm/5.3.28/127b548d81ea3b125b8c45a2b0ab14ffdac5a33a/spring-orm-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.data/spring-data-commons/2.7.13/a0df11c6e7463ab9cd32e127af78f3c65e6ba055/spring-data-commons-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-tx/5.3.28/c992220cd3139fe97f86c6e7a99cc2498c00e929/spring-tx-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-beans/5.3.28/4d232acbb7031963688cf28b1b34134937892c4f/spring-beans-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-core/5.3.28/5b7ec246fef72fdfbb0b4123956715ca89cc6ddf/spring-core-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-api/1.7.36/6c62681a2f655b49963a5983b8b0950a6120ae14/slf4j-api-1.7.36.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-autoconfigure/2.7.13/1b6b9605b1b116e32c372f3b9e15abf7bb17038c/spring-boot-autoconfigure-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot/2.7.13/d009fa51c7792c9e510da7e69329baf39591707d/spring-boot-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-logging/2.7.13/8a5e9bd6fa8341193a977d408b9a44faaa684c8d/spring-boot-starter-logging-2.7.13.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/jakarta.annotation/jakarta.annotation-api/1.3.5/59eb84ee0d616332ff44aba065f3888cf002cd2d/jakarta.annotation-api-1.3.5.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.yaml/snakeyaml/1.30/8fde7fe2586328ac3c68db92045e1c8759125000/snakeyaml-1.30.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.thymeleaf/thymeleaf/3.0.15.RELEASE/13e3296a03d8a597b734d832ed8656139bf9cdd8/thymeleaf-3.0.15.RELEASE.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.datatype/jackson-datatype-jsr310/2.13.5/8ba3b868e81d7fc6ead686bd2353859b111d9eaf/jackson-datatype-jsr310-2.13.5.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.module/jackson-module-parameter-names/2.13.5/a401a99e7a45450fd3ef76e82ba39005fd1a8c22/jackson-module-parameter-names-2.13.5.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.datatype/jackson-datatype-jdk8/2.13.5/1278f38160812811c56eb77f67213662ed1c7a2e/jackson-datatype-jdk8-2.13.5.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.core/jackson-databind/2.13.5/aa95e46dbc32454f3983221d420e78ef19ddf844/jackson-databind-2.13.5.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.apache.tomcat.embed/tomcat-embed-websocket/9.0.76/548160ca33e74e61178b5fbc666bf26ef56cbf7c/tomcat-embed-websocket-9.0.76.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.apache.tomcat.embed/tomcat-embed-core/9.0.76/1672ec66d44c68829416c946ab034cb1a92a5629/tomcat-embed-core-9.0.76.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.apache.tomcat.embed/tomcat-embed-el/9.0.76/74bf8925f713a52c2af19fff6df55d80ef87166c/tomcat-embed-el-9.0.76.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-expression/5.3.28/d049216b1a73b939b36bbf5cc7ce734cace7b245/spring-expression-5.3.28.jar:/Users/jojungeun/.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:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.glassfish.jaxb/txw2/2.3.8/66e0297f1196f0d15a776e699de1b8e6ac5d44dd/txw2-2.3.8.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.sun.istack/istack-commons-runtime/3.0.12/cbbe1a62b0cc6c85972e99d52aaee350153dc530/istack-commons-runtime-3.0.12.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.springframework/spring-jcl/5.3.28/d67e8b213aa08a0f3d71e547fb4345372d819d36/spring-jcl-5.3.28.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/ch.qos.logback/logback-classic/1.2.12/d4dee19148dccb177a0736eb2027bd195341da78/logback-classic-1.2.12.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.apache.logging.log4j/log4j-to-slf4j/2.17.2/17dd0fae2747d9a28c67bc9534108823d2376b46/log4j-to-slf4j-2.17.2.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.slf4j/jul-to-slf4j/1.7.36/ed46d81cef9c412a88caef405b58f93a678ff2ca/jul-to-slf4j-1.7.36.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.attoparser/attoparser/2.0.5.RELEASE/a93ad36df9560de3a5312c1d14f69d938099fa64/attoparser-2.0.5.RELEASE.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.unbescape/unbescape/1.1.6.RELEASE/7b90360afb2b860e09e8347112800d12c12b2a13/unbescape-1.1.6.RELEASE.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.core/jackson-annotations/2.13.5/136f77ab424f302c9e27230b4482e8000e142edf/jackson-annotations-2.13.5.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.core/jackson-core/2.13.5/d07c97d3de9ea658caf1ff1809fd9de930a286a/jackson-core-2.13.5.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/ch.qos.logback/logback-core/1.2.12/1d8e51a698b138065d73baefb4f94531faa323cb/logback-core-1.2.12.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/org.apache.logging.log4j/log4j-api/2.17.2/f42d6afa111b4dec5d2aea0fe2197240749a4ea6/log4j-api-2.17.2.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.mysql/mysql-connector-j/8.0.33/9e64d997873abc4318620264703d3fdb6b02dd5a/mysql-connector-j-8.0.33.jar:/Users/jojungeun/.gradle/caches/modules-2/files-2.1/com.sun.activation/jakarta.activation/1.2.2/74548703f9851017ce2f556066659438019e7eb5/jakarta.activation-1.2.2.jar com.member.member.MemberApplication

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::               (v2.7.13)

2023-07-09 10:23:31.667  INFO 29632 --- [           main] com.member.member.MemberApplication      : Starting MemberApplication using Java 11.0.19 on jojungeun-ui-MacBookPro.local with PID 29632 (/Users/jojungeun/Documents/member/out/production/classes started by jojungeun in /Users/jojungeun/Documents/member)
2023-07-09 10:23:31.669  INFO 29632 --- [           main] com.member.member.MemberApplication      : No active profile set, falling back to 1 default profile: "default"
2023-07-09 10:23:31.965  INFO 29632 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2023-07-09 10:23:31.973  INFO 29632 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 3 ms. Found 0 JPA repository interfaces.
2023-07-09 10:23:32.243  INFO 29632 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8081 (http)
2023-07-09 10:23:32.249  INFO 29632 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2023-07-09 10:23:32.249  INFO 29632 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.76]
2023-07-09 10:23:32.316  INFO 29632 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2023-07-09 10:23:32.316  INFO 29632 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 617 ms
2023-07-09 10:23:32.348  WARN 29632 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Unsatisfied dependency expressed through method 'dataSourceScriptDatabaseInitializer' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'dataSource' threw exception; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class
2023-07-09 10:23:32.350  INFO 29632 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2023-07-09 10:23:32.360  INFO 29632 --- [           main] ConditionEvaluationReportLoggingListener : 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2023-07-09 10:23:32.367 ERROR 29632 --- [           main] o.s.b.d.LoggingFailureAnalysisReporter   : 

***************************
APPLICATION FAILED TO START
***************************

Description:

Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

Reason: Failed to determine a suitable driver class


Action:

Consider the following:
	If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
	If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).


Process finished with exit code 1

오랜만에 IntelliJ로 회원게시판 만들어 보려고 하는데

Spring start.io에서 MySqlDriver를 의존성 추가를 해주었더니

아래와 같은 오류가 발생했다.

 

대충 읽어보면

DataBase에 연결할 때 필요한 정보가 없기 때문인데 생각해보니 설정해준적이 없지요..

프로젝트를 처음으로 구성할 때 생길만한 문제점이긴 할 것같다.

 

어떻게 해결해볼까?

DataBase 연결 설정정보 (아이디와 비밀번호)를

application.yml파일에서 추가해주겠다.

먼저 MySql을 실행해서 포트 번호를 다시한번 확인해주고(아오 오타)

계정이랑 비밀번호를 만들어준 후에 권한도 부여해준다(또 오타..)

위와 같이 경로 설정과 아이디 비밀번호를 넣어주었다.

server:
  port: 8081

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/member/serverTimezone=Asia/Seoul&characterEncoding=UTF-8
    username: user_jjk
    password: 1234
  thymeleaf:
    cache: false

  #spring data jpa설정
  jpa:
    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
    open-in-view: false
    show-sql: true
    hibernate:
      ddl-auto: create

다시 돌려보면..

잘 연결 되었다.

아직 써보지는 않고 연결만 해둔 상태라 잘 모르겠다..

쓰면서 고쳐봐야지뭐..