How to switch database dynamically at runtime with Spring Data JPA ORM

Question

I want to create an application with Java, Spring and Spring JPA with multiple databases on run time.

Actually i am creating multi-tenant application with following flow:

1- one Application may be php: from website user will create account, the system will run the process and will create database and respective configuration.

2- Major application ( Java + Spring JPA, Spring REST) will now loaded, start pointing to that newly created database which contains users and other stuff data may be on the basis of tenant Id or some other pointing flag.

Further Plan to add 3rd point; 3- oAuth2 rest security as well. so the configuration should be accordingly.

now the question is that how to achieve this in Spring Data JPA application and switch the database configuration on run time?

Do you want to code example also??

Anish B.
– Anish B.

2019-06-11 05:45:31 +00:00
Commented Jun 11, 2019 at 5:45 — Anish B.
– Anish B., Commented Jun 11, 2019 at 5:45
it would be great if available. @AnishB.

Irfan Nasim
– Irfan Nasim

2019-06-11 05:54:05 +00:00
Commented Jun 11, 2019 at 5:54 — Irfan Nasim
– Irfan Nasim, Commented Jun 11, 2019 at 5:54

TechFree · Accepted Answer · 2019-06-11 07:13:49Z

0

You can configure multiple data sources upfront in Spring, and segregate associated repositories in different package structures ( not really a switch but accessing multiple data sources from same Spring boot app )

spring.datasource.url = ...
....


second.datasource.url=
second.datasource.username=
second.datasource.password=
second.datasource.driver-class-name=

Create a new Configuration to scan repos from a segregated package and also, load the configuration properties to build the second data source.

@EnableJpaRepositories(
  basePackages = { "<package containing repo from second database>" }
)
public class SecondDBConfig {
@Bean(name = "secondDataSource")
  @ConfigurationProperties(prefix = "second.datasource")
  public DataSource dataSource() {
    return DataSourceBuilder.create().build();
  }

..create the transaction manager and entity management factory

Finally, access the repositories connecting to different databases.

See complete example here

answered Jun 11, 2019 at 7:13

TechFree

3,0141 gold badge24 silver badges21 bronze badges

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

3 Comments

Irfan Nasim Over a year ago

this is not answer of my question, according to your answer we must have to put predefined configuration before initialization of application which is fear enough. but in my case i have dynamic database and its properties so i have to connect on runtime.

TechFree Over a year ago

You mean when you bring up ayour application, database to query is unknown ? and if yes, what point of time it becomes known and who provides that info ( connection details ) and how ? Maybe there the Datasource for your app can be instantiated dynamically?

Irfan Nasim Over a year ago

On loggedin screen system will ask user to enter tenantId which will be referred to database. so after loggedin every request will be connect to that database. On initialization of application it will connect with centralize database which contains information of tenants so the application will detect the details from here. I have already implemented this flow with JDBC Template but that was a new project now i have to do with existing so i want to achieve with minimum changes.

Collectives™ on Stack Overflow

How to switch database dynamically at runtime with Spring Data JPA ORM

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related