1.maven 项目里面的关于数据库的spring 配置文件如下(起名:spring-db.xml),我们使用的是 maven 的占位符$[key]:
<!-- 连接池 -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="driverClassName" value="$[mysql.master.driverClassName]" />
<property name="url" value="$[mysql.master.url]" />
<property name="username" value="$[mysql.master.username]" />
<property name="password" value="$[mysql.master.password]" />
<property name="initialSize" value="$[mysql.master.initialSize]" />
<property name="maxActive" value="$[mysql.master.maxActive]" />
<property name="minIdle" value="$[mysql.master.minIdle]" />
<property name="maxIdle" value="$[mysql.master.maxIdle]" />
<property name="validationQuery" value="$[mysql.master.validationQuery]" />
<property name="testOnBorrow" value="$[mysql.master.testOnBorrow]" />
<property name="testOnReturn" value="$[mysql.master.testOnReturn]" />
<property name="testWhileIdle" value="$[mysql.master.testWhileIdle]" />
<property name="minEvictableIdleTimeMillis" value="$[mysql.master.minEvictableIdleTimeMillis]" />
<property name="timeBetweenEvictionRunsMillis" value="$[mysql.master.timeBetweenEvictionRunsMillis]" />
</bean>
2.配置文件如下(起名:db.properties):
mysql.master.driverClassName=com.mysql.jdbc.Driver
mysql.master.url=jdbc:mysql://10.0.1.102:3306/test?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
mysql.master.username=xxx
mysql.master.password=xxx
mysql.master.initialSize=5
mysql.master.minIdle=10
mysql.master.maxActive=100
mysql.master.maxIdle=30
mysql.master.validationQuery=select 1
mysql.master.testOnBorrow=true
mysql.master.testOnReturn=false
mysql.master.testWhileIdle=true
mysql.master.minEvictableIdleTimeMillis=300000
mysql.master.timeBetweenEvictionRunsMillis=60000
3.问题:
我们修改了db.properties之后,spring-db.xml 文件并没有重新的加载修改后的信息:例如我们把数据库的地址修改为 :
mysql.master.url=jdbc:mysql://localhost:3306/test?autoReconnect=true&useUnicode=true&characterEncoding=utf-
可是spring-db.xml 文件取到的占位符信息依然是 10.0.1.102
4.解决办法:
- 清理项目:选中项目->Project->Clean
- 把项目从 tomcat 里面移除掉:选中项目->remove
- 清理 tomcat:选中 tomcat->右键->Clean…
- 重新部署项目到 tomcat