1、spring-config文件配置
1)配置了两个数据源
<!-- 数据源配置 -->
<bean id="dataSourceOrder" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<!-- 设置JDBC驱动名称 -->
<property name="driverClassName" value="${mysql.jdbc.driver}" />
<!-- 设置JDBC连接URL -->
<property name="url" value="${mysql.jdbc.url}" />
<!-- 设置数据库用户名 -->
<property name="username" value="${mysql.jdbc.username}" />
<!-- 设置数据库密码 -->
<property name="password" value="${mysql.jdbc.password}" />
<!-- 设置连接池初始值 -->
<property name="initialSize" value="5" />
<!-- 设置连接池最大值 -->
<!-- <property name="maxActive" value="100" /> -->
<property name="maxActive" value="${jdbc.maxActive}" />
<!-- 设置连接池最小空闲值 -->
<!-- <property name="minIdle" value="20" /> -->
<property name="minIdle" value="${jdbc.minIdle}" />
<!-- 设置连接池最大空闲值 -->
<!-- <property name="maxIdle" value="50" /> -->
<property name="maxIdle" value="${jdbc.maxIdle}" />
<!-- 2014-08-21 begin add by xiaonanxiang -->
<property name="maxWait" value="${jdbc.maxWait}" />
<property name="timeBetweenEvictionRunsMillis" value="60000" />
<property name="minEvictableIdleTimeMillis" value="1800000" />
<property name="removeAbandoned" value="true" />
<property name="removeAbandonedTimeout" value="300" />
<!-- 2014-08-21 end add by xiaonanxiang -->
</bean>
<!-- 数据源配置 -->
<!-- dataSourceMySql -->
<bean id="dataSourceSupport" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<!-- 设置JDBC驱动名称 -->
<property name="driverClassName" value="${mysql.jdbc.driver}" />
<!-- 设置JDBC连接URL -->
<property name="url" value="jdbc\:mysql\://10.0.4.10\:3306/dusto_support" />
<!-- 设置数据库用户名 -->
<property name="username" value="${mysql.jdbc.username}" />
<!-- 设置数据库密码 -->
<property name="password" value="${mysql.jdbc.password}" />
<!-- 设置连接池初始值 -->
<property name="initialSize" value="5" />
<!-- 设置连接池最大值 -->
<!-- <property name="maxActive" value="100" /> -->
<property name="maxActive" value="${jdbc.maxActive}" />
<!-- 设置连接池最小空闲值 -->
<!-- <property name="minIdle" value="20" /> -->
<property name="minIdle" value="${jdbc.minIdle}" />
<!-- 设置连接池最大空闲值 -->
<!-- <property name="maxIdle" value="50" /> -->
<property name="maxIdle" value="${jdbc.maxIdle}" />
<!-- 2014-08-21 begin add by xiaonanxiang -->
<property name="maxWait" value="${jdbc.maxWait}" />
<property name="timeBetweenEvictionRunsMillis" value="60000" />
<property name="minEvictableIdleTimeMillis" value="1800000" />
<property name="removeAbandoned" value="true" />
<property name="removeAbandonedTimeout" value="300" />
<!-- 2014-08-21 end add by xiaonanxiang -->
</bean>
2、动态数据源路由
1)需要自定义一个 DynamicDataSource 继承AbstractRoutingDataSource 实现 determineCurrentLookupKey()的方法
package com.ibm.sc.admin.core;
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
public class DynamicDataSource extends AbstractRoutingDataSource {
@Override
protected Object determineCurrentLookupKey() {
return DatabaseContextHolder.getCustomerType();
}
}
<!-- 数据源路由 -->
<bean id="dataSource" class="com.ibm.sc.admin.core.DynamicDataSource">
<property name="targetDataSources">
<map key-type="java.lang.String">
<entry key="dataSourceOrder" value-ref="dataSourceOrder" />
<entry key="dataSourceSupport" value-ref="dataSourceSupport" />
</map>
</property>
<property name="defaultTargetDataSource" ref="dataSourceOrder" />
</bean>
2、DataSourceInterceptor 数据源拦截类
package com.ibm.sc.admin.core;
import org.aspectj.lang.JoinPoint;
public class DataSourceInterceptor {
public void setdataSourceMysql(JoinPoint jp) {
DatabaseContextHolder.setCustomerType("dataSourceOrder"); // dataSourceOrder 和数据源路由xml中配置的名称一致
}
public void setdataSourceOracle(JoinPoint jp) {
DatabaseContextHolder.setCustomerType("dataSourceSupport");
}
}
3、DatabaseContextHolder 类
package com.ibm.sc.admin.core;
public class DatabaseContextHolder {
private static final ThreadLocal<String> contextHolder = new ThreadLocal<String>();
public static void setCustomerType(String customerType) {
contextHolder.set(customerType);
}
public static String getCustomerType() {
return contextHolder.get();
}
public static void clearCustomerType() {
contextHolder.remove();
}
}
4、entityManagerFactory 配置 * 可能根据需要会有所不一样
<bean id="blPersistenceUnitManager" class="com.ibm.sc.jpa.MergingPersistenceUnitManager">
<property name="persistenceUnitPostProcessors">
<bean class="com.ibm.sc.jpa.MergingPersistenceUnitPostProcessor" />
</property>
<property name="defaultDataSource" ref="dataSource" />
<property name="persistenceXmlLocations">
<list>
<value>classpath*:META-INF/persistence-sc.xml</value>
<value>classpath*:META-INF/persistence-oms.xml</value>
</list>
</property>
</bean>
<bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="jpaVendorAdapter">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<property name="showSql" value="false" />
<property name="generateDdl" value="false" />
<property name="databasePlatform" value="org.hibernate.dialect.MySQL5Dialect" />
</bean>
</property>
<property name="persistenceUnitManager" ref="blPersistenceUnitManager" />
<property name="persistenceUnitName" value="AppPU" />
</bean>
记录一下 以后备用