Spring Boot : How to connect with multiple databases using Spring Data JPA

#springboot #multipledatabases #springdatajpa
In this video you can learn how to develop spring boot application which can connect with multiple databases using Spring Data JPA.
In the application we have configured below 2 databases.
Database-1 : Embedded H2 Database
Database-2 : MySQL Database (AWS RDS)
👉 Source Code Git Hub Link : github.com/ashokitschool/spri...
✍️✍️ Register Here For Online Training : bit.ly/3Crpgbr
✍️ ✍️ Join Here For Technical Discussions : bit.ly/3iP2KyA
📞 WhatsApp Us : wa.me/[phone]
💡 Subscribe to our channel and hit the bell 🔔🔔🔔 icon to get video updates.
💡 Visit Our Website
For Online Training: ashokitech.com/
☎ WhatsApp Number: wa.me/[phone]
💡 About Ashok IT :
Ashok IT is the No.1 quality training institute in India for the candidates who want to build their future in Information Technology. We are into online training, class room training, corporate training and one to one training with more passion and dedication. Ashok IT aims in providing best quality realtime oriented trainings on C, C++, Java, Spring , Spring REST, Spring Cloud, Microservices, Python, DJango, .Net, Angular, React JS, Salesforce, , Testing, Android, Docker, Kubernates, Manual Testing, Selenium and Digital Marketing.
-----------------------------------------------------------------------------------
💡 Our Online Training Features
🎈 Training with Real-time Working Professionals
🎈 Industry Matching use cases
🎈 Live Coding
🎈 Real-time Environment
🎈 Class Notes
🎈 Doubts Clarifications in Each Session
-----------------------------------------------------------------------------------
💡 Contact details:
☎ WhatsApp Number: wa.me/[phone]
► Website : ashokitech.com/
► Join with us in Telegram : bit.ly/3iP2KyA
► Like us in Facebook : bit.ly/38riDKn
► Follow us in Instagram : bit.ly/3jzEKl8
► Follow us in Twitter : bit.ly/3N85pkw
#howtoconnectwithmultipledatabasesusingspringboot
#howtoconfiguremultipledatasourcesinspringboot
#springboottutorial #springbootfullcourse #springdatajpa
#java #programming #applicationdevelopment #databases #sql #nosql

[@ashokit]

💡 Welcome to Ashok IT..!! 💡 👉 Register Here For Online Training : bit.ly/3Crpgbr 🔥 Download Android App : bit.ly/3Z2vXcO 🔥 Download IOS App (MyInstitute) : apple.co/3IcEao3 👉 ORG Code For IOS : CNFXJ 🌐 Visit Our Website : ashokitech.com/

[@sasikumarramasamy4236]

Well organised content. Clear explaination steps. Gotcha in first view itself.

[@nagalakshmi991]

Sir simply superb great sir within 4 minutes' you completed. Thanqq soo much for sharing this video

[@ashokit]

You're Welcome 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@pratikjha2742]

i can't believe there are so less views and likes on this video, soon it will cross millions

[@ashokit]

Thank You 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@eternalgaming2144]

Hello Ashok, i have a problem statement - suppose i want to use 2 rdbms database one as primary and other as backup database so if i want to persist all entities to both database and retrieve the data only from primary database via repository how to configure, can you please help.

[@Mohamed-uf5jh]

Thanks Sir ! very clear and a good explain Wow !!!

[@ashokit]

Most welcome!

[@rajendranaik7317]

You are the genuine Java trainer Sir. Others focusing to earn but your content is worthful

[@ashokit]

Thank You 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@kalyanimvn]

Very good.and easily understand.thank yoy

[@ashokit]

You are welcome

[@ErLakhan]

Can you please highlight how Transactions would work?

[@AnubhabKundu]

You are writing in spring boot 2.x application?

[@sayakrana5072]

Problem is i am able to connect using this but using connection pool i am unable to do it using jndi-name

[@kannadasankaruppaiyan1155]

Awesome bro

[@ashokit]

Thankyou...

[@anandnandudkar1419]

Thanks alot!

[@ashokit]

You're Welcome 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@pranitpawar9837]

Thank you

[@ashokit]

You're Welcome 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@luisenriquegonzalez5130]

you are good

[@ashokit]

Thank You 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@deepakpareek3014]

Ashok sir, if db1 table wants to use db2 tables or suppose to join db1 table to db2 wht would be solution for that

[@ashokit]

Please Contact Our Admin Team:wa.me/[phone] 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@gobindasuniqueideas8247]

Not working... showing cycle dependency

[@avonzo]

This should not work as there are conflicting names used. Same name used in the same Spring Context in multiple places. Application (Spring framework) will present an error and would not start.

[@ASIFRAZA-qt1tf]

In case of same class name , User which is defined in two different com.ashokit.read.User Another one is com.ashokit.write.User In this case database understand which User class to use

[@alisonwalker2419]

dataSource or dataSourceClassName or jdbcUrl is required. ??

[@ashokit]

Please Contact Our Admin Team:wa.me/[phone] 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@mayureshsohani9913]

sir can you please share code here. getting compilation errors while creating Builder object

[@ashokit]

Please Contact Our Admin Team:wa.me/[phone] 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@danielclaire882]

I tried your solution but you don't show what's in the entities package. Other classes are also hidden. Do you have a github link where we can get this code and try this? Without the link, the solution doesn't help.

[@ashokit]

Please Contact Our Admin Team:wa.me/[phone] 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@lukamaletic9557]

Did you get the code? I was waiting for several days, but nothing...

[@nhv2607]

Do you have git hub link please?

[@ashokit]

Please Contact Our Admin Team:wa.me/[phone] 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@nguyenminhhieu1295]

I have an issue, my application can not find the EntityManagerFacotyBuilder

[@ashokit]

Please Contact Our Admin Team:wa.me/[phone] 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@user-wo6rs5jz1g]

I Tried this already but what if my database is totally dynamic and i need to switch the database in runtime? For example my conn info comes from my admin table where all my clients database conn info are stored. Which ever client uses the appplication it should switch the database on runtime. I was not able to acheive this using dynamic datasource routing and stuffs. Can you help me with that ?

[@ashokit]

Please Contact Our Admin Team:wa.me/[phone] 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@user-fi1sk6fl6s]

can you show Respository classes ?

[@ashokit]

Please Contact Our Admin Team:wa.me/[phone] 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj

[@Aigyan471]

I'm getting this error Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sourceEntityManagerFactory' defined in class path resource [com/example/ecommerceh/configuration/SourceDataConfig.class]: Unsatisfied dependency expressed through method 'sourceEntityManagerFactory' parameter 0: No qualifying bean of type 'org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {}

[@ashokit]

Please Contact Our Admin Team:wa.me/[phone] 👉 Subscribe To Our KZbin Channel: bit.ly/41IHJdj