<datasources>
   
   <local-tx-datasource>
      <jndi-name>aggDatasource</jndi-name>
      <use-java-context>false</use-java-context>
      <connection-url>jdbc:oracle:thin:@ipaddress:port:tstdwrpt</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name></user-name>
      <password></password>
   </local-tx-datasource>
   
   <local-tx-datasource>
      <jndi-name>dmbDatasource</jndi-name>
      <use-java-context>false</use-java-context>
      <connection-url>jdbc:oracle:thin:@ipaddress:port:test10</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name></user-name>
      <password></password>
   </local-tx-datasource>
     
</datasources>

<persistence:managed-persistence-context
      auto-create="true" name="entityManager" persistence-unit-jndi-name="java:/dmbEntityManagerFactory" />
<persistence:managed-persistence-context
      auto-create="true" name="aggEntityManager" persistence-unit-jndi-name="java:/aggEntityManagerFactory" />

<persistence-unit name="agg">
      <provider>org.hibernate.ejb.HibernatePersistence</provider>
      <jta-data-source>aggDatasource</jta-data-source>
      <properties>
         <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>
         <property name="hibernate.hbm2ddl.auto" value="none"/>
         <property name="hibernate.show_sql" value="true"/>
         <property name="hibernate.format_sql" value="true"/>
         <property name="hibernate.default_schema" value=""/>
         <property name="hibernate.session_factory_name" value="aggSessionFactory" />
         <property name="jboss.entity.manager.factory.jndi.name" value="java:/aggEntityManagerFactory"/>
      </properties>
   </persistence-unit>
             
   <persistence-unit name="dmb">
      <provider>org.hibernate.ejb.HibernatePersistence</provider>
      <jta-data-source>dmbDatasource</jta-data-source>
      <properties>
         <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>
         <property name="hibernate.hbm2ddl.auto" value="none"/>
         <property name="hibernate.show_sql" value="true"/>
         <property name="hibernate.format_sql" value="true"/>
         <property name="hibernate.default_schema" value=""/>
         <property name="hibernate.session_factory_name" value="dmbSessionFactory" />
         <property name="jboss.entity.manager.factory.jndi.name" value="java:/dmbEntityManagerFactory"/>
      </properties>
   </persistence-unit>