How to switch Database on runtime in SpringBoot and SpringDataJPA / Hibernate?
I want to create an application with SpringBoot, SpringRest, SpringDataJPA / Hibernate with multiple databases on runtime.
Actually i am creating multitenant application with following flow:
1- one Applcation may be php: from website user will create account, the system will run the process and will create database and releated configuration.
2- Major application ( SpringBoot, SpringRest, SpringDataJPA / hibernate ) will now loaded start pointing to that newly created database which contains users and other stuff data.
3- I want to add oauth2 rest security as well. so the configuration should be acordingly.
now the question is that how to achieve this in springBoot and springDataJPA application and swtich the database configuration on runtime?
your answers are highly appreciated.
thanks.
hibernate spring-boot spring-data-jpa spring-rest
asked Nov 14 '18 at 9:48
Irfan NasimIrfan Nasim
112
|
show 2 more comments
I want to create an application with SpringBoot, SpringRest, SpringDataJPA / Hibernate with multiple databases on runtime.
Actually i am creating multitenant application with following flow:
1- one Applcation may be php: from website user will create account, the system will run the process and will create database and releated configuration.
2- Major application ( SpringBoot, SpringRest, SpringDataJPA / hibernate ) will now loaded start pointing to that newly created database which contains users and other stuff data.
3- I want to add oauth2 rest security as well. so the configuration should be acordingly.
now the question is that how to achieve this in springBoot and springDataJPA application and swtich the database configuration on runtime?
your answers are highly appreciated.
thanks.
hibernate spring-boot spring-data-jpa spring-rest
asked Nov 14 '18 at 9:48
Irfan NasimIrfan Nasim
112
the following website provide very good tutorials callicoder.com/categories/spring-boot
– Samim
Nov 14 '18 at 12:52
this is not answer of my question. i dont have issue in springBoot, i want to develop a strategy of switching database on runtime @Samim
– Irfan Nasim
Nov 15 '18 at 4:31
First app can write the db info (port, connection, user, password) to application.properties of SpringBoot (or any other conf file) then spring boot after spin up can read db info from that config file. Just a thought haven't done it myself.
– Nauman Rafique
Nov 16 '18 at 6:18
@irfanNasim Check this link. It also mentions the same approach with context reloading
– Nauman Rafique
Nov 16 '18 at 6:26
stackoverflow.com/questions/39357367/…
– Nauman Rafique
Nov 16 '18 at 6:44
|
show 2 more comments
I want to create an application with SpringBoot, SpringRest, SpringDataJPA / Hibernate with multiple databases on runtime.
Actually i am creating multitenant application with following flow:
1- one Applcation may be php: from website user will create account, the system will run the process and will create database and releated configuration.
2- Major application ( SpringBoot, SpringRest, SpringDataJPA / hibernate ) will now loaded start pointing to that newly created database which contains users and other stuff data.
3- I want to add oauth2 rest security as well. so the configuration should be acordingly.
now the question is that how to achieve this in springBoot and springDataJPA application and swtich the database configuration on runtime?
your answers are highly appreciated.
thanks.
hibernate spring-boot spring-data-jpa spring-rest
asked Nov 14 '18 at 9:48
Irfan NasimIrfan Nasim
112
I want to create an application with SpringBoot, SpringRest, SpringDataJPA / Hibernate with multiple databases on runtime.
Actually i am creating multitenant application with following flow:
1- one Applcation may be php: from website user will create account, the system will run the process and will create database and releated configuration.
2- Major application ( SpringBoot, SpringRest, SpringDataJPA / hibernate ) will now loaded start pointing to that newly created database which contains users and other stuff data.
3- I want to add oauth2 rest security as well. so the configuration should be acordingly.
now the question is that how to achieve this in springBoot and springDataJPA application and swtich the database configuration on runtime?
your answers are highly appreciated.
thanks.
hibernate spring-boot spring-data-jpa spring-rest
hibernate spring-boot spring-data-jpa spring-rest
asked Nov 14 '18 at 9:48
Irfan NasimIrfan Nasim
112
asked Nov 14 '18 at 9:48
Irfan NasimIrfan Nasim
112
edited Nov 14 '18 at 12:06
Irfan Nasim
asked Nov 14 '18 at 9:48
Irfan NasimIrfan Nasim
112
asked Nov 14 '18 at 9:48
Irfan NasimIrfan Nasim
112
asked Nov 14 '18 at 9:48
Irfan NasimIrfan Nasim
112
112
the following website provide very good tutorials callicoder.com/categories/spring-boot
– Samim
Nov 14 '18 at 12:52
this is not answer of my question. i dont have issue in springBoot, i want to develop a strategy of switching database on runtime @Samim
– Irfan Nasim
Nov 15 '18 at 4:31
First app can write the db info (port, connection, user, password) to application.properties of SpringBoot (or any other conf file) then spring boot after spin up can read db info from that config file. Just a thought haven't done it myself.
– Nauman Rafique
Nov 16 '18 at 6:18
@irfanNasim Check this link. It also mentions the same approach with context reloading
– Nauman Rafique
Nov 16 '18 at 6:26
stackoverflow.com/questions/39357367/…
– Nauman Rafique
Nov 16 '18 at 6:44
|
show 2 more comments
the following website provide very good tutorials callicoder.com/categories/spring-boot
– Samim
Nov 14 '18 at 12:52
this is not answer of my question. i dont have issue in springBoot, i want to develop a strategy of switching database on runtime @Samim
– Irfan Nasim
Nov 15 '18 at 4:31
First app can write the db info (port, connection, user, password) to application.properties of SpringBoot (or any other conf file) then spring boot after spin up can read db info from that config file. Just a thought haven't done it myself.
– Nauman Rafique
Nov 16 '18 at 6:18
@irfanNasim Check this link. It also mentions the same approach with context reloading
– Nauman Rafique
Nov 16 '18 at 6:26
stackoverflow.com/questions/39357367/…
– Nauman Rafique
Nov 16 '18 at 6:44
the following website provide very good tutorials callicoder.com/categories/spring-boot
– Samim
Nov 14 '18 at 12:52
the following website provide very good tutorials callicoder.com/categories/spring-boot
– Samim
Nov 14 '18 at 12:52
this is not answer of my question. i dont have issue in springBoot, i want to develop a strategy of switching database on runtime @Samim
– Irfan Nasim
Nov 15 '18 at 4:31
this is not answer of my question. i dont have issue in springBoot, i want to develop a strategy of switching database on runtime @Samim
– Irfan Nasim
Nov 15 '18 at 4:31
First app can write the db info (port, connection, user, password) to application.properties of SpringBoot (or any other conf file) then spring boot after spin up can read db info from that config file. Just a thought haven't done it myself.
– Nauman Rafique
Nov 16 '18 at 6:18
First app can write the db info (port, connection, user, password) to application.properties of SpringBoot (or any other conf file) then spring boot after spin up can read db info from that config file. Just a thought haven't done it myself.
– Nauman Rafique
Nov 16 '18 at 6:18
@irfanNasim Check this link. It also mentions the same approach with context reloading
– Nauman Rafique
Nov 16 '18 at 6:26
@irfanNasim Check this link. It also mentions the same approach with context reloading
– Nauman Rafique
Nov 16 '18 at 6:26
stackoverflow.com/questions/39357367/…
– Nauman Rafique
Nov 16 '18 at 6:44
stackoverflow.com/questions/39357367/…
– Nauman Rafique
Nov 16 '18 at 6:44
|
show 2 more comments
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53297213%2fhow-to-switch-database-on-runtime-in-springboot-and-springdatajpa-hibernate%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53297213%2fhow-to-switch-database-on-runtime-in-springboot-and-springdatajpa-hibernate%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
the following website provide very good tutorials callicoder.com/categories/spring-boot
– Samim
Nov 14 '18 at 12:52
this is not answer of my question. i dont have issue in springBoot, i want to develop a strategy of switching database on runtime @Samim
– Irfan Nasim
Nov 15 '18 at 4:31
First app can write the db info (port, connection, user, password) to application.properties of SpringBoot (or any other conf file) then spring boot after spin up can read db info from that config file. Just a thought haven't done it myself.
– Nauman Rafique
Nov 16 '18 at 6:18
@irfanNasim Check this link. It also mentions the same approach with context reloading
– Nauman Rafique
Nov 16 '18 at 6:26
stackoverflow.com/questions/39357367/…
– Nauman Rafique
Nov 16 '18 at 6:44