spring jpa 多数据源 配置

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>

记录一下 以后备用