Dynamically create schema in Spring boot application

Question

I have a Spring boot application that uses JPA with Hibernate. It already connect to a primary data source for all transactions.

Now the task in hand is that I need to dynamically create Database Schema in a different database. For instance,

For project 1, create schema 1 in Database X For project 2, create schema 2 in Database X

Later, these databases will be used by others externally. I am looking for the best way to get this done.

You can use `gradle` with `flyway` then create a task in order to create a schema for database. — Jonathan JOhx, Jul 12 '19 at 19:34
You can also try [this answer](https://stackoverflow.com/a/47091739/1092818) — crizzis, Jul 12 '19 at 21:03
you question is a bit abstract, you want to connect to 2 datasources? When you say project 1 and 2 are those applications or tables in primary source? — Comfort Chauke, Jul 13 '19 at 09:35

score 0 · Answer 1 · answered Jul 12 '19 at 20:03

0

In case of defining multiple datasources in spring boot project, you have to declare associated beans in your configuration. With spring.jpa.hibernate.ddl-auto=create it will automatically create the schema in right database as answered here

answered Jul 12 '19 at 20:03

zpavel

951
5
11

Dynamically create schema in Spring boot application

1 Answers1