Programmatically creating a new DB in Spring

Question

I'm looking for a way to programmatically create a database in Spring Boot then put it as an active data source.

Is such a thing even possible? I see all this dynamic changing of the DBs, but that's not what I need and I can't find any information on this in the documentation, only about migrations, DB initialization etc.

Using spring boot 1.3.1 with PostgreSQL 9.4 DB.

By programmatically you mean create it at application startup? — Abdullah Mohammad Motiullah
– Abdullah Mohammad Motiullah, Commented Nov 23, 2016 at 9:38

Pau · Accepted Answer · 2016-11-23 11:25:32Z

1

You could execute the sql statement to create a database:

 CREATE DATABASE name;

or in the case you need the database owns to a user:

 CREATE DATABASE name OWNER username TABLESPACE tablespacename;

Then use AbstractRoutingDataSource to add the new datasource and change it to it.

https://spring.io/blog/2007/01/23/dynamic-datasource-routing/

edited Nov 23, 2016 at 11:25

answered Nov 23, 2016 at 9:27

Pau

16.2k16 gold badges74 silver badges97 bronze badges

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

2 Comments

Vedran Kopanja Over a year ago

I'll have to try this out, didn't occur to me that I could have a migration with CREATE DATABASE :).

Vedran Kopanja Over a year ago

I managed to do it sort of like this. We're using Flyway in our project, so I could run statements in Flyway Callbacks, then switch my DataSource from there as well (no need for AbstractRoutingDataSource). Thanks for the idea!

Goro · Accepted Answer · 2016-11-23 09:42:03Z

1

Spring boot allows you to keep sql files in class path.These files are used to created Database initialization. you can use it from here Spring Boot Doc

answered Nov 23, 2016 at 9:42

Goro

5525 silver badges18 bronze badges

Collectives™ on Stack Overflow

Programmatically creating a new DB in Spring

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related