Spring Boot Application add datasource at runtime?

Question

I working on a project which uses Spring boot , Spring Data JPA and postgres .There is a problem that can't solve .

When my application start up ,The database not ready yet . It need to add to application at runtime . But I also want to initialize a database using JPA. just like spring.jpa.hibernate.ddl-auto：create-drop，Unfortunately Initialize a database using JPA will happen at application startup.

My question is that how to delay spring data jpa DDL generation. now we can't add a datasource at application runtime.

I am searching for a long time on net. But no use. The AbstractRoutingDataSource may be not suit for us, because we don't have a datasource at begin . Please help or try to give some ideas how to achieve this

Thanks in advance

@AmerQarabsa beacause we need a mini project . The database require to add at runtime. — tanghuailong, Aug 16 '17 at 05:33
@AmerQarabsa The database not ready when The mini project start up — tanghuailong, Aug 16 '17 at 05:34
since you are planning to use create-drop, this means jpa will prepare it for you — Amer Qarabsa, Aug 16 '17 at 06:12
@AmerQarabsa Yes , If I want to use create-drop , how to delay jpa initialize behavior — tanghuailong, Aug 16 '17 at 06:55
during the startup the springboot autoconfiguration reads the property file and search for the configuration , if you want to delay (which i dont understand why would you want it ) you need to connect to database after contextrefreshevent — Amer Qarabsa, Aug 16 '17 at 06:57
@AmerQarabsa Thanks you reply, If don't care about JPA ,Is there some way to add datasource in application runtime,just need one datasource — tanghuailong, Aug 16 '17 at 07:02
yes you can autowire datasource to one of your configuration classes and you can use it after the application context is refreshed — Amer Qarabsa, Aug 16 '17 at 07:13
You can instantiate the entity manager at any point of time. In run time how will you change the modelling to update DB (need to restart if any change in source code). — PRATHAP S, Aug 16 '17 at 10:48
@PRATHAPS Could you be a bit more specific ？ thank you very much — tanghuailong, Aug 16 '17 at 12:55
@AmerQarabsa I am a newcomer for spring boot, could you be a bit more specific. thank you very much — tanghuailong, Aug 16 '17 at 13:06
@tanghuailong check this link https://docs.spring.io/spring-boot/docs/current/reference/html/howto-data-access.html — Amer Qarabsa, Aug 16 '17 at 13:26
Show us the code what have you tried so far with error logs. People here can help you out. — PRATHAP S, Aug 16 '17 at 13:40
@PRATHAPS There is no error. I just don't how to implement it that the database add after application startup . yes I can do it by retry datasource connection. I think it not a proper way . because database ready to need some time， maybe a long time — tanghuailong, Aug 16 '17 at 14:14
@AmerQarabsa I know this, But the DataSource bean can't ready ,because there is no database when the application startup . why should i don't create database , perhaps need to ask architects — tanghuailong, Aug 16 '17 at 14:21

score 1 · Answer 1 · answered Oct 04 '17 at 07:21

AbstractRoutingDataSource is not useful as it requires pre-configured datasources. just check this stackoverflow question, it shows how you can add/remove datasources at runtime. While it doesn't support hibernate's delayed ddl creation but you can create database tables in runtime datasources using schema.sql and inserts some constants using data.sql.

Spring Boot Application add datasource at runtime?

1 Answers1