• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Defining 2 separate databases in persistence.xml

 
Ismael Upright
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:




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
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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."

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic