spring-mybatis框架整合引入properties配置文件报错问题

spring-mybatis框架整合引入properties配置文件报错问题

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  xmlns:p="http://www.springframework.org/schema/p" 
  xmlns:aop="http://www.springframework.org/schema/aop" 
  xmlns:context="http://www.springframework.org/schema/context" 
  xmlns:tx="http://www.springframework.org/schema/tx" 
  xsi:schemaLocation="http://www.springframework.org/schema/beans 
  http://www.springframework.org/schema/beans/spring-beans-3.2.xsd 
  http://www.springframework.org/schema/aop 
  http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
  http://www.springframework.org/schema/context 
  http://www.springframework.org/schema/context/spring-context-3.2.xsd 
  http://www.springframework.org/schema/tx 
  http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
<!-- 读取properties配置文件 -->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!-- JDNI获取数据源(DBCP连接池) -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" 
destroy-method="close" scope="singleton">
<property name="driverClassName" value="${driverClassName}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</bean>

<!-- 事务管理 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>

<!-- 配置mybatis sqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:Mybatis-config.xml" />
<property name="mapperLocations" value="classpath:cn/bdqn/dao/*.xml" />
</bean>

<!-- sqlSessionTemplate -->
<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
<!-- spring使用构造注入方式注入 -->
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
<!-- 把sqlSessionTemplate注入到测试类 -->
<bean id="employeeDaoTest" class="cn.bdqn.util.EmployeeDaoTest">
<property name="sqlSessionTemplate" ref="sqlSessionTemplate" />
</bean>
</beans>

上述配置文件运行后则会报如下错误：org.apache.commons.dbcp.SQLNestedException:Cannot create PoolableConnectionFactory (Access denied for user 'Administrator'@'localhost' (using password: YES))

解决办法：将上述配置文件中的<context:property-placeholder location="classpath:jdbc.properties"/>改为

   <bean id="propertyConfigurer"
          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:jdbc.properties" />
    </bean>

则上述错误便解决。

（有不对的地方，还望大家批评指正）