Druid的坑
原来数据源这么配置
<!--数据源配置-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${driverClassName}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
<property name="maxActive" value="10" />
<property name="minIdle" value="5" />
</bean>
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/ssmbuild?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=true
username=root
password=root
测试的时候报了一个奇怪的错误:
Caused by: java.sql.SQLException: Access denied for user 'jzhao'@'localhost' (using password: YES)
jzhao是我的主机名
问题出在jdbc.properties文件中变量的名字
下面为修改内容:
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/ssmbuild?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=true
jdbc.username=root
jdbc.password=root
<!--数据源-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="maxActive" value="10" />
<property name="minIdle" value="5" />
</bean>
所有参数前加“jdbc.”,这样就没问题!