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

[@SohamDutta222]

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

[@iampradeephr]

One of the best in depth explanations ever 🔥

[@SeleniumExpress]

Thank you 😊

[@tus62]

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

[@alcoverp]

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

[@Bindas_Raja]

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

[@54nehatiwari96]

2nd half done. Thank you so much .

[@jesuslovesyou8664]

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

[@harleyseixas8708]

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

[@shirokuma145]

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

[@shirokuma145]

2nd Half Done, many thanks for the tutorial!

[@ujjwalpandey4721]

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

[@pothinenivenkat]

ధన్యవాదాలు!

[@AnkitLadha-fo8em]

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

[@ashutoshsatapathy2477]

2nd Half Done, Thanks for this informative video.

[@techsavy641]

Bro next level editing and lessons too..Thanksssssss...

[@biswajeetsahoochintu2329]

Best depth concept you explained abhilash
Jay jaganath 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 .

[@12345ms]

Really good @Abhilash, 2nd half done

[@virupakshak4746]

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

[@priyanshu4016]

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

[@gowtham4383]

Thanks bro .

[@avalagum7957]

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.

[@SeleniumExpress]

@@avalagum7957 noted 😊

[@msvchalapathy]

Fabulous topic. Thank you for this session

[@SeleniumExpress]

My pleasure 😊

[@user-kn4dc2ek5z]

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... 😊

[@jaafarhamza3402]

2nd half done. Thank you

[@maharishi1]

Thank you Abhilash...

[@saruth]

you are best!

[@SeleniumExpress]

❤

[@arpansrivastava7537]

Very nice 👍👍

[@rahulbhatanagar6175]

1st half done 👍

[@srinivasn7991]

Clear understandng each and everthing

[@SeleniumExpress]

Thank you so much, Srinivasan ❤️

[@pranjitmedhi6764]

great work

[@programmer_kt]

I like your shirt.

[@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

[@priyanshu4016]

first half done 👍

[@srigakolapuatchuthasai6638]

Thanks Abhi ❤

[@SeleniumExpress]

❤️

[@mohammedirfan5744]

Thanks sir

[@ivorpersonal]

I really like your videos and your approach. 😊
1. I find it confusing when mixing plural and singular. You always have to remember or check in which occasion which is used. Also for people who don't know English too well creating plural can be confusing because of complicated rules in English for creating plurals. Also when searching item you have to search both in plural and singular. Also because of plural table you now need this extra line @Table which makes the code more complicated. Like when at the end of the video you were writing SELECT * FROM ORDER instead of ORDERS :).
2. Why don't you use Lombok @Data for Setters, Getters & Constructors. All this extra code makes the code look more complicated.
3, If not using autogenerated Id you will probably have to constantly delete inserted records in order to insert new ones (as was the case in your other videos) which I think unnecessary adds to the length of the video, if you forget then things don't work and all in all it wastes time and breaks concentration from more important things.
4. Why do you call it ProductDAO instead of ProductRepository. It is confusing when using different name for the same thig DAO vs Repository. Now I have to remember to map DAO to Repository - so the DAO name isn't very descriptive that we are actually using Repository. When I watch other tutorials they usually name it like that. They use DAO in case they don't use Repository - for instance when they use JdbcTemplate to work with Database.
5. Maybe instead of different Databases we could try connecting to different Schemas in the same Database.
6. Also maybe to disable hints that liters the code with "no usages" to make the code more readable.
7. Why do we have to manfully create Datasource? How come previously Spring Boot was able to create it automatically from DatasourceProperties Bean. Why can't Spring Boot simply use our DatasourceProperties Bean to create Datasource as before. We have just changed how DatasourceProperties Bean is created. Why would Spring Boot care how DatasourceProperties Bean is created in order to use it to create Datasource Bean.
8. I don't think it makes sense to create a Package for every Class. Usually people create Package entity or entities and there they put ALL of their entities. And again I prefer using singular entitiy everywhere. So you did it to later use Package to define responsibility for different Entity managers?
9. Maybe to use simple English names like John when creating examples. Its easier to follow and remember.
10. How come Spring Boot looks for Bean with specific name rather then interfaces as in all other cases? Why is this different?
11, @EnableJPARepositores changes application so much. App becomes unmanageable. It can't automatically find and use repositories. Now you constantly have to align and configure whenever creating new repository. Instead of simply creating repos wherever you like and having them picked up by Spring Boot. I think this hugely increases complexity. Suddenly you can't use your app like you were used to use it. Isn't there a better way? The main point of Spring Boot is to reduce configuration and our configuration just exploded.
12. Why is save() falling under Transaction when we haven't used @Transactioanl anywhere? What I have seen is that @Transactioanl might have additional parameter specifying which transaction manager to use. So do we need Transaction Manager if @Transactional is not used?

[@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.

[@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

[@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?

[@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

[@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?

[@Lalitprasad1]

Hello Sir,
In my case the EntityManagerFactoryBuilder is not getting created automatically, I'm getting the below error
Consider defining a bean of type 'org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder' in your configuration.

[@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....

[@debiprasaddash654]

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

[@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!

[@premraj.m]

47:30 keypoint

[@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.

[@teklehaimanotatikilt1435]

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

[@TomarSahab]

I spent one day until I found you also have the same error 1:00:19

[@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")

[@ganirasafarli8646]

Hi. Did you find the solution to this issue? I am getting exact problem.