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:19:52 - Setting up mysql datasource using application.properties
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
www.seleniumexpress.com
LINKS AND FREE LEARNING RESOURCES
========
Watch my new mock interview series for java developers
• Java interview questio...
Watch my new Hello spring boot series
• Spring Vs Spring Boot ...
Watch Spring boot Hot topics
• @Reposicotry Vs @Servi...
Java Interview / Question and Answer series
• Java collections inter...
Explain spring Bean Lifecycle
• REAL-TIME: Spring Bean...
spring core
• Spring framework tutor...
spring mvc
• Spring MVC course intr...
spring mvc intermediate
• [INTERMEDIATE] Spring ...
Spring JDBC
• Spring JDBC Course Pre...
spring live project
• #1 Build and Deploy A ...
SPRING SECURITY COURSE[NEW]
• Spring Security Course...
For more courses visit
www.seleniumexpress.com
Any time you are getting stuck with issues, Feel free to ask for support.
You can send mail to [e-mail]
you can ping me on my Facebook page
/ seleniumexpress
Make sure to join my private Facebook page (Ask me here)
“SeleniumExpress - Support"
/ 187000222361579
you can ask for support in my website forum
www.seleniumexpress.com
Subscribe to my youtube channel
/ @seleniumexpress
Follow me on Insta
/ selenium_express

[@iampradeephr]

One of the best in depth explanations ever 🔥

[@SeleniumExpress]

Thank you 😊

[@Bindas_Raja]

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

[@AnkitLadha-fo8em]

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

[@ujjwalpandey4721]

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

[@biswajeetsahoochintu2329]

Best depth concept you explained abhilash Jay jaganath abhilash

[@virupakshak4746]

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

[@harleyseixas8708]

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

[@jesuslovesyou8664]

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

[@msvchalapathy]

Fabulous topic. Thank you for this session

[@SeleniumExpress]

My pleasure 😊

[@maharishi1]

Thank you Abhilash...

[@srinivasulumannem4137]

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 .

[@jaafarhamza3402]

2nd half done. Thank you

[@priyanshu4016]

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

[@user-kn4dc2ek5z]

Thanks Abhi🤝❤. as always you explained well

[@shirokuma145]

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

[@shirokuma145]

2nd Half Done, many thanks for the tutorial!

[@srinivasn7991]

Clear understandng each and everthing

[@SeleniumExpress]

Thank you so much, Srinivasan ❤️

[@gowtham4383]

Thanks bro .

[@arpansrivastava7537]

Very nice 👍👍

[@pranjitmedhi6764]

great work

[@srigakolapuatchuthasai6638]

Thanks Abhi ❤

[@SeleniumExpress]

❤️

[@mohammedirfan5744]

Thanks sir

[@saruth]

you are best!

[@SeleniumExpress]

❤

[@rahulbhatanagar6175]

1st half done 👍

[@priyanshu4016]

first half done 👍

[@pothinenivenkat]

ధన్యవాదాలు!

[@AbhishekAnandDas]

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

[@sarathchandra941]

1st half done

[@edgarangelveradelrio3645]

Hi, excellent video! I Have a question, in spring boot 3 what is the alternative to ChainedTransactionManager?

[@pavankumar-mt3gm]

on multi datasource implementation in springboot I get Field ConfigurationRepository in ConfigurationService required a bean named 'entityManagerFactory' that could not be found.

[@sahukarinaveenkumar3188]

Hi Ahbishek sir, can u please make one video on oauth internal? Like how resource server communicates with auth server internal classes and concepts?

[@kalaimaranmadhavan4182]

Please make video for multitenant application with seperate schema. I am waiting for your video. I have searched in youtubes no videos related on this and i cannot understand those videos. Please make

[@ritunjaykumar5428]

Hi, How can we manage the multiple transaction at the same time. suppose i am inserting data in Mysql DB but unable to insert in PG Db. then how to rollback for both....

[@user-ze5rc9eb8m]

Hi i want to connect two postgres database when both the postgres databases are up and running only primary database has to get and post the data secondary should be stand by when primary database goes down secondary database has to take over when primary database come back ideally primary should take over how can we achieve this as of now i have configured 2 postgres but both the postgres are able to get and post the data

[@balakrishna9437]

Great video, 🎉 one question can’t we write a single configuration file for each of the product and order entities?

[@SeleniumExpress]

Thank you Bala, Yes we can! But better to create one per db as we can keep things relevant to a specific db.

[@ophemtech]

Hi Abhilash, thank you so much for this video. though i learnt this myself the hard way but your video really made me understand each blocks of code and why they even need to be written. but please there is still a problem i am trying to solve, how do i make it possible to make table name come from properties file like you use @ConfigurationProperties(). i want to make it possible that users of my product can specify the table name so my entity can just model the table directly other than me changing the code. for example any authentication database would have username , password, email columns, but they can be given diffreent names like auth_table, user_table, etc. so i want people to be able to specify that table name dynamically by themselves, more like for a saas product kind of thing. is it possible?

[@in_tyler_we_trust]

Sir Spring boot for beginners playlist is complete ? If not please please complete it so that we move on to the difficult topics Thank you!

[@debiprasaddash654]

Getting java job as a fresher is very difficult now a days 😢😢

[@teklehaimanotatikilt1435]

abhi how can we integrate fingerprint with spring security?by the way your videos are very helful

[@dipeshvishwakarma5671]

Hi this owsm video Thanks so much!! One request: could you please make one video on spark data connection, reading data from parquet file from AWS S3 using spark.sql("") It would be greatly appreciated and very helpful. Thanks

[@premraj.m]

47:30 keypoint

[@mdnishat9560]

Bro please complete the playlist of word guess game🤗🤗

[@SeleniumExpress]

Tomorrow you will get a new episode 🙂

[@PradeepKumar-sx6ms]

If I give challenges you like to crack???

[@SeleniumExpress]

I can try 😀

[@PradeepKumar-sx6ms]

@@SeleniumExpress share your personal email id

[@vlarunrajesh]

Bro. you are complicating simple things and make video lengthier.. keep it as simple.

[@punitvishwakarma718]

Bhai accent kyo badal raha Indian accent acha nahi lgta hai kya??? Banavati lagta hai

[@kunwarrajneeshsingh3132]

2nd half done

[@ayushsingh2431]

Getting error- Parameter 0 of method mySQLEntityManagerFactoryBean in org.ayushsingh.springdatamulitsoruce.config.MySQLEntityManagerConfiguration required a bean of type 'org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder' that could not be found.

[@SeleniumExpress]

Hi Ayush ! Make one of your datasource as Primary.

[@arpitrajput6424]

@@SeleniumExpress didn't work for me , now getting error related to mySqlTransactionalManager

[@arpitrajput6424]

Parameter 0 of method mySqlTransactionalManager in com.example.SPringbootJpa.config.MySQLJPAConfiguration required a bean of type 'org.springframework.orm.jpa.LocalEntityManagerFactoryBean' that could not be found. The injection point has the following annotations: - @org.springframework.beans.factory.annotation.Qualifier("mySqlEntityManagerFactoryBean")