最近因项目原因需要把 保存本地数据库的同时保存到其他数据库中, 这里就需要用到多数据源的技术。下面贴上各个配置文件的代码。
persistence.xml
<!-- 指定本地数据库持久化单元名称和事务类型,其他在Spring中配置 --> <persistence-unit name="persistenceUnit" transaction-type="RESOURCE_LOCAL"/> <!-- 指定远程数据库持久化单元名称和事务类型,其他在Spring中配置 --> <persistence-unit name="remoteUnit" transaction-type="RESOURCE_LOCAL"/>
applicationContext.xml
<!-- 本地数据源 C3PO --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" lazy-init="true"> <property name="driverClass" value="${jdbc.driver}"/> <property name="jdbcUrl" value="${jdbc.url}"/> <property name="user" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <property name="maxIdleTime" value="${jdbc.maxIdleTime}"/> <property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}"/> </bean> <!-- 定义实体管理器工厂,提供注解注入,使用方法如下: @PersistenceContext private EntityManager entityManager; --> <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="persistenceXmlLocation" value="classpath:persistence.xml"/> <property name="persistenceUnitName" value="persistenceUnit"/> <property name="jpaDialect"> <bean id="jpaDialect" class="org.springframework.orm.jpa.vendor.HibernateJpaDialect"/> </property> <property name="jpaVendorAdapter"> <!-- jpa持久化实现厂商,这里为hibernate --> <bean id="hibernateJpaVendorAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"> <!-- 自动输出schema创建DDL语句 --> <property name="generateDdl" value="true"/> <property name="database" value="MYSQL"/> <property name="databasePlatform" value="org.hibernate.dialect.MySQL5InnoDBDialect"/> <property name="showSql" value="false"/> </bean> </property> <property name="packagesToScan"> <list> <value>com.fpi.safety.common.entity.po</value> </list> </property> <property name="jpaPropertyMap"> <map> <!-- To enable Hibernate's second level cache and query cache settings --> <entry key="hibernate.max_fetch_depth" value="4" /> <entry key="hibernate.cache.use_second_level_cache" value="true" /> <entry key="hibernate.cache.use_query_cache" value="true" /> <entry key="hibernate.cache.region.factory_class" value="org.hibernate.cache.ehcache.EhCacheRegionFactory" /> </map> </property> </bean> <!-- 配置事务管理器 --> <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <!-- 对标注@Transactional注解的Bean进行加工处理,以织入事务管理切面 --> <tx:annotation-driven transaction-manager="transactionManager" /> <!-- 远程数据源 C3PO --> <bean id="dataSource2" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" lazy-init="true"> <property name="driverClass" value="${jdbc2.driver}"/> <property name="jdbcUrl" value="${jdbc2.url}"/> <property name="user" value="${jdbc2.username}"/> <property name="password" value="${jdbc2.password}"/> <property name="maxIdleTime" value="${jdbc2.maxIdleTime}"/> <property name="idleConnectionTestPeriod" value="${jdbc2.idleConnectionTestPeriod}"/> </bean> <bean id="entityManagerFactory2" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="persistenceXmlLocation" value="classpath:persistence.xml"/> <property name="persistenceUnitName" value="remoteUnit" /> <property name="dataSource" ref="dataSource2" /> <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"> <property name="database" value="MYSQL" /> <property name="showSql" value="true" /> </bean> </property> <property name="jpaPropertyMap"> <map> <!-- To enable Hibernate's second level cache and query cache settings --> <entry key="hibernate.max_fetch_depth" value="4" /> <entry key="hibernate.cache.use_second_level_cache" value="true" /> <entry key="hibernate.cache.use_query_cache" value="true" /> <entry key="hibernate.cache.region.factory_class" value="org.hibernate.cache.ehcache.EhCacheRegionFactory" /> </map> </property> </bean> <!-- 配置事务管理器 --> <bean id="transactionManager2" class="org.springframework.orm.jpa.JpaTransactionManager"> <property name="entityManagerFactory" ref="entityManagerFactory2" /> <qualifier value="remoteTran"/> </bean> <tx:annotation-driven transaction-manager="transactionManager2" />
serviceImpl.java
public EntityManager entityManager; private EntityManagerFactory emf; /** * @Title:setEntityManagerFactory * @Description:远程数据库实体管理工厂 * @param emf */ @Transactional(value="remoteUnit") @PersistenceUnit(unitName="remoteUnit") public void setEntityManagerFactory(EntityManagerFactory emf) { this.emf = emf; this.entityManager = emf.createEntityManager(); } /*远程数据库保存操作*/ @Override public DevFactor remoteSaveOrUpdate(DevFactor devFactor) { entityManager.getTransaction().begin(); entityManager.merge(devFactor); entityManager.getTransaction().commit(); return devFactor; }