[오류 해결] Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

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




다음 문구는 DB를 테스트 연결하기 위해 스프링 부트 프로젝트를 구성하였을때 나왔던 에러이다.

직역하자면 DB 환경설정을 제대로 하지 않으면 그 DataSoucre url을 찾지못해서 오류가 발생한다는 의미이다.



나의 경우 application.yml을 통해 DB관련 설정을 완료했다고 생각했기에 의아했다.

 

 

 

 

[에러 발생 예시 코드]


spring: 
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@공유환경 ip주소 :접속포트:접속 DB
    username: 접속 아이디
    password: 접속 비밀번호
   profiles:
    active: local




[해결 방법]

.yml의 경우 인간친화적이지만, 문법은 엄격한 편이라 이에 조금이라도 지키지 않으면 에러가 발생한다.

그러므로 띄어쓰기나 줄바꿈들을 명확히 해야하는데 내가 별도의 profiles을 설정해본다는 것이
줄바꿈을 제대로 해주지 않아서 문제가 발생했다.



따라서




spring:
   datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@공유환경 ip주소 :접속포트:접속 DB
    username: 접속 아이디
    password: 접속 비밀번호
    
    profiles:
    active: local



혹은


spring:
   datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@공유환경 ip주소 :접속포트:접속 DB
    username: 접속 아이디
    password: 접속 비밀번호


---
spring:
  profiles:
    active: local




등의 구문을 명확히 하면 문제가 해결된다.



+)만약 DataSoucre와 관련된 오류가 난다면 .yml등의 문법을 다시보자.