Spring Data JPA [PRO] - How to connect Multiple Databases using Spring Boot | Multiple Datasources

In this Spring Data JPA tutorial, we will learn, How to connect Multiple Databases using Spring Boot. We will be using a MySQL database and a Postgres database and create datasources for the same. As we will be creating multiple datasources for our application, We also need to set up multiple EntityManager for our application as well. Not only that, this tutorial covers setting up multiple transaction managers for our entity managers and helps you link them using @EnableJpaRepositories annotation. Mark that this is an important spring data jpa annotation as it helps creating the Repository implementation.

We will pull all the above together by creating a spring boot application which will continuously push data to multiple databases. You can use the same in your real-time project irrespective of the databases you are using. (Incase you have a h2 /d2/oracle/sql server db)

Timestamp
——————
00:00:00 - Sprig Data Jpa - Video Insights
00:03:45 - Spring Data jpa project setup
00:05:45 - The goal - Connect with Multiple databases
00:08:05 - Creating Product Entity
00:11:37 - Spring Data Jpa CrudRepository
00:18:18 - DatasourceProperties : Component walkthrough
00:28:09 - Customising datasource properties
00:32:24 - Postgres datasource properties configuration
00:38:24 - spring boot @ConfgurationProperties - use case 1
00:44:46 - @Configuration with @Bean - use case 2
00:49:40 - DriverManagerDatasource vs DatasourceProperties’s initalizeDatasourceBuilder
00:57:02 - Multiple datasources in action with @Primary
01:13:19 - Setting up multiple entity managers
01:26:49 - @EnableJpaRepoistories : tech walkthrough
01:43:12 - Setting up multiple jpa transaction managers (PlatformTransctionManger)
01:54:55 - Success: Multiple datasource in action
01:56:58 - Best practice - @EnableTransactionManager
01:57:37 - [Test] check in data to multiple database with a spring boot app
02:00:37 - Outro

#springboot #springdatajpa #jpa #hibernate

For more free/paid courses visit

LINKS AND FREE LEARNING RESOURCES
========
Watch my new mock interview series for java developers

Watch my new Hello spring boot series

Watch Spring boot Hot topics

Java Interview / Question and Answer series

Explain spring Bean Lifecycle

spring core

spring mvc

spring mvc intermediate

Spring JDBC

spring live project

SPRING SECURITY COURSE[NEW]

For more courses visit

Any time you are getting stuck with issues, Feel free to ask for support.

you can ping me on my Facebook page

Make sure to join my private Facebook page (Ask me here)
“SeleniumExpress - Support"

you can ask for support in my website forum

Subscribe to my youtube channel

Follow me on Insta

[iampradeephr]

One of the best in depth explanations ever 🔥

[sourishravichandren]

Explanation was Amazing!!! Greatest video on Multiple Datasource

[alcoverp]

Great videos man! Unlike other tutorials, you go deep into Spring concepts and make things really clear. Congrats for the initiative!

[MarceloGarciaPerfil]

2nd hasf done. Great video with deep concepts of ORM. Thank you

[SohamDutta]

you saved millions of students.. thanks from all of us

[Bindas_Raja]

Bhai bahut badhia lagila au easy explanation. . Thanks from ODISHA ❤

[tus]

Amazing video and teaching style amazing I like how you shocase each steps and why behind of each step.

[jesuslovesyou]

Extraordinary teaching thank u soo much for clear explanation . Keep giving more videos like this

[ujjwalpandey]

You are amazing... Not other word category suits you... You are incredible.

[shirokuma]

1st Half Done, your explanations are very engaging and clear 😎

[AnkitLadha-foem]

Appreciate your hard work and explaining meaning of the error messages at every step.

[srinivasulumannem]

Hi @Abhilash iam looking for kafka video series from your side .have been following you for the last 3 years on words .I have covered all your videos .

[harleyseixas]

Excelente conteúdo, muito bem explicado. Step by step...💯💯💯💯 Obrigado por compartilhar seu conhecimento.

[priyanshu]

absolutely great video . i am learning a lot from your videos, thanks for sharing

[ashutoshsatapathy]

2nd Half Done, Thanks for this informative video.

[virupakshak]

Superb... Thanks, Abhilash for nicely explained it....

[msvchalapathy]

Fabulous topic. Thank you for this session

[avalagum]

A very good video although it's a bit too long. Thank you very much for sharing your knowledge. You can use a smaller font size and we can still see it.

[RameshDornala-bf]

Thanks Abhi🤝❤. as always you explained well

[AbhishekAnandDas]

I have used the same methods to connect to two databases in one of the production application I'm currently working on... 😊