Configuração: Spring 3 + JPA (Múltiplos Database)

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0"
	xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
	<persistence-unit name="sistema" transaction-type="RESOURCE_LOCAL">
		<non-jta-data-source>java:/comp/env/jdbc/sistema</non-jta-data-source>
		<class>sistema.dominio.Banco</class>
		<exclude-unlisted-classes />
		<properties>
			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
			<property name="hibernate.show_sql" value="true" />
			<property name="hibernate.format_sql" value="false" />
		</properties>
	</persistence-unit>
	<persistence-unit name="puteste" transaction-type="RESOURCE_LOCAL">
		<non-jta-data-source>java:/comp/env/jdbc/sistema</non-jta-data-source>
		<class>sistema.dominio.Banco</class>
		<exclude-unlisted-classes />
		<properties>
			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
			<property name="hibernate.show_sql" value="true" />
			<property name="hibernate.format_sql" value="false" />
		</properties>
	</persistence-unit>	
</persistence>

<!-- Data Source -->
	<bean id="poolBean" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="jdbc/sistema" />
		<property name="resourceRef" value="true" />
	</bean>

	<!-- JPA -->
	<!-- Gerenciador de EntityManagerFactory -->
	<bean id="emf" class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
		<property name="persistenceUnitName" value="sistema" />
	</bean>
	<bean id="emf2" class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
		<property name="persistenceUnitName" value="puteste" />
	</bean>
	<!-- Gerenciador de transação -->
	<bean id="transacaoJPA" class="org.springframework.orm.jpa.JpaTransactionManager">
		<property name="entityManagerFactory" ref="emf" />
		<property name="dataSource" ref="poolBean" />
		<property name="jpaDialect" ref="jpaDialect" />
	</bean>
	<bean id="transacaoJPA2" class="org.springframework.orm.jpa.JpaTransactionManager">
		<property name="entityManagerFactory" ref="emf2" />
		<property name="dataSource" ref="poolBean" />
		<property name="jpaDialect" ref="jpaDialect" />
	</bean>

	<!-- Localiza e faz auto DI para os bean com @Transaction -->
	<tx:annotation-driven transaction-manager="transacaoJPA" />
	<tx:annotation-driven transaction-manager="transacaoJPA2" />
	
	<!-- Localiza e faz auto DI para os bean com @PersistenceContext -->
	<bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor"/>

public class CirrusEaoImp<E extends Serializable, C extends Serializable>
		implements CirrusEao<E, C>, Serializable {

	@PersistenceContext(unitName="puteste")
	protected EntityManager em;
	/** Armazena o tipo da classe ORM mapeada. **/
	private Class<E> tipo;

	/** Construtor padrão. **/
	@SuppressWarnings("unchecked")
	public CirrusEaoImp() {
		tipo = (Class<E>) ((ParameterizedType) getClass()
				.getGenericSuperclass()).getActualTypeArguments()[0];
	}

<?xml version="1.0" encoding="ISO-8859-1" ?>
<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-3.0.xsd
          http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
          http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
          http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">

	<!-- Data Source -->
	<bean id="poolBean" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="jdbc/sistema" />
		<property name="resourceRef" value="true" />
	</bean>

	<!-- Compartilha a transação JPA para JDBC do Hibernate -->
	<bean id="jpaDialect" class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />

	<!-- JPA -->
	<!-- Gerenciador de EntityManagerFactory -->
	<bean id="emf" class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
		<property name="persistenceUnitName" value="sistema" />
	</bean>
	<!-- Gerenciador de transação -->
	<bean id="transacaoJPA" class="org.springframework.orm.jpa.JpaTransactionManager">
		<property name="entityManagerFactory" ref="emf" />
		<property name="dataSource" ref="poolBean" />
		<property name="jpaDialect" ref="jpaDialect" />
	</bean>

	<!-- Localiza e faz auto DI para os bean com @Transaction -->
	<tx:annotation-driven transaction-manager="transacaoJPA" />
	<!-- Localiza e faz auto DI para os bean com @PersistenceContext -->
	<bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />

	<!-- JDBC suporte Spring -->
	<bean id="simpleJdbcDaoSupport" class="org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport">
		<property name="dataSource" ref="poolBean" />
	</bean>
	<!-- Bean JdbcDao geral do Cirrus -->
	<bean id="jdbcDao" class="cirrusfaces2.infra.persistencia.dao.JdbcDaoImp">
		<property name="simpleJdbcDaoSupport" ref="simpleJdbcDaoSupport" />
	</bean>
	
</beans>

<?xml version="1.0" encoding="Windows-1252"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
	
	
  
	<persistence-unit name="SCG" transaction-type="RESOURCE_LOCAL">
	<non-jta-data-source>java:comp/env/jdbc/OpsistDS</non-jta-data-source> 
		<class>br.com.SCG.bean.Recarga</class>
		<class>br.com.SCG.bean.Comentario</class>
		<class>br.com.SCG.bean.ARSAberta</class>
		<exclude-unlisted-classes />					
		<properties>  	
	       <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>  
	       <property name="hibernate.transaction.factory_class" value="org.hibernate.transaction.JDBCTransactionFactory" />  
	       <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider"/>  
	       <property name="hibernate.show_sql" value="false"/>  
           <property name="hibernate.format_sql" value="true"/>             
		</properties>		
	</persistence-unit>
	
	<persistence-unit name="REMEDY" transaction-type="RESOURCE_LOCAL">
	<non-jta-data-source>java:comp/env/jdbc/RemedyDS</non-jta-data-source> 
		<class>br.com.SCG.bean.DetalheARSAberta</class>	
		<exclude-unlisted-classes />					
		<properties>  	
	       <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>  
	       <property name="hibernate.transaction.factory_class" value="org.hibernate.transaction.JDBCTransactionFactory" />  
	       <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider"/>  
	       <property name="hibernate.show_sql" value="false"/>  
           <property name="hibernate.format_sql" value="true"/>             
		</properties>		
	</persistence-unit>

public class ARSAbertaDAO implements Serializable{
	

	private static final long serialVersionUID = 2535568973259190396L;
	
	@PersistenceContext(unitName="SCG")  
        protected EntityManager em;
	
    public List<ARSAberta> listar() {        
    	List<ARSAberta> arsabertas = null;
        try {
        	EntityTransaction etx = em.getTransaction(); 
            etx.begin();
            Query query = em.createQuery("Select a from ARSAberta a where a.classificacaoChamado = 1");
            List resultList = query.getResultList();
			arsabertas = resultList;
            
                       
        } catch (Exception e) {
            e.printStackTrace();
        }
        
        em.close();   //fecha o contexto de persistencia 
        emf.close();
         
        return arsabertas;
    }

<Context docBase="SCG" path="/SCG" reloadable="true" source="org.eclipse.jst.jee.server:SCG">
      	<Resource name="jdbc/OpsistDS" auth="Container"   
					  type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"  
					  url="jdbc:oracle:thin:@10.58.177.124:1521:opsistdb"  
					  username="user" password="senha" maxActive="40" maxIdle="10"  
					  maxWait="-1"/>
					  
		<Resource name="jdbc/RemedyDS" auth="Container" type="javax.sql.DataSource"
			 maxActive="100" maxIdle="30" maxWait="10000"
			 username="user" password="senha" driverClassName="oracle.jdbc.driver.OracleDriver"
			 url="jdbc:oracle:thin:@oracle01.telemar:1566:ARSREL01"/>

<?xml version="1.0" 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:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="		  
    	http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd  
    	http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd  
    	http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
    	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd">
	<bean
		class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />
	<bean
		class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />
		
		
	<!--DataSource MySQL -->
	<bean id="dataSourceMySQL" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close" scope="singleton">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="password" value="root" />
		<property name="url" value="jdbc:mysql://localhost:3306/pagina_demo" />
		<property name="username" value="root" />

		<property name="testOnBorrow" value="true" />
		<property name="validationQuery" value="SELECT 1" />
	</bean>


	<bean id="persistenceUnitManager"
		class="org.springframework.orm.jpa.persistenceunit.DefaultPersistenceUnitManager">
		<property name="persistenceXmlLocations">
			<list>
				<value>classpath*:META-INF/persistence.xml</value>
			</list>
		</property>
		<property name="dataSources">
			<map>
				<entry key="localDataSource" value-ref="dataSourceMySQL" />
			</map>
		</property>
		<property name="defaultDataSource" ref="dataSourceMySQL" />
	</bean>

	<bean id="entityManagerFactory"
		class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
		<property name="persistenceUnitManager" ref="persistenceUnitManager" />
		<property name="persistenceUnitName" value="PUTeste" />
	</bean>

	<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
		<property name="entityManagerFactory" ref="entityManagerFactory" />
	</bean>


	<tx:annotation-driven transaction-manager="transactionManager" />
	<context:annotation-config />

<!-- 	<context:component-scan base-package="br.com.service" /> -->
	<context:component-scan base-package="br.com.paulo.sistema.dao" />

</beans>

<persistence xmlns="http://java.sun.com/xml/ns/persistence"  
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"  
    version="1.0">  
    <persistence-unit name="PUTeste">
	<provider>org.hibernate.ejb.HibernatePersistence</provider> 
    <non-jta-data-source>localDataSource</non-jta-data-source> 
       
<!--        <non-jta-data-source>java:comp/env/jdbc/fnp</non-jta-data-source>-->
        <properties>  
            <property name="default" value="true" />  
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>  
            <property name="hibernate.hibernate.transaction.factory_class" value="org.hibernate.transaction.JDBCTransactionFactory" />
            <property name="hibernate.hbm2ddl.auto" value="update" />
<!--             <property name="hibernate.connection.driver_class" value="org.gjt.mm.mysql.Driver"/> -->
<!--             <property name="hibernate.connection.url" value="jdbc:mysql://localhost/pagina_demo"/> -->
<!--             <property name="hibernate.connection.username" value="root"/> -->
<!--             <property name="hibernate.connection.password" value="root"/> -->
        </properties>  
    </persistence-unit>  
</persistence>