we failed to succeed more than the maximum number of allowed acquisition attempts (2). Last acquisit-蒲公英云

we failed to succeed more than the maximum number of allowed acquisition attempts (2). Last acquisit

jdbc 连接数据库出现错误：

we failed to succeed more than the maximum number of allowed acquisition attempts (2). Last acquisition attempt exception: java.sql.SQLException: Access denied for user XXXXXX(using password: YES)

意思是：我们连接数据库失败，尝试了最大的连接次数都没有成功，上一次获取的连接异常是：访问user XXX被拒绝。。。

jdbc.properties文件配置

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=UTF-8
username=root
password=root

spring.xml 文件数据库配置：

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${driver}"/>
        <property name="jdbcUrl" value="${url}"/>
        <property name="user" value="${username}"/>
        <property name="password" value="${password}"/>

确认了 driver、url、username、password信息是正确的，若是仍然有此错误，原因可能是没有读取到username 这些信息，可以修改jdbc.properties 文件和spring.xml 文件如下：

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=root
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>