JPA Entity mapping to specific table

Question

My Project has 2 mysql databases. I have written JPA's for them. But while running it gives error.

Example: Database: One Table: Table1 Database: Two Table Table2

While creating entity manager for database "One" it says "Table2" missing & While creating entity manager for database "Two" it says "Table1" missing.

Post the error message dude so we can help you. – Ruelos Joel Jul 28 '16 at 07:30 — Ruelos Joel, Jul 28 '16 at 07:30

score 1 · Accepted Answer · answered Jul 28 '16 at 08:48

1

In persistence.xml

Added <class>org.x.y.JPA's</class> (JPA's/Classes that are referring to that persistence unit/database) & <exclude-unlisted-classes> true </exclude-unlisted-classes> before

<properties> 
...
..
..
</properties>

answered Jul 28 '16 at 08:48

Rajas Gujarathi

716
1
9
20

score 0 · Answer 2 · edited May 23 '17 at 12:25

0

WIth JPA you declare Persistence Unit which tells the code which data base to look at, since you have two separate databases, you will have to have multiple Persistence Units.

Take a look at the other answers on SO for hints on how to progress.

edited May 23 '17 at 12:25

Community

1
1

answered Jul 28 '16 at 07:44

dubes

5,324
3
34
47

Thanks dubes ... but found a work around with the existing thing...posted below – Rajas Gujarathi Jul 28 '16 at 08:37

JPA Entity mapping to specific table

2 Answers2