Multiple JDBC Clients - How to configure multiple DataSources in Spring

Ғылым және технология

In this tutorial we will look at how to define multiple datasources in Spring Boot. This is important because if you want to use the JDBC Client for multiple datasources you need to know how to define your own datasource and then use that to create a new JDBC Client.
🔗Resources & Links mentioned in this video:
GitHub Repository: github.com/danvega/multiple-ds
JDBC Client vs Spring Data JDBC: • What is the difference...
👋🏻Connect with me:
Website: www.danvega.dev
Twitter: / therealdanvega
Github: github.com/danvega
LinkedIn: / danvega
Newsletter: www.danvega.dev/newsletter
SUBSCRIBE TO MY CHANNEL: bit.ly/2re4GH0 ❤️

Пікірлер: 67

  • @terteseamos579
    @terteseamos5795 күн бұрын

    Thank you @Dan Vega, You are just a blessing to us the Spring developer

  • @hctaw1
    @hctaw16 ай бұрын

    Well done Dan. Thanks for the smooth presentation 🙂

  • @null8735
    @null87356 ай бұрын

    As a student who is learning spring by myself, your video is really helpful even im not an Eng speaking country

  • @DanVega

    @DanVega

    6 ай бұрын

    Thank you so much. I love hearing from students and if you have anything you're having trouble with please let me know and I would be happy to help.

  • @djamdev
    @djamdev6 ай бұрын

    Interesting! Here's another question in the same direction: How can we implement multi-tenancy with Spring Boot, whether with JDBC or JPA DATA?

  • @nickamenthomson8874

    @nickamenthomson8874

    6 ай бұрын

    May be this might help you get insight. kzread.info/dash/bejne/onthsMunhNuaf5c.html

  • @DanVega

    @DanVega

    6 ай бұрын

    Thomas is the best! Thanks for sharing this

  • @peterponzel3422

    @peterponzel3422

    3 ай бұрын

    ✋same here - would be very interesting to see this for a multi-tenancy setup where a DataSource → JdbcClient is picked up during runtime based on some value(s) ... plus have this working with @org.springframework.transaction.annotation.Transactional annotations

  • @vishalmatam
    @vishalmatam6 ай бұрын

    You're doing a great job Dan!

  • @DanVega

    @DanVega

    6 ай бұрын

    I appreciate that! Thank you

  • @calebmbugua745
    @calebmbugua7455 ай бұрын

    Thank you, Really Awesome

  • @IbrahimOzis
    @IbrahimOzis6 ай бұрын

    Thank you 💐

  • @DanVega

    @DanVega

    6 ай бұрын

    Thank you for the question.

  • @praneethjayawardena7883
    @praneethjayawardena78836 ай бұрын

    Thank you Dan this is really helpful ❤ if you can make a video about restclient with OAuth2 integration calling apis with basic tokens much appreciated 😊 Thanks again 🙂

  • @DanVega

    @DanVega

    6 ай бұрын

    Thank you for the kind words and the suggestion.

  • @Anbu_Sampath
    @Anbu_Sampath6 ай бұрын

    Surprised to see co-pilot is spot-on with all the suggestion with Spring convention. Also Broadcom part at the start :)

  • @DanVega

    @DanVega

    6 ай бұрын

    I'm still unclear what sources CoPilot is using but it's obvious it's using either my history or local projects because I have an example that I worked up before I recorded this tutorial.

  • @JamesStansell

    @JamesStansell

    6 ай бұрын

    In November my team was told that copilot only used public sources from GitHub along with a subset of the files open in your IDE.

  • @zisoua
    @zisoua5 ай бұрын

    Thank you for the video! Do you plan to create videos about creating and connecting libraries and starters in Spring Boot?

  • @AleksandarT10
    @AleksandarT106 ай бұрын

    Great video Dan! Long overdue! Whats the preffered way to build a datasource from the 2 mentioned? Doesnt the second one create a HikariDataSource anyway?

  • @DanVega

    @DanVega

    6 ай бұрын

    If you look at the DataSourceBuilder it actually returns a HikariDataSource. I'm not sure there is a "correct" way to do things here, depends on your needs. If you just want a HikariDataSource though either of these will work.

  • @joachimdietl6737
    @joachimdietl67376 ай бұрын

    nice video!

  • @DanVega

    @DanVega

    6 ай бұрын

    Thank you! Cheers!

  • @sachinmisal4829
    @sachinmisal48296 ай бұрын

    Could you please make an same example using spring data jpa for multiple datasource instead multiple jdbcclient? I would be looking forward to see the video on multiple datasource using spring data jpa. Thank you so much for this awesome content.

  • @rafaelestevez9661
    @rafaelestevez96616 ай бұрын

    Nice video! my questions: does this work only for RDBMS? Is it possible to do this with a NoSQL and a SQL one?

  • @InaTiganas
    @InaTiganas6 ай бұрын

    Sub + Like. Great content! Here's another question. How would you connect to a DB (let's say Oracle) with mTLS?

  • @Herdhiantoko
    @Herdhiantoko3 ай бұрын

    what font did you use? I think I love it

  • @jopadjr
    @jopadjr6 ай бұрын

    85th...Thanks Dan. Great video. I learned a lot here mate !!! Maybe if I can suggest a topic on creating an API for a product or employee, etc deployed in the cloud (AWS, Azure, or GCP). Then someone then can use it like anyone writing an Android application.

  • @DanVega

    @DanVega

    6 ай бұрын

    Great suggestion. If you check my channel I have created a few videos on AWS Lambdas

  • @BechirBenOthman
    @BechirBenOthman3 ай бұрын

    hi Dan is it possible to make two entities with oneTomany relationship and store each one in sperate db ( mysql and postgresql)

  • @JamesStansell
    @JamesStansell6 ай бұрын

    At 23:18 why are your properties marked as unknown? You have configuration beans which specify those prefixes. If I recall correctly, in my apps we successfully used the spring.datasource prefix for our xxx and yyy DB config properties. The way you used your own prefix seemed great to me, only i don't understand why the IDE failed to recognize it.

  • @DanVega

    @DanVega

    6 ай бұрын

    I'm not sure why the IDE is yelling at me, maybe a rebuild would fix it 🤷‍♂️

  • @pablocaiza.
    @pablocaiza.6 ай бұрын

    good videos

  • @DanVega

    @DanVega

    6 ай бұрын

    Thank you!

  • @bkmzzenkov962
    @bkmzzenkov9626 ай бұрын

    Cool color scheme, can you tell me the name? Thank you!

  • @saikiranj807
    @saikiranj8075 ай бұрын

    Hi Dan! I tried something similar spring data JPA in the past, everything works fine if I use @Primary on one of the beans but spring doesn't autowire some other required dependency beans that are needed if I remove that annotation and everything falls apart, can you explain why that happens?

  • @utkarshsharma7931

    @utkarshsharma7931

    3 ай бұрын

    Can you once try with replacing @Primary wiith @Qualifier on both datasources.

  • @JaimeReyCasadoMonokepos
    @JaimeReyCasadoMonokepos6 ай бұрын

    great one!!! it's an elegant solution, but it looks like it won't scalate too well, i am not an expert, but replicating this with a dozen of schemas seems a bit madness. Is there another solution, maybe usin JPA or another valid approach? Thanks a lot for this and all your videos

  • @DanVega

    @DanVega

    6 ай бұрын

    I'm not sure I can think of a scenario where you have a dozen schemas. In that scenario it might make sense to break your monolith into microservices.

  • @ken_burns
    @ken_burns6 ай бұрын

    How can this be extended to provide multiple datasources to be used by spring data JPA repositories rather than JDBC clients ?

  • @zoladkow

    @zoladkow

    6 ай бұрын

    Sure - for each datasource you'd create an entity manager factory and a transaction manager (and you need to select which set of those is @Primary). Then for each datasource again you'd use @EnableJpaRepositories to link basePackages with specific entityManagerFactory and transactionManager - and since you'd need as many of those annotation as you'll need datasources, it's simpler to have a separate configuration class for each datasource and associated beans. Disclaimer: That's from the top of my head for an older version of Spring Boot. But i think if you search for specs of @EnableJpaRepositories you'll find good examples of multi-datasource JPA configs :)

  • @DanVega

    @DanVega

    6 ай бұрын

    Here is an example of that github.com/spring-projects/spring-data-examples/tree/main/jpa/multiple-datasources

  • @ken_burns

    @ken_burns

    6 ай бұрын

    Thanks Dan@@DanVega

  • @TommyLoupezVlogs
    @TommyLoupezVlogs5 ай бұрын

    JDBC or JDBC template ? which better ?

  • @DaviMello
    @DaviMello6 ай бұрын

    Sorry, I might be oversimplifying things but couldn’t you have just passed in JDBC values to each bean and then created the DataSources?

  • @DanVega

    @DanVega

    6 ай бұрын

    I'm not sure I understand but If you want to throw together a quick example based on mine that might help.

  • @sarkar_957
    @sarkar_9576 ай бұрын

    How about video on store the external api response into database and only required feilds from json response will be stored not all the things we get back, i think we will use jackson for that ig

  • @DanVega

    @DanVega

    6 ай бұрын

    So you call an API and get back an employee object back but you only want to store 5 of the 10 fields in the database. Are you storing the employee object JSON with those 5 fields or more data? Can you email me an example repo of this, would be happy to take a look.

  • @sarkar_957

    @sarkar_957

    6 ай бұрын

    @@DanVega I get an json response of let say 10 properties, and some of the properties are again json block inside it. I will store some of the fields of the response and others are ignored. And only the properties we want will be stored into DB,and also one required I'd for table nothing else. Also I came across an issue that I am getting a new response from same api every 20 sec and I want to store it using scheduler, but I came across many issues with it. I don't have repo for reference sorry

  • @hkkabir2024
    @hkkabir20246 ай бұрын

    i don't really unserstand why JDBC while we are using JPA ? one more thing. i know how to configure multiple datasource in spring with configuration file but the qustion is why? i have used application.properties / yaml gave multiple data source properties there and used both daasource at a time haivng no conflict and no issue. so if we can give all the data soruce config into application.properties and working fine then what is the necessity to use config file for multi datasoruce ???? would you like to explain it plz.

  • @DanVega

    @DanVega

    6 ай бұрын

    There are pros/cons to JDBC and JPA and I will try to get into that in an upcoming video. Do you have a sample where you configure multiple datasources using just properties that I can look at?

  • @hkkabir2024

    @hkkabir2024

    6 ай бұрын

    @@DanVega youtube is not giving me permission to give link here . i gave u on facbook commnets. would you like to check that

  • @vladprudius7622
    @vladprudius76226 ай бұрын

    Still the question is who will use jdbc client (or what are the benefits of using jdbc client) when we have a hibernate ?

  • @DanVega

    @DanVega

    6 ай бұрын

    What if you have a small project and don't need Hibernate? What if you or your team doesn't have experience with JPA? I understand the benefits of JPA but not every project calls for it.

  • @vladprudius7622

    @vladprudius7622

    6 ай бұрын

    @@DanVega you describe PET project =(

  • @aleksandarvanced5434

    @aleksandarvanced5434

    6 ай бұрын

    Plain Jdbc is king and u have full control. I have seen many people use Hibernate and they struggle with some more complex things

  • @DanVega

    @DanVega

    6 ай бұрын

    @@vladprudius7622 What do you mean by PET project? Like a personal one? if that's the case it's simply not true. I know many large organizations who aren't using JPA

  • @arpit8273
    @arpit82732 ай бұрын

    I think the full screen with code would be better! It does not help to see your face. or may be keep it smaller

  • @nipuna_perera
    @nipuna_perera6 ай бұрын

    I requested this piece of shit from you a few months ago. But I didn't get a response. Anyway, here we are!

  • @DanVega

    @DanVega

    6 ай бұрын

    I get a lot of questions and unfortunately don't have a good way of organizing them and responding. I'm sorry I didn't get to yours but happy we ended up here with a response.

  • @flaviaamaraldiniz7150

    @flaviaamaraldiniz7150

    6 ай бұрын

    @@DanVegayou are such a gentleman 😅

  • @DanVega

    @DanVega

    6 ай бұрын

    @@flaviaamaraldiniz7150 Life is too short to be involved in such things 🤷‍♂️😂

  • @nipuna_perera

    @nipuna_perera

    6 ай бұрын

    @@DanVega Hey Dan! Didn't mean to offend you. Just expressed my excitement seeing this as this was a long-awaited problem for me. I'm really grateful to you, as I have learned a lot from your channel. 😍🤩

  • @krushangshah7505
    @krushangshah75056 ай бұрын

    sir you are making it too hard

Келесі