[MySQL] Loading class 'com.mysql.jdbc.Driver'. This is deprecated. The new driver class is 'com.mysql.cj.jdbc.Driver'.

24 Jan 2022 in Spring on Spring 개발 기록

springboot yml 설정 시에 Error: Loading class `com.mysql.jdbc.Driver’. This is deprecated.

원인

Loading class `com.mysql.jdbc.Driver’. This is deprecated.

에러

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

해결

spring boot 2 이상 버전과 mysql-connector-java 6이상의 버전 문제로
JDBC 연결할 때 드라이버 정보를 com.mysql.jdbc.Driver에서 com.mysql.cj.jdbc.Driver로 바꿔주면 된다.

log4jdbc properties에 추가

log4jdbc.auto.load.popular.drivers=false
log4jdbc.drivers=com.mysql.cj.jdbc.Driver

[참고]

https://ildann.tistory.com/12