数据源切换的几点思考

比如：zxdfk_risk_control_dvlp用户 切换到  zxdfk_risk_control_dvlp0130用户

一、在后台创建数据源（登录后台新增）

1.

2.

3.

二、添加用户到F:\jboss-4.0.2\server\default\conf下面的jdbczxd.properties属性文件

# Properties file with JDBC-related settings.
# Applied by PropertyPlaceholderConfigurer from "dataAccessContext-local.xml".
# Targeted at system administrators, to avoid touching the context XML files.

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
################开发##########################
jdbc.url=jdbc:oracle:thin:@192.168.18.99:1521:zxdoradb
jdbc.username=zxd_risk_control_dvlp0130
jdbc.password=zxd_risk_control_dvlp0130

#jdbc.url=jdbc:oracle:thin:@192.168.18.99:1521:zxdoradb
#jdbc.username=zxdfk_risk_control_dvlp
#jdbc.password=zxdfk_risk_control_dvlp
################生产##########################
#jdbc.url=jdbc:oracle:thin:@192.168.18.101:1521:zxdoradb101
#jdbc.username=zxdconnt
#jdbc.password=zxdconnt

三、添加用户到F:\jboss-4.0.2\server\default\conf下面的createDBConfig.xml属性文件
  <bean id="dataSource_08611" parent="parentDataSource">
    <!--数据源 dataSource_08611-->
    <property name="url" value="jdbc:oracle:thin:@192.168.18.99:1521:zxdoradb"/>
    <property name="username" value="zxd_risk_control_dvlp0130"/>
    <property name="password" value="zxd_risk_control_dvlp0130"/>
  </bean>

四、登录的时候选择08611