Multiple Datasources in Spring Boot using same repository and entities

Question

I am trying to figure out how to insert the exact same data into two different databases with the same schema. I found this Multiple datasources with same repositories and entities but it didnt really answer the question.

Say I have a user who is registering and I want to save this user to both databases. How do I do I configure this in spring boot? I have seen different repos/databases but what I want is to use the same repo/entity. I know replication is a thing in databases already but I want to do this on the application level.

ValerioMC · Accepted Answer · 2019-01-23 21:05:32Z

8

The solution you are searching is well discussed in this artiche with the save action here

Just a couple of notes... You can configure two database and you can also set the same entities, but you cannot point at the same repository because each repository is related to a specific dataSource and transactionManager. Moreover, if you want to have the same entity ids across two databases you have to manage them manually.

answered Jan 23, 2019 at 21:05

ValerioMC

3,22618 silver badges28 bronze badges

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

1 Comment

binaryhex Over a year ago

Thanks, the article you posted helped.

Collectives™ on Stack Overflow

Multiple Datasources in Spring Boot using same repository and entities

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related