SQLNestedException: Cannot create PoolableConnectionFactory

 

 

eGov web project로 maria db 연결하는 과정 중 발생

 

### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not connect to address=(host=127.0.0.1)(port=3309)(type=master) : (conn=6) Access denied for user 'wsy'@'localhost' (using password: YES) Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding')

 

연결 설정하는 이름을 잘못 적음

<!-- mariadb (POM에서 commons-dbcp, mysql-connector-java 관련 라이브러리 설정 ) -->

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="org.mariadb.jdbc.Driver"/>
    <property name="url" value="jdbc:mariadb://127.0.0.1:3309/boarddb" />
    <property name="username" value="root"/> <!-- 세션 이름이 아님...계정 -->
    <property name="password" value="(비밀번호)"/>
</bean>