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 ❤️

[@hctaw1]

Well done Dan. Thanks for the smooth presentation 🙂

[@null8735]

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

[@DanVega]

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]

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]

May be this might help you get insight. kzbin.info/www/bejne/pniQf5ykid1nhZY

[@DanVega]

Thomas is the best! Thanks for sharing this

[@peterponzel3422]

✋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]

You're doing a great job Dan!

[@DanVega]

I appreciate that! Thank you

[@calebmbugua745]

Thank you, Really Awesome

[@Anbu_Sampath]

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

[@DanVega]

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]

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.

[@IbrahimOzis]

Thank you 💐

[@DanVega]

Thank you for the question.

[@praneethjayawardena7883]

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]

Thank you for the kind words and the suggestion.

[@zisoua]

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

[@sachinmisal4829]

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.

[@AleksandarT10]

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]

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.

[@InaTiganas]

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

[@rafaelestevez9661]

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

[@Herdhiantoko]

what font did you use? I think I love it

[@jopadjr]

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]

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

[@joachimdietl6737]

nice video!

[@DanVega]

Thank you! Cheers!

[@BechirBenOthman]

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

[@TommyLoupezVlogs]

JDBC or JDBC template ? which better ?

[@pablocaiza.]

good videos

[@DanVega]

Thank you!

[@JamesStansell]

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]

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

[@bkmzzenkov962]

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

[@saikiranj807]

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]

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

[@sarkar_957]

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]

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]

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

[@JaimeReyCasadoMonokepos]

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]

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.

[@hkkabir2024]

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]

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]

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

[@ken_burns]

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

[@zoladkow]

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]

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

[@ken_burns]

Thanks Dan@@DanVega

[@vladprudius7622]

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

[@DanVega]

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]

@@DanVega you describe PET project =(

[@aleksandarvanced5434]

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]

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

[@DaviMello]

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]

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

[@arpit8273]

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

[@krushangshah7505]

sir you are making it too hard

[@nipuna_perera]

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

[@DanVega]

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]

@@DanVegayou are such a gentleman 😅

[@DanVega]

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

[@nipuna_perera]

@@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. 😍🤩