jpa+spring配置多数据源详解编程语言

http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd
version
配置mysql数据源
persistence unit name mysql transaction type RESOURCE_LOCAL
provider org.hibernate.ejb.HibernatePersistence provider
properties
property name hibernate.dialect value org.hibernate.dialect.MySQL5Dialect
property name hibernate.connection.driver_class value org.gjt.mm.mysql.Driver
property name hibernate.connection.username value root
property name hibernate.connection.password value mysql
property name hibernate.connection.url value jdbc:mysql://localhost:3306/test?useUnicode=true amp;characterEncoding=UTF-8
property name hibernate.hbm2ddl.auto value update
properties
persistence unit
配置oracle数据源
persistence unit name oracle transaction type RESOURCE_LOCAL
provider org.hibernate.ejb.HibernatePersistence provider
properties
property name hibernate.dialect value org.hibernate.dialect.Oracle10gDialect
property name hibernate.connection.driver_class value oracle.jdbc.driver.OracleDriver
property name hibernate.connection.username value test
property name hibernate.connection.password value test
property name hibernate.connection.url value jdbc:oracle:thin:@localhost:1521:orcl
property name hibernate.hbm2ddl.auto value update
properties
persistence unit
persistence

beans.xml

 xml version

 encoding

 UTF-8

 


 beans xmlns

 http://www.springframework.org/schema/beans

 
 xmlns:xsi

 http://www.w3.org/2001/XMLSchema-instance

 
 xmlns:aop

 http://www.springframework.org/schema/aop

 
 xmlns:context

 http://www.springframework.org/schema/context

 
 xmlns:tx

 http://www.springframework.org/schema/tx

 
 xsi:schemaLocation

 http://www.springframework.org/schema/beans

 


 http:

 www.springframework.org/schema/beans/spring-beans-2.5.xsd

 


 http:

 www.springframework.org/schema/tx 

 http://www.springframework.org/schema/tx/spring-tx-2.5.xsd

 


 http:

 www.springframework.org/schema/aop 

 http://www.springframework.org/schema/aop/spring-aop-2.5.xsd

 


 http:

 www.springframework.org/schema/context 

 http://www.springframework.org/schema/context/spring-context-2.5.xsd

 


 
 

 bean id

 entityManagerFactory

 class

 org.springframework.orm.jpa.LocalEntityManagerFactoryBean

 
 

 property name

 persistenceUnitName

 value

 mysql

 
 

 bean

 
 

 bean id

 entityManagerFactory2

 class

 org.springframework.orm.jpa.LocalEntityManagerFactoryBean

 
 

 property name

 persistenceUnitName

 value

 oracle

 
 

 bean

 
 
 

 bean id

 txManager

 class

 org.springframework.orm.jpa.JpaTransactionManager

 
 

 property name

 entityManagerFactory

 entityManagerFactory

 
 

 bean

 
 
 

 tx:annotation

 driven transaction

 manager

 txManager

 


 beans

 

PersonServiceTest测试类

 package

 junit.test;



 import

 javax.annotation.Resource;


 import

 javax.persistence.EntityManager;


 import

 javax.persistence.EntityManagerFactory;


 import

 javax.persistence.Persistence;


 import

 javax.persistence.PersistenceContext;



 import

 org.junit.Test;


 
 * 测试多数据源配置是否成功
 * 
 * 

 @author

 jiqinlin
 *
 

 


 public

 class

 PersonServiceTest {
 

 @PersistenceContext(unitName="mysql")
 

 private EntityManager mysqlEm;
 

 @PersistenceContext(unitName="oracle")
 

 private EntityManager oracleEm;

 


 
 @Test
 

 public

 void

 test() {
 EntityManagerFactory mysql 

 Persistence.createEntityManagerFactory(

 mysql

 );
 EntityManagerFactory oracle 

 Persistence.createEntityManagerFactory(

 oracle

 );
 System.out.println(mysql 

 oracle);
 
 }
}

 

运行时如果能打印出factory对象，表示多数据源配置成功，如下所示

原创文章，作者：Maggie-Hunter，如若转载，请注明出处：https://blog.ytso.com/16110.html

cjavamysqloraclexml