[MariaDB] Caught exception while allowing TestExecutionListener 해결방법 [driverClassName의 value 값 확인하기]

---

- Caught exception while allowing TestExecutionListener 해결방법

Spring에 MariaDB 연동 세팅하면서 에러가 발생하였다. / 해결하기 위해 하루종일 골머리를 썩혔다..😂😂

---

INFO : com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
00:32:11.825 [main] ERROR org.springframework.test.context.TestContextManager - Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.DependencyInjectionTestExecutionListener@554e218] to prepare test instance [com.crizen.test.DBConnectionTest@1608bcbd]
java.lang.IllegalStateException: Failed to load ApplicationContext
at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:125) ~[spring-test-5.0.7.RELEASE.jar:5.0.7.RELEASE]
at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:108) ~[spring-test-5.0.7.RELEASE.jar:5.0.7.RELEASE]

... 
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in URL [file:src/main/webapp/WEB-INF/spring/root-context.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is java.lang.RuntimeException: Driver net.sf.log4jdbc.sql.jdbcapi.DriverSpy claims to not accept jdbcUrl, jdbc:mariadb://localhost:3306/counsel
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:282) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
...
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is java.lang.RuntimeException: Driver net.sf.log4jdbc.sql.jdbcapi.DriverSpy claims to not accept jdbcUrl, jdbc:mariadb://localhost:3306/counsel
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:182) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:117) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:275) ~[spring-beans-5.0.7.RELEASE.jar:5.0.7.RELEASE]
...
Caused by: java.lang.RuntimeException: Driver net.sf.log4jdbc.sql.jdbcapi.DriverSpy claims to not accept jdbcUrl, jdbc:mariadb://localhost:3306/counsel
at com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:110) ~[HikariCP-4.0.3.jar:?]
at com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:331) ~[HikariCP-4.0.3.jar:?]
...

---

- 해결 방법

@WebAppConfiguration을 붙여도 해결되지 않았는데, 아래 글을 보며 에러를 해결하였다. driverClassName의 value 값이 문제였다.

 

 

Spring Mybatis + MariaDB(HikariCP) 설정

 

root-context.xml에서 driverClassName이 문제였다.

mariadb.jdbc.Driver로 변경

DB가 정삭적으로 연동되었다..!!😭😭

---

해결하고 나니, 에러 메시지에서도 뭐가 문제였는지가 보였다.