SpringBoot 다중 DB 연동 오류!

Question

오류 내용Error creating bean with name 'testController' defined in file [경로\TestController.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'testService' defined in file [경로\TestService.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'testMapper' defined in file [경로\TestMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Unsatisfied dependency expressed through method 'sqlSessionFactory' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'firstDataSource' defined in class path resource [경로/MyCompleteDataSourcesConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'firstDataSource' threw exception; nested exception is java.lang.IllegalStateException: Cannot load driver class: com.mysql.cj.jdbc.TestMyCompleteDataSourcesConfiguration.java&#64;Configuration(proxyBeanMethods &#61; false) public class MyCompleteDataSourcesConfiguration { &#64;Bean &#64;Primary &#64;ConfigurationProperties(&#34;spring.datasource.first&#34;) public DataSourceProperties firstDataSourceProperties() { return new DataSourceProperties(); } &#64;Bean &#64;Primary &#64;ConfigurationProperties(&#34;spring.datasource.first.configuration&#34;) public HikariDataSource firstDataSource(DataSourceProperties firstDataSourceProperties) { return firstDataSourceProperties.initializeDataSourceBuilder().type(HikariDataSource.class).build(); } &#64;Bean &#64;ConfigurationProperties(&#34;spring.datasource.second&#34;) public DataSourceProperties secondDataSourceProperties() { return new DataSourceProperties(); } &#64;Bean &#64;ConfigurationProperties(&#34;spring.datasource.second.configuration&#34;) public BasicDataSource secondDataSource(DataSourceProperties secondDataSourceProperties) { return secondDataSourceProperties.initializeDataSourceBuilder().type(BasicDataSource.class).build(); } }application.ymlspring: datasource: first: driver-class-name: oracle.jdbc.OracleDriver url: jdbc:oracle:thin: username: password: second: driver-class-name: com.mysql.jdbc.Drive url: jdbc:mysql: username: password: 안녕하세요~SpringBoot에서 개발중인 개발자 입니다다중 db를 연결 하고자 하는데 [ oracle , mysql ]열심히 구글링 해서 하는 방법을 찾았는데 위에 처럼 오류가 나서요...ㅠㅠ정보는 지우고 최대한 소스 고유 햇습니다~ㅠㅠ확인 부탁드립니다!!

양반후반 · Answer

Cannot load driver class: com.mysql.cj.jdbc.Test

Clickin · Answer

옮겨적으면서 틀리셨는진 모르겠지만 mysql driver-class-name이 틀렸고Cannot load driver class: com.mysql.cj.jdbc.Test 를 보면 mysql 드라이버를 제대로 불러오지 못해서 생기는 문제라는걸 알 수 있네요

SpringBoot 다중 DB 연동 오류!

2개의 답변

기술 목록