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:

👋🏻Connect with me:

[hctaw]

Well done Dan. Thanks for the smooth presentation 🙂

[terteseamos]

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

[null]

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

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

[praneethjayawardena]

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 🙂

[Anbu_Sampath]

Surprised to see co-pilot is spot-on with all the suggestion with Spring convention.

Also Broadcom part at the start :)

[zisoua]

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

[AleksandarT]

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?

[Herdhiantoko]

what font did you use? I think I love it

[BechirBenOthman]

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

[rafaelestevez]

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

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

[sachinmisal]

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.

[InaTiganas]

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

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

[ken_burns]

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

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

[saikiranj]

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?

[sarkar_]

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

[TommyLoupezVlogs]

JDBC or JDBC template ? which better ?