Mapping an entity on two different databases with different columns

Question

So i have a situation like this:

A table T is present in two databases. In one of them T has a column C and in the other one it doesn't. My application reads at deploy time a boolean value which among other things tells it which database it must connect to.

Doing some research it looks like the potential solutions might be:

Create two different entities and a parent with MappedSuperclass with all the common properties. One of the sublasses will have that additional column, the other would be "blank". See comments on the question here
Create two entities and define two PersistenceUnit for each DB. Then use the schema property of @Table to specify the correct schema.

Are they correct? Any other advice? Do you know of any drawbacks?

Christian Beikov · Accepted Answer · 2021-09-06 18:57:05Z

2

Both solutions are fine. Do whatever works best for you.

answered Sep 6, 2021 at 18:57

Christian Beikov

16.6k2 gold badges36 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mapping an entity on two different databases with different columns

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related