Defining 2 separate databases in persistence.xml

[Ismael Upright]

Hello,

Suppose I need to define to have 2 separate databases backed on the Oracle: DBCustomers and DBProducts.

In DBCustomers I want to have tables: PersonalData and Orders.
In DBProducts I want to have tables: ProductData and Distribution.

My persistence.xml now:

<persistence>

        <persistence-unit name="DBCustomers" transaction-type="RESOURCE_LOCAL">
        
			<provider>org.hibernate.ejb.HibernatePersistence</provider>
			
			<class>entity.PersonalData</class>
			<class>entity.Orders</class>
			
        	<properties>
            	<property name="hibernate.show_sql" value="true" />
            	<property name="hibernate.format_sql" value="true" />
 
            	<property name="hibernate.connection.driver_class" 
                      value="oracle.jdbc.OracleDriver" />
            	<property name="hibernate.connection.url" 
                      value="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:xe" />
            	<property name="hibernate.connection.username" value="test_db1" />
            	<property name="hibernate.connection.password" value="test_db1" />
            	<property name="hibernate.dialect" 
                      value="org.hibernate.dialect.Oracle10gDialect" />
        </properties>
    </persistence-unit>
    
    <persistence-unit name="DBProducts" transaction-type="RESOURCE_LOCAL">
        
			<provider>org.hibernate.ejb.HibernatePersistence</provider>
			
			<class>entity.ProductData</class>
			<class>entity.Distribution</class>
			
        	<properties>
            	<property name="hibernate.show_sql" value="true" />
            	<property name="hibernate.format_sql" value="true" />
 
            	<property name="hibernate.connection.driver_class" 
                      value="oracle.jdbc.OracleDriver" />
            	<property name="hibernate.connection.url" 
                      value="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:xe" />
            	<property name="hibernate.connection.username" value="test_db2" />
            	<property name="hibernate.connection.password" value="test_db2" />
            	<property name="hibernate.dialect" 
                      value="org.hibernate.dialect.Oracle10gDialect" />
        </properties>
    </persistence-unit>
    
</persistence>

The problem is that when I run it, both databases have all four tables: PersonalData, Orders, ProductData and Distribution. I want to separate these tables as I described in the beginning of this post.

Is there a way to do that?

[Ismael Upright]

PS. As you can see, the IP address of host with Oracle is the same for both databases - only user differs. But as far as I know, different users in the Oracle have different schemas.

[Ismael Upright]

Never mind, solved it.

The solution is to put the tag:

<exclude-unlisted-classes>true</exclude-unlisted-classes>

to every persistence unit.


Seems that the default beharior is to take the set all classes from all persistence units, and insert them into all databases. A bit strange default to me...

[Cameron Wallace McKenzie]

Thanks for the update. Even though it looks like you're having a conversation with yourself, I actually found this interesting.

"When "<exclude-unlisted-classes>true</exclude-unlisted-classes>" is present in "persistence.xml", enclosing jar is not scanned for annotated classes."