Multiple JDBC Clients - How to configure multiple DataSources in Spring

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

[@terteseamos579]

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

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

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

[@misigarodev]

+1

[@hctaw1]

Well done Dan. Thanks for the smooth presentation 🙂

[@vishalmatam]

You're doing a great job Dan!

[@DanVega]

I appreciate that! Thank you

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

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

[@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 🤷‍♂️

[@IbrahimOzis]

Thank you 💐

[@DanVega]

Thank you for the question.

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

[@calebmbugua745]

Thank you, Really Awesome

[@rafaelestevez9661]

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

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

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

[@Talaria.School]

thanks, nice topic

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

[@BechirBenOthman]

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

[@a7md0_]

How to specify the data source when using JDBC Data Repository interface annotation?

[@redlightrobber]

Thank you Dan. This helps but does not solve my problem. I am looking for a way to create DataSources and their associated JdbcTemplates dynamically. I do not want to create them at start up. I do not know what my data sources are at startup. And my data sources can change while the SpringBoot app is running. Essentially, I am looking for basics. I looking for the code to create DataSources on the fly, without @Bean, without @Configuration. I am looking to connect to 1 database "writer", and 1 to N database read replicates. I intend to code a "DataSourceManager". Can you point me to a simple example of how to create a DataSource, an associated JdbcTemplate, without beans?

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

[@Herdhiantoko]

what font did you use? I think I love it

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

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

[@joachimdietl6737]

nice video!

[@DanVega]

Thank you! Cheers!

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

[@TommyLoupezVlogs]

JDBC or JDBC template ? which better ?

[@musterknabe3223]

transaction handling is missing. Also the usage of Entitymanager is missing

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

[@pablocaiza.]

good videos

[@DanVega]

Thank you!

[@bkmzzenkov962]

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

[@InaTiganas]

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

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