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

Поділитися
Вставка
  • Опубліковано 22 лис 2024

КОМЕНТАРІ • 94

  • @Alek5andr
    @Alek5andr Місяць тому

    I liked the way of getting errors, describing and solving them step by step during the build of the app.

  • @iampradeephr
    @iampradeephr 7 місяців тому +16

    One of the best in depth explanations ever 🔥

    • @SeleniumExpress
      @SeleniumExpress  7 місяців тому +2

      Thank you 😊

    • @jeremiahnji6
      @jeremiahnji6 2 місяці тому

      I agree!

    • @AdityaSinghRajput-zq4yn
      @AdityaSinghRajput-zq4yn 14 днів тому

      @@SeleniumExpress sir please please please please please please please please please please please please please please make one video on many to many like you have made on one to one bi diraction mapping

  • @sourishravichandren3837
    @sourishravichandren3837 2 місяці тому +1

    Explanation was Amazing!!! Greatest video on Multiple Datasource

  • @alcoverp
    @alcoverp 4 місяці тому +1

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

  • @SohamDutta222
    @SohamDutta222 3 місяці тому

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

  • @Bindas_Raja
    @Bindas_Raja 6 місяців тому +1

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

  • @tus62
    @tus62 3 місяці тому

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

  • @shirokuma145
    @shirokuma145 7 місяців тому +1

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

    • @shirokuma145
      @shirokuma145 7 місяців тому +1

      2nd Half Done, many thanks for the tutorial!

  • @jesuslovesyou8664
    @jesuslovesyou8664 7 місяців тому

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

  • @pothinenivenkat
    @pothinenivenkat 7 місяців тому +1

    ధన్యవాదాలు!

  • @ujjwalpandey4721
    @ujjwalpandey4721 6 місяців тому

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

  • @AnkitLadha-fo8em
    @AnkitLadha-fo8em 7 місяців тому

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

  • @srinivasulumannem4137
    @srinivasulumannem4137 6 місяців тому +1

    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 .

  • @techsavy641
    @techsavy641 4 місяці тому +1

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

  • @MarceloGarciaPerfil
    @MarceloGarciaPerfil 2 місяці тому

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

  • @JakubLattenberk
    @JakubLattenberk 22 дні тому

    Nice tutorial 👍 is it possible to implement this approach but in the way that you have multiple tenants and some tenants are using mssql and others pg ?

  • @harleyseixas8708
    @harleyseixas8708 6 місяців тому

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

  • @AbhishekAnandDas
    @AbhishekAnandDas 7 місяців тому

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

  • @virupakshak4746
    @virupakshak4746 7 місяців тому

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

  • @12345ms
    @12345ms 4 місяці тому

    Really good @Abhilash, 2nd half done

  • @edgarangelveradelrio3645
    @edgarangelveradelrio3645 6 місяців тому

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

  • @ashutoshsatapathy2477
    @ashutoshsatapathy2477 4 місяці тому

    2nd Half Done, Thanks for this informative video.

  • @biswajeetsahoochintu2329
    @biswajeetsahoochintu2329 7 місяців тому

    Best depth concept you explained abhilash
    Jay jaganath abhilash

  • @msvchalapathy
    @msvchalapathy 7 місяців тому

    Fabulous topic. Thank you for this session

  • @54nehatiwari96
    @54nehatiwari96 3 місяці тому

    2nd half done. Thank you so much .

  • @tech_excellence
    @tech_excellence 15 днів тому

    very good content, thanks

  • @RameshDornala-b3f
    @RameshDornala-b3f 7 місяців тому

    Thanks Abhi🤝❤. as always you explained well

  • @Manskobus
    @Manskobus Місяць тому

    Thanks and well done on an excellent video!

  • @avalagum7957
    @avalagum7957 3 місяці тому

    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.

  • @priyanshu4016
    @priyanshu4016 7 місяців тому

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

  • @maharishi1
    @maharishi1 6 місяців тому

    Thank you Abhilash...

  • @slaegridere3385
    @slaegridere3385 6 днів тому

    Thank you so much!!

  • @rahulbhatanagar6175
    @rahulbhatanagar6175 6 місяців тому

    1st half done 👍

  • @rajannam8279
    @rajannam8279 18 днів тому

    Hi @Abhilash
    I have a query , after making configuration classes for both mysql and postgresql . we have created a datasourceproperties and DataSource class.
    when we ran the app to save the product , the error is like there is no entitymanager but springboot internally has to configure the entitymanager and transactionmanager and other beans with the existing dataSource bean but we have 2 different datasource beans in the spring container , so the error should be required a single bean, but 2 were found , but we have made a datasource bean as @Primary which is no where related to entity manager error we got..
    could you elaborate this exception and the why we have used @Primary to resolve this.?

  • @jaafarhamza3402
    @jaafarhamza3402 6 місяців тому

    2nd half done. Thank you

  • @arpansrivastava7537
    @arpansrivastava7537 6 місяців тому

    Very nice 👍👍

  • @in_tyler_we_trust
    @in_tyler_we_trust 7 місяців тому

    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!

  • @ophemtech
    @ophemtech 6 місяців тому

    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?

  • @sahukarinaveenkumar3188
    @sahukarinaveenkumar3188 6 місяців тому

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

  • @balakrishna9437
    @balakrishna9437 7 місяців тому

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

    • @SeleniumExpress
      @SeleniumExpress  7 місяців тому +1

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

  • @caffeinejavacode1475
    @caffeinejavacode1475 25 днів тому

    If I send POST request. Will app save two row in MySQL and Postgres?

  • @ritunjaykumar5428
    @ritunjaykumar5428 6 місяців тому

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

  • @kalaimaranmadhavan4182
    @kalaimaranmadhavan4182 6 місяців тому

    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

  • @priyanshu4016
    @priyanshu4016 7 місяців тому

    first half done 👍

  • @pavankumar-mt3gm
    @pavankumar-mt3gm 6 місяців тому

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

  • @srinivasn7991
    @srinivasn7991 7 місяців тому

    Clear understandng each and everthing

  • @pranjitmedhi6764
    @pranjitmedhi6764 6 місяців тому

    great work

  • @DivyaShree-z3m
    @DivyaShree-z3m 6 місяців тому

    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

  • @dipeshvishwakarma5671
    @dipeshvishwakarma5671 7 місяців тому +1

    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

  • @saruth
    @saruth 7 місяців тому +1

    you are best!

  • @kunwarrajneeshsingh3132
    @kunwarrajneeshsingh3132 6 місяців тому

    2nd half done

  • @teklehaimanotatikilt1435
    @teklehaimanotatikilt1435 7 місяців тому

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

  • @srigakolapuatchuthasai6638
    @srigakolapuatchuthasai6638 7 місяців тому

    Thanks Abhi ❤

  • @sarathchandra941
    @sarathchandra941 7 місяців тому

    1st half done

  • @debanandamahata5726
    @debanandamahata5726 Місяць тому

    Sir, EntityManaherFactoryBuilder not injected, what i do?

  • @gowtham4383
    @gowtham4383 5 місяців тому

    Thanks bro .

  • @sonaliparida4365
    @sonaliparida4365 13 днів тому

    When i am adding dual Data source it saying one error failed to configure Data source url but i gave correct user name password and url and added the application yaml file in class path but still showing same error. How to solve this please tell...😢

  • @mohammedirfan5744
    @mohammedirfan5744 7 місяців тому

    Thanks sir

  • @ivorpersonal
    @ivorpersonal 3 місяці тому

    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?

  • @programmer_kt
    @programmer_kt 4 місяці тому

    I like your shirt.

  • @Lalitdrprasad
    @Lalitdrprasad 4 місяці тому

    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.

    • @tomobrezami9781
      @tomobrezami9781 2 місяці тому

      I have same issues but I add @Primary on one of DataSource than it work

  • @premraj.m
    @premraj.m 7 місяців тому

    47:30 keypoint

  • @debiprasaddash654
    @debiprasaddash654 7 місяців тому +1

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

  • @mdnishat9560
    @mdnishat9560 7 місяців тому

    Bro please complete the playlist of word guess game🤗🤗

    • @SeleniumExpress
      @SeleniumExpress  7 місяців тому +1

      Tomorrow you will get a new episode 🙂

  • @TomarSahab
    @TomarSahab 4 місяці тому

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

  • @perkypleyar
    @perkypleyar 2 місяці тому

    Hinglish

  • @PradeepKumar-sx6ms
    @PradeepKumar-sx6ms 7 місяців тому

    If I give challenges you like to crack???

  • @vlarunrajesh
    @vlarunrajesh 6 місяців тому

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

  • @punitvishwakarma718
    @punitvishwakarma718 6 місяців тому

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

  • @someshwarreddy8463
    @someshwarreddy8463 2 місяці тому

  • @someshwarreddy8463
    @someshwarreddy8463 2 місяці тому

  • @ayushsingh2431
    @ayushsingh2431 7 місяців тому

    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
      @SeleniumExpress  7 місяців тому

      Hi Ayush ! Make one of your datasource as Primary.

    • @arpitrajput6424
      @arpitrajput6424 7 місяців тому

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

    • @arpitrajput6424
      @arpitrajput6424 7 місяців тому

      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
      @ganirasafarli8646 4 місяці тому

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

  • @someshwarreddy8463
    @someshwarreddy8463 2 місяці тому

  • @MarceloGarciaPerfil
    @MarceloGarciaPerfil 2 місяці тому

    1st half done